######################################################################################################
test case:
###################################################
# 1) create table NINDB.NIM_TINFOBANK_SEND
###################################################

CREATE TABLE `NIM_TINFOBANK_SEND` (
  `SERVICE_ID` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT '서비스ID',
  `REQUEST_ID` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT '요청ID',
  `MESSAGE_ID` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT '메시지ID',
  `STATUS` int(11) NOT NULL COMMENT '상태',
  `INFOBANK_GROUP_ID` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '인포뱅크그룹ID',
  `INFOBANK_MESSAGE_ID` varchar(35) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '인포뱅크메시지ID',
  `RESULT_CODE` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '결과코드',
  `TTL` int(11) DEFAULT NULL COMMENT 'TTL',
  `MESSAGE_TYPE` int(11) DEFAULT NULL COMMENT '메시지타입',
  `REPORT_CODE` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '리포트코드',
  `COUNT` int(11) DEFAULT NULL COMMENT '갯수',
  `CARRIER` int(11) DEFAULT NULL COMMENT '착신망',
  `SEND_TS` datetime(6) DEFAULT NULL COMMENT '전송타임스탬프',
  `CREATE_TS` datetime(6) NOT NULL COMMENT '생성타임스탬프',
  `REPORT_TS` datetime(6) DEFAULT NULL COMMENT '리포트타임스탬프',
  `FST_REGR_ID` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '최초등록자ID',
  `FST_REG_TS` datetime(6) NOT NULL COMMENT '최초등록타임스탬프',
  `FNL_MDFR_ID` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '최종수정자ID',
  `FNL_MDFY_TS` datetime(6) NOT NULL COMMENT '최종수정타임스탬프',
  PRIMARY KEY (`SERVICE_ID`,`REQUEST_ID`,`MESSAGE_ID`),
  UNIQUE KEY `NIM_TINFOBANK_SEND_UX1` (`MESSAGE_ID`),
  KEY `NIM_TINFOBANK_SEND_IX1` (`INFOBANK_GROUP_ID`,`INFOBANK_MESSAGE_ID`),
  KEY `NIM_TINFOBANK_SEND_IX2` (`STATUS`),
  KEY `NIM_TINFOBANK_SEND_IX3` (`CREATE_TS`),
  KEY `NIM_TINFOBANK_SEND_IX4` (`CARRIER`,`INFOBANK_MESSAGE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='인포뱅크전송';

###################################################
# 2) checking data from binary log
###################################################

# mysqlbinlog -v --start-position=152968 --stop-position=153403 mysql5888-bin.006596
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#220404 15:07:07 server id 5888  end_log_pos 256 CRC32 0xe1fd7d65       Start: binlog v 4, server v 10.3.32-MariaDB-log created 220404 15:07:07
# Warning: this binlog is either in use or was not closed properly.
BINLOG '
C4tKYg8AFwAA/AAAAAABAAABAAQAMTAuMy4zMi1NYXJpYURCLWxvZwAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAEEwQADQgICAoKCgFlff3h
'/*!*/;
# at 152968
#220404 15:09:00 server id 5888  end_log_pos 152999 CRC32 0x2a1e01d5    Xid = 156317295
COMMIT/*!*/;
# at 152999
#220404 15:09:00 server id 5888  end_log_pos 153041 CRC32 0x5850ee1d    GTID 0-5888-545189833 trans
/*!100101 SET @@session.skip_parallel_replication=0*//*!*/;
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=5888*//*!*/;
/*!100001 SET @@session.gtid_seq_no=545189833*//*!*/;
BEGIN
/*!*/;
# at 153041
#220404 15:09:00 server id 5888  end_log_pos 153142 CRC32 0xb9b4b926    Table_map: `NINDB`.`NIM_TINFOBANK_SEND` mapped to number 2366
# at 153142
#220404 15:09:00 server id 5888  end_log_pos 153372 CRC32 0x1a66d730    Write_rows: table id 2366 flags: STMT_END_F

BINLOG '
fItKYhMAFwAAZQAAADZWAgAAAD4JAAAAAAEABU5JTkRCABJOSU1fVElORk9CQU5LX1NFTkQAEw8P
DwMPDw8DAw8DAwwMEg8MDwwTgAGAAYABVABpAB4AHgAGlgCWAPBfACa5tLk=
fItKYhcAFwAA5gAAABxXAgAAAD4JAAAAAAEAE/////BX+CkAY3BhYXNfaW5fMjAyMjAxMTEwNzQy
MTQ1MzEyMjUyNzAwMDAwMDEyNDYgADIwMjIwNDA0MDYwOTAwMDg2MjI1MjcwMDAwMDAwMDUxJQAy
MDIyMDQwNDA2MDkwMDA4NjIyNTI3MDAwMDAwMDA1MTAwMDAwAAAAABAnAAABAjxnnxyKGBVtZXNz
YWdlLW1hbmFnZXItMjI1MjcBAjxnnxyKGBVtZXNzYWdlLW1hbmFnZXItMjI1MjcBAjxnnxyKGDDX
Zho=
'/*!*/;
### INSERT INTO `NINDB`.`NIM_TINFOBANK_SEND`
### SET
###   @1='cpaas_in_20220111074214531225270000001246'
###   @2='20220404060900086225270000000051'
###   @3='2022040406090008622527000000005100000'
###   @4=0
###   @5=NULL
###   @6=NULL
###   @7=NULL
###   @8=NULL
###   @9=NULL
###   @10=NULL
###   @11=NULL
###   @12=10000
###   @13=NULL
###   @14='176825727-46-53 70:47:05'
###   @15=NULL
###   @16='message-manager-22527'
###   @17='176825727-46-53 70:47:05'
###   @18='message-manager-22527'
###   @19='176825727-46-53 70:47:05'
# Number of rows: 1
# at 153372
#220404 15:09:00 server id 5888  end_log_pos 153403 CRC32 0xec47d524    Xid = 156317297
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
###################################################
# 3) insert data using mysqlbinlog tool
###################################################

[root@server01 IMSI]# mysqlbinlog -v --start-position=152968 --stop-position=153403 mysql5888-bin.006596 | mysql

###################################################
# 4) checking datatime column
###################################################

[root@server01 IMSI]# mysql -e "select * from NINDB.NIM_TINFOBANK_SEND";
+-------------------------------------------+----------------------------------+---------------------------------------+--------+-------------------+---------------------+-------------+------+--------------+-------------+-------+---------+---------+----------------------------+-----------+-----------------------+----------------------------+-----------------------+----------------------------+
| SERVICE_ID                                | REQUEST_ID                       | MESSAGE_ID                            | STATUS | INFOBANK_GROUP_ID | INFOBANK_MESSAGE_ID | RESULT_CODE | TTL  | MESSAGE_TYPE | REPORT_CODE | COUNT | CARRIER | SEND_TS | CREATE_TS                  | REPORT_TS | FST_REGR_ID           | FST_REG_TS                 | FNL_MDFR_ID           | FNL_MDFY_TS                |
+-------------------------------------------+----------------------------------+---------------------------------------+--------+-------------------+---------------------+-------------+------+--------------+-------------+-------+---------+---------+----------------------------+-----------+-----------------------+----------------------------+-----------------------+----------------------------+
| cpaas_in_20220111074214531225270000001246 | 20220404060900086225270000000051 | 2022040406090008622527000000005100000 |      0 | NULL              | NULL                | NULL        | NULL |         NULL | NULL        |  NULL |   10000 | NULL    | 2022-04-04 06:09:00.095000 | NULL      | message-manager-22527 | 2022-04-04 06:09:00.095000 | message-manager-22527 | 2022-04-04 06:09:00.095000 |
+-------------------------------------------+----------------------------------+---------------------------------------+--------+-------------------+---------------------+-------------+------+--------------+-------------+-------+---------+---------+----------------------------+-----------+-----------------------+----------------------------+-----------------------+----------------------------+