1set @old_binlog_checksum=@@binlog_checksum; 2set global binlog_checksum=NONE; 3set sql_mode=""; 4SET timestamp=1000000000; 5RESET MASTER; 6CREATE DATABASE test1; 7CREATE TABLE test1.t1(a int); 8CREATE DATABASE test2; 9CREATE TABLE test2.t2(a int); 10CREATE VIEW test2.v2 AS SELECT * FROM test2.t2; 11CREATE DATABASE test3; 12CREATE TABLE test3.t3(a int); 13CREATE DATABASE xtest1; 14CREATE TABLE xtest1.xt1(a int); 15CREATE DATABASE xtest2; 16CREATE TABLE xtest2.xt2(a int); 17INSERT INTO test1.t1 VALUES (1), (2), (3); 18SET SESSION binlog_annotate_row_events = ON; 19INSERT INTO test2.t2 VALUES (1), (2), (3); 20INSERT INTO test3.t3 VALUES (1), (2), (3); 21DELETE test1.t1, test2.t2 22FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3 23WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a; 24INSERT INTO xtest1.xt1 VALUES (1), (2), (3); 25INSERT INTO test2.v2 VALUES (1), (2), (3); 26DELETE xtest1.xt1, test2.t2 27FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3 28WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a; 29INSERT INTO xtest1.xt1 VALUES (1), (2), (3); 30INSERT INTO xtest2.xt2 VALUES (1), (2), (3); 31DELETE xtest1.xt1, xtest2.xt2 32FROM xtest1.xt1 INNER JOIN xtest2.xt2 INNER JOIN test3.t3 33WHERE xtest1.xt1.a=xtest2.xt2.a AND xtest2.xt2.a=test3.t3.a; 34FLUSH LOGS; 35##################################################################################### 36# The following Annotate_rows events should appear below: 37# - INSERT INTO test2.t2 VALUES (1), (2), (3) 38# - INSERT INTO test3.t3 VALUES (1), (2), (3) 39# - DELETE test1.t1, test2.t2 FROM <...> 40# - INSERT INTO test2.t2 VALUES (1), (2), (3) 41# - DELETE xtest1.xt1, test2.t2 FROM <...> 42##################################################################################### 43include/show_binlog_events.inc 44Log_name Pos Event_type Server_id End_log_pos Info 45master-bin.000001 # Gtid # # GTID #-#-# 46master-bin.000001 # Query # # CREATE DATABASE test1 47master-bin.000001 # Gtid # # GTID #-#-# 48master-bin.000001 # Query # # CREATE DATABASE test2 49master-bin.000001 # Gtid # # GTID #-#-# 50master-bin.000001 # Query # # CREATE DATABASE test3 51master-bin.000001 # Gtid # # BEGIN GTID #-#-# 52master-bin.000001 # Annotate_rows # # INSERT INTO test1.t1 VALUES (1), (2), (3) 53master-bin.000001 # Table_map # # table_id: # (test1.t1) 54master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 55master-bin.000001 # Query # # COMMIT 56master-bin.000001 # Gtid # # BEGIN GTID #-#-# 57master-bin.000001 # Annotate_rows # # INSERT INTO test2.t2 VALUES (1), (2), (3) 58master-bin.000001 # Table_map # # table_id: # (test2.t2) 59master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 60master-bin.000001 # Query # # COMMIT 61master-bin.000001 # Gtid # # BEGIN GTID #-#-# 62master-bin.000001 # Annotate_rows # # INSERT INTO test3.t3 VALUES (1), (2), (3) 63master-bin.000001 # Table_map # # table_id: # (test3.t3) 64master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 65master-bin.000001 # Query # # COMMIT 66master-bin.000001 # Gtid # # BEGIN GTID #-#-# 67master-bin.000001 # Annotate_rows # # DELETE test1.t1, test2.t2 68FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3 69WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a 70master-bin.000001 # Table_map # # table_id: # (test1.t1) 71master-bin.000001 # Table_map # # table_id: # (test2.t2) 72master-bin.000001 # Delete_rows_v1 # # table_id: # 73master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F 74master-bin.000001 # Query # # COMMIT 75master-bin.000001 # Gtid # # BEGIN GTID #-#-# 76master-bin.000001 # Annotate_rows # # INSERT INTO test2.v2 VALUES (1), (2), (3) 77master-bin.000001 # Table_map # # table_id: # (test2.t2) 78master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 79master-bin.000001 # Query # # COMMIT 80master-bin.000001 # Gtid # # BEGIN GTID #-#-# 81master-bin.000001 # Annotate_rows # # DELETE xtest1.xt1, test2.t2 82FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3 83WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a 84master-bin.000001 # Table_map # # table_id: # (test2.t2) 85master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F 86master-bin.000001 # Query # # COMMIT 87master-bin.000001 # Rotate # # master-bin.000002;pos=POS 88# 89##################################################################################### 90# mysqlbinlog 91# The following Annotates should appear in this output: 92# - INSERT INTO test2.t2 VALUES (1), (2), (3) 93# - INSERT INTO test3.t3 VALUES (1), (2), (3) 94# - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps) 95# - INSERT INTO test2.t2 VALUES (1), (2), (3) 96# - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map) 97##################################################################################### 98/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 99/*!40019 SET @@session.max_insert_delayed_threads=0*/; 100/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 101DELIMITER /*!*/; 102# at # 103#010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup 104ROLLBACK/*!*/; 105# at # 106#010909 4:46:40 server id # end_log_pos # Gtid list [] 107# at # 108#010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001 109# at # 110#010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl 111/*!100101 SET @@session.skip_parallel_replication=0*//*!*/; 112/*!100001 SET @@session.gtid_domain_id=0*//*!*/; 113/*!100001 SET @@session.server_id=1*//*!*/; 114/*!100001 SET @@session.gtid_seq_no=1*//*!*/; 115# at # 116#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 117SET TIMESTAMP=1000000000/*!*/; 118SET @@session.pseudo_thread_id=#/*!*/; 119SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/; 120SET @@session.sql_mode=0/*!*/; 121SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 122/*!\C latin1 *//*!*/; 123SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; 124SET @@session.lc_time_names=0/*!*/; 125SET @@session.collation_database=DEFAULT/*!*/; 126CREATE DATABASE test1 127/*!*/; 128# at # 129#010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl 130/*!100001 SET @@session.gtid_seq_no=2*//*!*/; 131# at # 132#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 133SET TIMESTAMP=1000000000/*!*/; 134CREATE DATABASE test2 135/*!*/; 136# at # 137#010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl 138/*!100001 SET @@session.gtid_seq_no=3*//*!*/; 139# at # 140#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 141SET TIMESTAMP=1000000000/*!*/; 142CREATE DATABASE test3 143/*!*/; 144# at # 145#010909 4:46:40 server id # end_log_pos # GTID 0-1-4 146/*!100001 SET @@session.gtid_seq_no=4*//*!*/; 147START TRANSACTION 148/*!*/; 149# at # 150# at # 151#010909 4:46:40 server id # end_log_pos # Annotate_rows: 152#Q> INSERT INTO test1.t1 VALUES (1), (2), (3) 153#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 154# at # 155#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 156### INSERT INTO `test1`.`t1` 157### SET 158### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 159### INSERT INTO `test1`.`t1` 160### SET 161### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 162### INSERT INTO `test1`.`t1` 163### SET 164### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 165# Number of rows: 3 166# at # 167#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 168SET TIMESTAMP=1000000000/*!*/; 169COMMIT 170/*!*/; 171# at # 172#010909 4:46:40 server id # end_log_pos # GTID 0-1-5 173/*!100001 SET @@session.gtid_seq_no=5*//*!*/; 174START TRANSACTION 175/*!*/; 176# at # 177# at # 178#010909 4:46:40 server id # end_log_pos # Annotate_rows: 179#Q> INSERT INTO test2.t2 VALUES (1), (2), (3) 180#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 181# at # 182#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 183### INSERT INTO `test2`.`t2` 184### SET 185### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 186### INSERT INTO `test2`.`t2` 187### SET 188### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 189### INSERT INTO `test2`.`t2` 190### SET 191### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 192# Number of rows: 3 193# at # 194#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 195SET TIMESTAMP=1000000000/*!*/; 196COMMIT 197/*!*/; 198# at # 199#010909 4:46:40 server id # end_log_pos # GTID 0-1-6 200/*!100001 SET @@session.gtid_seq_no=6*//*!*/; 201START TRANSACTION 202/*!*/; 203# at # 204# at # 205#010909 4:46:40 server id # end_log_pos # Annotate_rows: 206#Q> INSERT INTO test3.t3 VALUES (1), (2), (3) 207#010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number # 208# at # 209#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 210### INSERT INTO `test3`.`t3` 211### SET 212### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 213### INSERT INTO `test3`.`t3` 214### SET 215### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 216### INSERT INTO `test3`.`t3` 217### SET 218### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 219# Number of rows: 3 220# at # 221#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 222SET TIMESTAMP=1000000000/*!*/; 223COMMIT 224/*!*/; 225# at # 226#010909 4:46:40 server id # end_log_pos # GTID 0-1-7 227/*!100001 SET @@session.gtid_seq_no=7*//*!*/; 228START TRANSACTION 229/*!*/; 230# at # 231# at # 232#010909 4:46:40 server id # end_log_pos # Annotate_rows: 233#Q> DELETE test1.t1, test2.t2 234#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3 235#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3 236#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 237# at # 238#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 239# at # 240# at # 241#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # 242#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 243### DELETE FROM `test1`.`t1` 244### WHERE 245### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 246### DELETE FROM `test1`.`t1` 247### WHERE 248### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 249### DELETE FROM `test1`.`t1` 250### WHERE 251### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 252### DELETE FROM `test2`.`t2` 253### WHERE 254### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 255### DELETE FROM `test2`.`t2` 256### WHERE 257### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 258### DELETE FROM `test2`.`t2` 259### WHERE 260### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 261# Number of rows: 6 262# at # 263#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 264SET TIMESTAMP=1000000000/*!*/; 265COMMIT 266/*!*/; 267# at # 268#010909 4:46:40 server id # end_log_pos # GTID 0-1-8 269/*!100001 SET @@session.gtid_seq_no=8*//*!*/; 270START TRANSACTION 271/*!*/; 272# at # 273# at # 274#010909 4:46:40 server id # end_log_pos # Annotate_rows: 275#Q> INSERT INTO test2.v2 VALUES (1), (2), (3) 276#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 277# at # 278#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 279### INSERT INTO `test2`.`t2` 280### SET 281### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 282### INSERT INTO `test2`.`t2` 283### SET 284### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 285### INSERT INTO `test2`.`t2` 286### SET 287### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 288# Number of rows: 3 289# at # 290#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 291SET TIMESTAMP=1000000000/*!*/; 292COMMIT 293/*!*/; 294# at # 295#010909 4:46:40 server id # end_log_pos # GTID 0-1-9 296/*!100001 SET @@session.gtid_seq_no=9*//*!*/; 297START TRANSACTION 298/*!*/; 299# at # 300# at # 301#010909 4:46:40 server id # end_log_pos # Annotate_rows: 302#Q> DELETE xtest1.xt1, test2.t2 303#Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3 304#Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3 305#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 306# at # 307#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 308### DELETE FROM `test2`.`t2` 309### WHERE 310### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 311### DELETE FROM `test2`.`t2` 312### WHERE 313### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 314### DELETE FROM `test2`.`t2` 315### WHERE 316### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 317# Number of rows: 3 318# at # 319#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 320SET TIMESTAMP=1000000000/*!*/; 321COMMIT 322/*!*/; 323# at # 324#010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4 325DELIMITER ; 326# End of log file 327ROLLBACK /* added by mysqlbinlog */; 328/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 329/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 330# 331##################################################################################### 332# mysqlbinlog --database=test1 333# The following Annotate should appear in this output: 334# - DELETE test1.t1, test2.t2 FROM <...> 335##################################################################################### 336/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 337/*!40019 SET @@session.max_insert_delayed_threads=0*/; 338/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 339DELIMITER /*!*/; 340# at # 341#010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup 342ROLLBACK/*!*/; 343# at # 344#010909 4:46:40 server id # end_log_pos # Gtid list [] 345# at # 346#010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001 347# at # 348#010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl 349/*!100101 SET @@session.skip_parallel_replication=0*//*!*/; 350/*!100001 SET @@session.gtid_domain_id=0*//*!*/; 351/*!100001 SET @@session.server_id=1*//*!*/; 352/*!100001 SET @@session.gtid_seq_no=1*//*!*/; 353# at # 354#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 355SET TIMESTAMP=1000000000/*!*/; 356SET @@session.pseudo_thread_id=#/*!*/; 357SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/; 358SET @@session.sql_mode=0/*!*/; 359SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 360/*!\C latin1 *//*!*/; 361SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; 362SET @@session.lc_time_names=0/*!*/; 363SET @@session.collation_database=DEFAULT/*!*/; 364CREATE DATABASE test1 365/*!*/; 366# at # 367#010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl 368/*!100001 SET @@session.gtid_seq_no=2*//*!*/; 369# at # 370# at # 371#010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl 372/*!100001 SET @@session.gtid_seq_no=3*//*!*/; 373# at # 374# at # 375#010909 4:46:40 server id # end_log_pos # GTID 0-1-4 376/*!100001 SET @@session.gtid_seq_no=4*//*!*/; 377START TRANSACTION 378/*!*/; 379# at # 380# at # 381#010909 4:46:40 server id # end_log_pos # Annotate_rows: 382#Q> INSERT INTO test1.t1 VALUES (1), (2), (3) 383#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 384# at # 385#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 386### INSERT INTO `test1`.`t1` 387### SET 388### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 389### INSERT INTO `test1`.`t1` 390### SET 391### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 392### INSERT INTO `test1`.`t1` 393### SET 394### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 395# Number of rows: 3 396# at # 397#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 398SET TIMESTAMP=1000000000/*!*/; 399COMMIT 400/*!*/; 401# at # 402#010909 4:46:40 server id # end_log_pos # GTID 0-1-5 403/*!100001 SET @@session.gtid_seq_no=5*//*!*/; 404START TRANSACTION 405/*!*/; 406# at # 407# at # 408# at # 409# at # 410#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 411SET TIMESTAMP=1000000000/*!*/; 412COMMIT 413/*!*/; 414# at # 415#010909 4:46:40 server id # end_log_pos # GTID 0-1-6 416/*!100001 SET @@session.gtid_seq_no=6*//*!*/; 417START TRANSACTION 418/*!*/; 419# at # 420# at # 421# at # 422# at # 423#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 424SET TIMESTAMP=1000000000/*!*/; 425COMMIT 426/*!*/; 427# at # 428#010909 4:46:40 server id # end_log_pos # GTID 0-1-7 429/*!100001 SET @@session.gtid_seq_no=7*//*!*/; 430START TRANSACTION 431/*!*/; 432# at # 433# at # 434#010909 4:46:40 server id # end_log_pos # Annotate_rows: 435#Q> DELETE test1.t1, test2.t2 436#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3 437#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3 438#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 439# at # 440# at # 441# at # 442#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # 443### DELETE FROM `test1`.`t1` 444### WHERE 445### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 446### DELETE FROM `test1`.`t1` 447### WHERE 448### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 449### DELETE FROM `test1`.`t1` 450### WHERE 451### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 452# at # 453#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 454SET TIMESTAMP=1000000000/*!*/; 455COMMIT 456/*!*/; 457# at # 458#010909 4:46:40 server id # end_log_pos # GTID 0-1-8 459/*!100001 SET @@session.gtid_seq_no=8*//*!*/; 460START TRANSACTION 461/*!*/; 462# at # 463# at # 464# at # 465# at # 466#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 467SET TIMESTAMP=1000000000/*!*/; 468COMMIT 469/*!*/; 470# at # 471#010909 4:46:40 server id # end_log_pos # GTID 0-1-9 472/*!100001 SET @@session.gtid_seq_no=9*//*!*/; 473START TRANSACTION 474/*!*/; 475# at # 476# at # 477# at # 478# at # 479#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 480SET TIMESTAMP=1000000000/*!*/; 481COMMIT 482/*!*/; 483# at # 484#010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4 485DELIMITER ; 486# End of log file 487ROLLBACK /* added by mysqlbinlog */; 488/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 489/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 490# 491##################################################################################### 492# mysqlbinlog --skip-annotate-row-events 493# No Annotates should appear in this output 494##################################################################################### 495/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 496/*!40019 SET @@session.max_insert_delayed_threads=0*/; 497/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 498DELIMITER /*!*/; 499# at # 500#010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup 501ROLLBACK/*!*/; 502# at # 503#010909 4:46:40 server id # end_log_pos # Gtid list [] 504# at # 505#010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001 506# at # 507#010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl 508/*!100101 SET @@session.skip_parallel_replication=0*//*!*/; 509/*!100001 SET @@session.gtid_domain_id=0*//*!*/; 510/*!100001 SET @@session.server_id=1*//*!*/; 511/*!100001 SET @@session.gtid_seq_no=1*//*!*/; 512# at # 513#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 514SET TIMESTAMP=1000000000/*!*/; 515SET @@session.pseudo_thread_id=#/*!*/; 516SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/; 517SET @@session.sql_mode=0/*!*/; 518SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 519/*!\C latin1 *//*!*/; 520SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; 521SET @@session.lc_time_names=0/*!*/; 522SET @@session.collation_database=DEFAULT/*!*/; 523CREATE DATABASE test1 524/*!*/; 525# at # 526#010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl 527/*!100001 SET @@session.gtid_seq_no=2*//*!*/; 528# at # 529#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 530SET TIMESTAMP=1000000000/*!*/; 531CREATE DATABASE test2 532/*!*/; 533# at # 534#010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl 535/*!100001 SET @@session.gtid_seq_no=3*//*!*/; 536# at # 537#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 538SET TIMESTAMP=1000000000/*!*/; 539CREATE DATABASE test3 540/*!*/; 541# at # 542#010909 4:46:40 server id # end_log_pos # GTID 0-1-4 543/*!100001 SET @@session.gtid_seq_no=4*//*!*/; 544START TRANSACTION 545/*!*/; 546# at # 547# at # 548#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 549# at # 550#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 551### INSERT INTO `test1`.`t1` 552### SET 553### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 554### INSERT INTO `test1`.`t1` 555### SET 556### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 557### INSERT INTO `test1`.`t1` 558### SET 559### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 560# Number of rows: 3 561# at # 562#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 563SET TIMESTAMP=1000000000/*!*/; 564COMMIT 565/*!*/; 566# at # 567#010909 4:46:40 server id # end_log_pos # GTID 0-1-5 568/*!100001 SET @@session.gtid_seq_no=5*//*!*/; 569START TRANSACTION 570/*!*/; 571# at # 572# at # 573#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 574# at # 575#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 576### INSERT INTO `test2`.`t2` 577### SET 578### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 579### INSERT INTO `test2`.`t2` 580### SET 581### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 582### INSERT INTO `test2`.`t2` 583### SET 584### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 585# Number of rows: 3 586# at # 587#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 588SET TIMESTAMP=1000000000/*!*/; 589COMMIT 590/*!*/; 591# at # 592#010909 4:46:40 server id # end_log_pos # GTID 0-1-6 593/*!100001 SET @@session.gtid_seq_no=6*//*!*/; 594START TRANSACTION 595/*!*/; 596# at # 597# at # 598#010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number # 599# at # 600#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 601### INSERT INTO `test3`.`t3` 602### SET 603### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 604### INSERT INTO `test3`.`t3` 605### SET 606### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 607### INSERT INTO `test3`.`t3` 608### SET 609### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 610# Number of rows: 3 611# at # 612#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 613SET TIMESTAMP=1000000000/*!*/; 614COMMIT 615/*!*/; 616# at # 617#010909 4:46:40 server id # end_log_pos # GTID 0-1-7 618/*!100001 SET @@session.gtid_seq_no=7*//*!*/; 619START TRANSACTION 620/*!*/; 621# at # 622# at # 623#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 624# at # 625#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 626# at # 627# at # 628#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # 629#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 630### DELETE FROM `test1`.`t1` 631### WHERE 632### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 633### DELETE FROM `test1`.`t1` 634### WHERE 635### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 636### DELETE FROM `test1`.`t1` 637### WHERE 638### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 639### DELETE FROM `test2`.`t2` 640### WHERE 641### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 642### DELETE FROM `test2`.`t2` 643### WHERE 644### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 645### DELETE FROM `test2`.`t2` 646### WHERE 647### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 648# Number of rows: 6 649# at # 650#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 651SET TIMESTAMP=1000000000/*!*/; 652COMMIT 653/*!*/; 654# at # 655#010909 4:46:40 server id # end_log_pos # GTID 0-1-8 656/*!100001 SET @@session.gtid_seq_no=8*//*!*/; 657START TRANSACTION 658/*!*/; 659# at # 660# at # 661#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 662# at # 663#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 664### INSERT INTO `test2`.`t2` 665### SET 666### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 667### INSERT INTO `test2`.`t2` 668### SET 669### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 670### INSERT INTO `test2`.`t2` 671### SET 672### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 673# Number of rows: 3 674# at # 675#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 676SET TIMESTAMP=1000000000/*!*/; 677COMMIT 678/*!*/; 679# at # 680#010909 4:46:40 server id # end_log_pos # GTID 0-1-9 681/*!100001 SET @@session.gtid_seq_no=9*//*!*/; 682START TRANSACTION 683/*!*/; 684# at # 685# at # 686#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 687# at # 688#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 689### DELETE FROM `test2`.`t2` 690### WHERE 691### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 692### DELETE FROM `test2`.`t2` 693### WHERE 694### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 695### DELETE FROM `test2`.`t2` 696### WHERE 697### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 698# Number of rows: 3 699# at # 700#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 701SET TIMESTAMP=1000000000/*!*/; 702COMMIT 703/*!*/; 704# at # 705#010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4 706DELIMITER ; 707# End of log file 708ROLLBACK /* added by mysqlbinlog */; 709/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 710/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 711# 712##################################################################################### 713# mysqlbinlog --read-from-remote-server 714# The following Annotates should appear in this output: 715# - INSERT INTO test2.t2 VALUES (1), (2), (3) 716# - INSERT INTO test3.t3 VALUES (1), (2), (3) 717# - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps) 718# - INSERT INTO test2.t2 VALUES (1), (2), (3) 719# - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map) 720##################################################################################### 721/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 722/*!40019 SET @@session.max_insert_delayed_threads=0*/; 723/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 724DELIMITER /*!*/; 725# at # 726#010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup 727ROLLBACK/*!*/; 728# at # 729#010909 4:46:40 server id # end_log_pos # Gtid list [] 730# at # 731#010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001 732# at # 733#010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl 734/*!100101 SET @@session.skip_parallel_replication=0*//*!*/; 735/*!100001 SET @@session.gtid_domain_id=0*//*!*/; 736/*!100001 SET @@session.server_id=1*//*!*/; 737/*!100001 SET @@session.gtid_seq_no=1*//*!*/; 738# at # 739#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 740SET TIMESTAMP=1000000000/*!*/; 741SET @@session.pseudo_thread_id=#/*!*/; 742SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/; 743SET @@session.sql_mode=0/*!*/; 744SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 745/*!\C latin1 *//*!*/; 746SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; 747SET @@session.lc_time_names=0/*!*/; 748SET @@session.collation_database=DEFAULT/*!*/; 749CREATE DATABASE test1 750/*!*/; 751# at # 752#010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl 753/*!100001 SET @@session.gtid_seq_no=2*//*!*/; 754# at # 755#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 756SET TIMESTAMP=1000000000/*!*/; 757CREATE DATABASE test2 758/*!*/; 759# at # 760#010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl 761/*!100001 SET @@session.gtid_seq_no=3*//*!*/; 762# at # 763#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 764SET TIMESTAMP=1000000000/*!*/; 765CREATE DATABASE test3 766/*!*/; 767# at # 768#010909 4:46:40 server id # end_log_pos # GTID 0-1-4 769/*!100001 SET @@session.gtid_seq_no=4*//*!*/; 770START TRANSACTION 771/*!*/; 772# at # 773# at # 774#010909 4:46:40 server id # end_log_pos # Annotate_rows: 775#Q> INSERT INTO test1.t1 VALUES (1), (2), (3) 776#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 777# at # 778#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 779### INSERT INTO `test1`.`t1` 780### SET 781### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 782### INSERT INTO `test1`.`t1` 783### SET 784### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 785### INSERT INTO `test1`.`t1` 786### SET 787### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 788# Number of rows: 3 789# at # 790#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 791SET TIMESTAMP=1000000000/*!*/; 792COMMIT 793/*!*/; 794# at # 795#010909 4:46:40 server id # end_log_pos # GTID 0-1-5 796/*!100001 SET @@session.gtid_seq_no=5*//*!*/; 797START TRANSACTION 798/*!*/; 799# at # 800# at # 801#010909 4:46:40 server id # end_log_pos # Annotate_rows: 802#Q> INSERT INTO test2.t2 VALUES (1), (2), (3) 803#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 804# at # 805#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 806### INSERT INTO `test2`.`t2` 807### SET 808### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 809### INSERT INTO `test2`.`t2` 810### SET 811### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 812### INSERT INTO `test2`.`t2` 813### SET 814### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 815# Number of rows: 3 816# at # 817#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 818SET TIMESTAMP=1000000000/*!*/; 819COMMIT 820/*!*/; 821# at # 822#010909 4:46:40 server id # end_log_pos # GTID 0-1-6 823/*!100001 SET @@session.gtid_seq_no=6*//*!*/; 824START TRANSACTION 825/*!*/; 826# at # 827# at # 828#010909 4:46:40 server id # end_log_pos # Annotate_rows: 829#Q> INSERT INTO test3.t3 VALUES (1), (2), (3) 830#010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number # 831# at # 832#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 833### INSERT INTO `test3`.`t3` 834### SET 835### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 836### INSERT INTO `test3`.`t3` 837### SET 838### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 839### INSERT INTO `test3`.`t3` 840### SET 841### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 842# Number of rows: 3 843# at # 844#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 845SET TIMESTAMP=1000000000/*!*/; 846COMMIT 847/*!*/; 848# at # 849#010909 4:46:40 server id # end_log_pos # GTID 0-1-7 850/*!100001 SET @@session.gtid_seq_no=7*//*!*/; 851START TRANSACTION 852/*!*/; 853# at # 854# at # 855#010909 4:46:40 server id # end_log_pos # Annotate_rows: 856#Q> DELETE test1.t1, test2.t2 857#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3 858#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3 859#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 860# at # 861#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 862# at # 863# at # 864#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # 865#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 866### DELETE FROM `test1`.`t1` 867### WHERE 868### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 869### DELETE FROM `test1`.`t1` 870### WHERE 871### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 872### DELETE FROM `test1`.`t1` 873### WHERE 874### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 875### DELETE FROM `test2`.`t2` 876### WHERE 877### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 878### DELETE FROM `test2`.`t2` 879### WHERE 880### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 881### DELETE FROM `test2`.`t2` 882### WHERE 883### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 884# Number of rows: 6 885# at # 886#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 887SET TIMESTAMP=1000000000/*!*/; 888COMMIT 889/*!*/; 890# at # 891#010909 4:46:40 server id # end_log_pos # GTID 0-1-8 892/*!100001 SET @@session.gtid_seq_no=8*//*!*/; 893START TRANSACTION 894/*!*/; 895# at # 896# at # 897#010909 4:46:40 server id # end_log_pos # Annotate_rows: 898#Q> INSERT INTO test2.v2 VALUES (1), (2), (3) 899#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 900# at # 901#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 902### INSERT INTO `test2`.`t2` 903### SET 904### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 905### INSERT INTO `test2`.`t2` 906### SET 907### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 908### INSERT INTO `test2`.`t2` 909### SET 910### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 911# Number of rows: 3 912# at # 913#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 914SET TIMESTAMP=1000000000/*!*/; 915COMMIT 916/*!*/; 917# at # 918#010909 4:46:40 server id # end_log_pos # GTID 0-1-9 919/*!100001 SET @@session.gtid_seq_no=9*//*!*/; 920START TRANSACTION 921/*!*/; 922# at # 923# at # 924#010909 4:46:40 server id # end_log_pos # Annotate_rows: 925#Q> DELETE xtest1.xt1, test2.t2 926#Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3 927#Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3 928#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 929# at # 930#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 931### DELETE FROM `test2`.`t2` 932### WHERE 933### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 934### DELETE FROM `test2`.`t2` 935### WHERE 936### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 937### DELETE FROM `test2`.`t2` 938### WHERE 939### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 940# Number of rows: 3 941# at # 942#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 943SET TIMESTAMP=1000000000/*!*/; 944COMMIT 945/*!*/; 946# at # 947#010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4 948DELIMITER ; 949# End of log file 950ROLLBACK /* added by mysqlbinlog */; 951/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 952/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 953# 954##################################################################################### 955# mysqlbinlog --read-from-remote-server --database=test1 956# The following Annotate should appear in this output: 957# - DELETE test1.t1, test2.t2 FROM <...> 958##################################################################################### 959/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 960/*!40019 SET @@session.max_insert_delayed_threads=0*/; 961/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 962DELIMITER /*!*/; 963# at # 964#010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup 965ROLLBACK/*!*/; 966# at # 967#010909 4:46:40 server id # end_log_pos # Gtid list [] 968# at # 969#010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001 970# at # 971#010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl 972/*!100101 SET @@session.skip_parallel_replication=0*//*!*/; 973/*!100001 SET @@session.gtid_domain_id=0*//*!*/; 974/*!100001 SET @@session.server_id=1*//*!*/; 975/*!100001 SET @@session.gtid_seq_no=1*//*!*/; 976# at # 977#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 978SET TIMESTAMP=1000000000/*!*/; 979SET @@session.pseudo_thread_id=#/*!*/; 980SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/; 981SET @@session.sql_mode=0/*!*/; 982SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 983/*!\C latin1 *//*!*/; 984SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; 985SET @@session.lc_time_names=0/*!*/; 986SET @@session.collation_database=DEFAULT/*!*/; 987CREATE DATABASE test1 988/*!*/; 989# at # 990#010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl 991/*!100001 SET @@session.gtid_seq_no=2*//*!*/; 992# at # 993# at # 994#010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl 995/*!100001 SET @@session.gtid_seq_no=3*//*!*/; 996# at # 997# at # 998#010909 4:46:40 server id # end_log_pos # GTID 0-1-4 999/*!100001 SET @@session.gtid_seq_no=4*//*!*/; 1000START TRANSACTION 1001/*!*/; 1002# at # 1003# at # 1004#010909 4:46:40 server id # end_log_pos # Annotate_rows: 1005#Q> INSERT INTO test1.t1 VALUES (1), (2), (3) 1006#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 1007# at # 1008#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 1009### INSERT INTO `test1`.`t1` 1010### SET 1011### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1012### INSERT INTO `test1`.`t1` 1013### SET 1014### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1015### INSERT INTO `test1`.`t1` 1016### SET 1017### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1018# Number of rows: 3 1019# at # 1020#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1021SET TIMESTAMP=1000000000/*!*/; 1022COMMIT 1023/*!*/; 1024# at # 1025#010909 4:46:40 server id # end_log_pos # GTID 0-1-5 1026/*!100001 SET @@session.gtid_seq_no=5*//*!*/; 1027START TRANSACTION 1028/*!*/; 1029# at # 1030# at # 1031# at # 1032# at # 1033#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1034SET TIMESTAMP=1000000000/*!*/; 1035COMMIT 1036/*!*/; 1037# at # 1038#010909 4:46:40 server id # end_log_pos # GTID 0-1-6 1039/*!100001 SET @@session.gtid_seq_no=6*//*!*/; 1040START TRANSACTION 1041/*!*/; 1042# at # 1043# at # 1044# at # 1045# at # 1046#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1047SET TIMESTAMP=1000000000/*!*/; 1048COMMIT 1049/*!*/; 1050# at # 1051#010909 4:46:40 server id # end_log_pos # GTID 0-1-7 1052/*!100001 SET @@session.gtid_seq_no=7*//*!*/; 1053START TRANSACTION 1054/*!*/; 1055# at # 1056# at # 1057#010909 4:46:40 server id # end_log_pos # Annotate_rows: 1058#Q> DELETE test1.t1, test2.t2 1059#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3 1060#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3 1061#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 1062# at # 1063# at # 1064# at # 1065#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # 1066### DELETE FROM `test1`.`t1` 1067### WHERE 1068### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1069### DELETE FROM `test1`.`t1` 1070### WHERE 1071### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1072### DELETE FROM `test1`.`t1` 1073### WHERE 1074### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1075# at # 1076#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1077SET TIMESTAMP=1000000000/*!*/; 1078COMMIT 1079/*!*/; 1080# at # 1081#010909 4:46:40 server id # end_log_pos # GTID 0-1-8 1082/*!100001 SET @@session.gtid_seq_no=8*//*!*/; 1083START TRANSACTION 1084/*!*/; 1085# at # 1086# at # 1087# at # 1088# at # 1089#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1090SET TIMESTAMP=1000000000/*!*/; 1091COMMIT 1092/*!*/; 1093# at # 1094#010909 4:46:40 server id # end_log_pos # GTID 0-1-9 1095/*!100001 SET @@session.gtid_seq_no=9*//*!*/; 1096START TRANSACTION 1097/*!*/; 1098# at # 1099# at # 1100# at # 1101# at # 1102#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1103SET TIMESTAMP=1000000000/*!*/; 1104COMMIT 1105/*!*/; 1106# at # 1107#010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4 1108DELIMITER ; 1109# End of log file 1110ROLLBACK /* added by mysqlbinlog */; 1111/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 1112/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 1113# 1114##################################################################################### 1115# mysqlbinlog --read-from-remote-server --skip-annotate-row-events 1116# No Annotates should appear in this output 1117##################################################################################### 1118/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 1119/*!40019 SET @@session.max_insert_delayed_threads=0*/; 1120/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 1121DELIMITER /*!*/; 1122# at # 1123#010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup 1124ROLLBACK/*!*/; 1125# at # 1126#010909 4:46:40 server id # end_log_pos # Gtid list [] 1127# at # 1128#010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001 1129# at # 1130#010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl 1131/*!100101 SET @@session.skip_parallel_replication=0*//*!*/; 1132/*!100001 SET @@session.gtid_domain_id=0*//*!*/; 1133/*!100001 SET @@session.server_id=1*//*!*/; 1134/*!100001 SET @@session.gtid_seq_no=1*//*!*/; 1135# at # 1136#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1137SET TIMESTAMP=1000000000/*!*/; 1138SET @@session.pseudo_thread_id=#/*!*/; 1139SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1/*!*/; 1140SET @@session.sql_mode=0/*!*/; 1141SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 1142/*!\C latin1 *//*!*/; 1143SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; 1144SET @@session.lc_time_names=0/*!*/; 1145SET @@session.collation_database=DEFAULT/*!*/; 1146CREATE DATABASE test1 1147/*!*/; 1148# at # 1149#010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl 1150/*!100001 SET @@session.gtid_seq_no=2*//*!*/; 1151# at # 1152#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1153SET TIMESTAMP=1000000000/*!*/; 1154CREATE DATABASE test2 1155/*!*/; 1156# at # 1157#010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl 1158/*!100001 SET @@session.gtid_seq_no=3*//*!*/; 1159# at # 1160#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1161SET TIMESTAMP=1000000000/*!*/; 1162CREATE DATABASE test3 1163/*!*/; 1164# at # 1165#010909 4:46:40 server id # end_log_pos # GTID 0-1-4 1166/*!100001 SET @@session.gtid_seq_no=4*//*!*/; 1167START TRANSACTION 1168/*!*/; 1169# at # 1170#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 1171# at # 1172#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 1173### INSERT INTO `test1`.`t1` 1174### SET 1175### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1176### INSERT INTO `test1`.`t1` 1177### SET 1178### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1179### INSERT INTO `test1`.`t1` 1180### SET 1181### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1182# Number of rows: 3 1183# at # 1184#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1185SET TIMESTAMP=1000000000/*!*/; 1186COMMIT 1187/*!*/; 1188# at # 1189#010909 4:46:40 server id # end_log_pos # GTID 0-1-5 1190/*!100001 SET @@session.gtid_seq_no=5*//*!*/; 1191START TRANSACTION 1192/*!*/; 1193# at # 1194#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 1195# at # 1196#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 1197### INSERT INTO `test2`.`t2` 1198### SET 1199### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1200### INSERT INTO `test2`.`t2` 1201### SET 1202### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1203### INSERT INTO `test2`.`t2` 1204### SET 1205### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1206# Number of rows: 3 1207# at # 1208#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1209SET TIMESTAMP=1000000000/*!*/; 1210COMMIT 1211/*!*/; 1212# at # 1213#010909 4:46:40 server id # end_log_pos # GTID 0-1-6 1214/*!100001 SET @@session.gtid_seq_no=6*//*!*/; 1215START TRANSACTION 1216/*!*/; 1217# at # 1218#010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number # 1219# at # 1220#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 1221### INSERT INTO `test3`.`t3` 1222### SET 1223### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1224### INSERT INTO `test3`.`t3` 1225### SET 1226### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1227### INSERT INTO `test3`.`t3` 1228### SET 1229### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1230# Number of rows: 3 1231# at # 1232#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1233SET TIMESTAMP=1000000000/*!*/; 1234COMMIT 1235/*!*/; 1236# at # 1237#010909 4:46:40 server id # end_log_pos # GTID 0-1-7 1238/*!100001 SET @@session.gtid_seq_no=7*//*!*/; 1239START TRANSACTION 1240/*!*/; 1241# at # 1242#010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number # 1243# at # 1244#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 1245# at # 1246# at # 1247#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # 1248#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 1249### DELETE FROM `test1`.`t1` 1250### WHERE 1251### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1252### DELETE FROM `test1`.`t1` 1253### WHERE 1254### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1255### DELETE FROM `test1`.`t1` 1256### WHERE 1257### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1258### DELETE FROM `test2`.`t2` 1259### WHERE 1260### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1261### DELETE FROM `test2`.`t2` 1262### WHERE 1263### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1264### DELETE FROM `test2`.`t2` 1265### WHERE 1266### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1267# Number of rows: 6 1268# at # 1269#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1270SET TIMESTAMP=1000000000/*!*/; 1271COMMIT 1272/*!*/; 1273# at # 1274#010909 4:46:40 server id # end_log_pos # GTID 0-1-8 1275/*!100001 SET @@session.gtid_seq_no=8*//*!*/; 1276START TRANSACTION 1277/*!*/; 1278# at # 1279#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 1280# at # 1281#010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F 1282### INSERT INTO `test2`.`t2` 1283### SET 1284### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1285### INSERT INTO `test2`.`t2` 1286### SET 1287### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1288### INSERT INTO `test2`.`t2` 1289### SET 1290### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1291# Number of rows: 3 1292# at # 1293#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1294SET TIMESTAMP=1000000000/*!*/; 1295COMMIT 1296/*!*/; 1297# at # 1298#010909 4:46:40 server id # end_log_pos # GTID 0-1-9 1299/*!100001 SET @@session.gtid_seq_no=9*//*!*/; 1300START TRANSACTION 1301/*!*/; 1302# at # 1303#010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number # 1304# at # 1305#010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F 1306### DELETE FROM `test2`.`t2` 1307### WHERE 1308### @1=3 /* INT meta=0 nullable=1 is_null=0 */ 1309### DELETE FROM `test2`.`t2` 1310### WHERE 1311### @1=2 /* INT meta=0 nullable=1 is_null=0 */ 1312### DELETE FROM `test2`.`t2` 1313### WHERE 1314### @1=1 /* INT meta=0 nullable=1 is_null=0 */ 1315# Number of rows: 3 1316# at # 1317#010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 1318SET TIMESTAMP=1000000000/*!*/; 1319COMMIT 1320/*!*/; 1321# at # 1322#010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4 1323DELIMITER ; 1324# End of log file 1325ROLLBACK /* added by mysqlbinlog */; 1326/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 1327/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 1328set global binlog_checksum=@old_binlog_checksum; 1329DROP DATABASE test1; 1330DROP DATABASE test2; 1331DROP DATABASE test3; 1332DROP DATABASE xtest1; 1333DROP DATABASE xtest2; 1334