rm -rf 93423 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/93423 --log-error-verbosity=3 bin/mysqld --basedir=$PWD --datadir=$PWD/93423 --core-file --socket=/tmp/mysql.sock --port=3333 --log-error=$PWD/93423/log.err --log-bin=master-bin --server_id=1 2>&1 & set binlog_format='MIXED'; set binlog_row_image="full"; set tx_isolation='READ-COMMITTED'; create database a; create database b; create table a.test (id int primary key, name varchar(50) default null, age bigint); create table b.test (id int primary key, name varchar(50) default null, age bigint); insert into a.test(id, age) values (1,5), (2,10); /* This insert event is written with full row image in binary log */ insert into b.test(id,age) select id , age from a.test ; /* name column information is not present in row image */ -- 5.7.24 ### INSERT INTO `a`.`test` ### SET ### @1=1 ### @2=NULL ### @3=5 ### INSERT INTO `a`.`test` ### SET ### @1=2 ### @2=NULL ### @3=10 # at 1126 #181216 7:55:21 server id 1 end_log_pos 1157 CRC32 0x246161d0 Xid = 10 COMMIT/*!*/; # at 1157 #181216 7:55:21 server id 1 end_log_pos 1222 CRC32 0xcc2659e7 Anonymous_GTID last_committed=5 sequence_number=6 rbr_only=yes /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 1222 #181216 7:55:21 server id 1 end_log_pos 1290 CRC32 0x9983f2fd Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1544943321/*!*/; BEGIN /*!*/; # at 1290 #181216 7:55:21 server id 1 end_log_pos 1338 CRC32 0x137e79b9 Table_map: `b`.`test` mapped to number 109 # at 1338 #181216 7:55:21 server id 1 end_log_pos 1399 CRC32 0x7de2037d Write_rows: table id 109 flags: STMT_END_F BINLOG ' 2fYVXBMBAAAAMAAAADoFAAAAAG0AAAAAAAEAAWIABHRlc3QAAwMPCAIyAAa5eX4T 2fYVXB4BAAAAPQAAAHcFAAAAAG0AAAAAAAEAAgADBfwBAAAABQAAAAAAAAD8AgAAAAoAAAAAAAAA fQPifQ== '/*!*/; ### INSERT INTO `b`.`test` ### SET ### @1=1 ### @3=5 ### INSERT INTO `b`.`test` ### SET ### @1=2 ### @3=10 # at 1399 #181216 7:55:21 server id 1 end_log_pos 1430 CRC32 0x2f8ea17c Xid = 11 COMMIT/*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # at 1909 #181216 8:01:09 server id 1 end_log_pos 1970 CRC32 0xfc7d74c6 Write_rows: table id 110 flags: STMT_END_F - TRUNCATE TABLE a.test; TRUNCATE TABLE b.test; SET binlog_format="ROW"; insert into a.test(id, age) values (1,5), (2,10); /* This insert event is written with full row image in binary log */ insert into b.test(id,age) select id , age from a.test ; /* name column information is not present in row image */ BINLOG ' NfgVXBMBAAAAMAAAAHUHAAAAAG4AAAAAAAEAAWEABHRlc3QAAwMPCAIyAAY4qE4Y NfgVXB4BAAAAPQAAALIHAAAAAG4AAAAAAAEAAgAD//oBAAAABQAAAAAAAAD6AgAAAAoAAAAAAAAA xnR9/A== '/*!*/; ### INSERT INTO `a`.`test` ### SET ### @1=1 ### @2=NULL ### @3=5 ### INSERT INTO `a`.`test` ### SET ### @1=2 ### @2=NULL ### @3=10 # at 1970 #181216 8:01:09 server id 1 end_log_pos 2001 CRC32 0x87758a97 Xid = 20 COMMIT/*!*/; # at 2001 #181216 8:01:09 server id 1 end_log_pos 2066 CRC32 0x4e677330 Anonymous_GTID last_committed=9 sequence_number=10 rbr_only=yes /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 2066 #181216 8:01:09 server id 1 end_log_pos 2134 CRC32 0xfa6353fc Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1544943669/*!*/; BEGIN /*!*/; # at 2134 #181216 8:01:09 server id 1 end_log_pos 2182 CRC32 0xf2abdab9 Table_map: `b`.`test` mapped to number 111 # at 2182 #181216 8:01:09 server id 1 end_log_pos 2243 CRC32 0x003b6697 Write_rows: table id 111 flags: STMT_END_F BINLOG ' NfgVXBMBAAAAMAAAAIYIAAAAAG8AAAAAAAEAAWIABHRlc3QAAwMPCAIyAAa52qvy NfgVXB4BAAAAPQAAAMMIAAAAAG8AAAAAAAEAAgAD//oBAAAABQAAAAAAAAD6AgAAAAoAAAAAAAAA l2Y7AA== '/*!*/; ### INSERT INTO `b`.`test` ### SET ### @1=1 ### @2=NULL ### @3=5 ### INSERT INTO `b`.`test` ### SET ### @1=2 ### @2=NULL ### @3=10 # at 2243 #181216 8:01:09 server id 1 end_log_pos 2274 CRC32 0xbb183e53 Xid = 21 COMMIT/*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;