#####################################################################################
# The following Annotate_rows events should appear below:
# - INSERT INTO test2.t2 VALUES (1), (2), (3)
# - INSERT INTO test3.t3 VALUES (1), (2), (3)
# - DELETE test1.t1, test2.t2 FROM <...>
# - INSERT INTO test2.t2 VALUES (1), (2), (3)
# - DELETE xtest1.xt1, test2.t2 FROM <...>
#####################################################################################
show binlog events in 'master-bin.000001' from <start_pos>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Gtid_list	1	#	[]
master-bin.000001	#	Binlog_checkpoint	1	#	master-bin.000001
master-bin.000001	#	Gtid	1	#	GTID 0-1-1
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS test1
master-bin.000001	#	Gtid	1	#	GTID 0-1-2
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS test2
master-bin.000001	#	Gtid	1	#	GTID 0-1-3
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS test3
master-bin.000001	#	Gtid	1	#	GTID 0-1-4
master-bin.000001	#	Query	1	#	CREATE DATABASE test1
master-bin.000001	#	Gtid	1	#	GTID 0-1-5
master-bin.000001	#	Query	1	#	CREATE DATABASE test2
master-bin.000001	#	Gtid	1	#	GTID 0-1-6
master-bin.000001	#	Query	1	#	CREATE DATABASE test3
master-bin.000001	#	Gtid	1	#	BEGIN GTID 0-1-7
master-bin.000001	#	Table_map	1	#	table_id: # (test1.t1)
master-bin.000001	#	Write_rows_v1	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	1	#	COMMIT
master-bin.000001	#	Gtid	1	#	BEGIN GTID 0-1-8
master-bin.000001	#	Annotate_rows	1	#	INSERT INTO test2.t2 VALUES (1), (2), (3)
master-bin.000001	#	Table_map	1	#	table_id: # (test2.t2)
master-bin.000001	#	Write_rows_v1	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	1	#	COMMIT
master-bin.000001	#	Gtid	1	#	BEGIN GTID 0-1-9
master-bin.000001	#	Annotate_rows	1	#	INSERT INTO test3.t3 VALUES (1), (2), (3)
master-bin.000001	#	Table_map	1	#	table_id: # (test3.t3)
master-bin.000001	#	Write_rows_v1	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	1	#	COMMIT
master-bin.000001	#	Gtid	1	#	BEGIN GTID 0-1-10
master-bin.000001	#	Annotate_rows	1	#	DELETE test1.t1, test2.t2
FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
master-bin.000001	#	Table_map	1	#	table_id: # (test1.t1)
master-bin.000001	#	Table_map	1	#	table_id: # (test2.t2)
master-bin.000001	#	Delete_rows_v1	1	#	table_id: #
master-bin.000001	#	Delete_rows_v1	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	1	#	COMMIT
master-bin.000001	#	Gtid	1	#	BEGIN GTID 0-1-11
master-bin.000001	#	Annotate_rows	1	#	INSERT INTO test2.v2 VALUES (1), (2), (3)
master-bin.000001	#	Table_map	1	#	table_id: # (test2.t2)
master-bin.000001	#	Write_rows_v1	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	1	#	COMMIT
master-bin.000001	#	Gtid	1	#	BEGIN GTID 0-1-12
master-bin.000001	#	Annotate_rows	1	#	DELETE xtest1.xt1, test2.t2
FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a
master-bin.000001	#	Table_map	1	#	table_id: # (test2.t2)
master-bin.000001	#	Delete_rows_v1	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	1	#	COMMIT
master-bin.000001	#	Rotate	1	#	master-bin.000002;pos=4
#
#####################################################################################
# mysqlbinlog
# The following Annotates should appear in this output:
# - INSERT INTO test2.t2 VALUES (1), (2), (3)
# - INSERT INTO test3.t3 VALUES (1), (2), (3)
# - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps)
# - INSERT INTO test2.t2 VALUES (1), (2), (3)
# - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map)
#####################################################################################
/*!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 #
#010909  4:46:40 server id #  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Gtid list []
# at #
#010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=1*//*!*/;
/*!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP DATABASE IF EXISTS test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-4
/*!100001 SET @@session.gtid_seq_no=4*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-5
/*!100001 SET @@session.gtid_seq_no=5*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-6
/*!100001 SET @@session.gtid_seq_no=6*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-7
/*!100001 SET @@session.gtid_seq_no=7*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test1`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-8
/*!100001 SET @@session.gtid_seq_no=8*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> INSERT INTO test2.t2 VALUES (1), (2), (3)
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-9
/*!100001 SET @@session.gtid_seq_no=9*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> INSERT INTO test3.t3 VALUES (1), (2), (3)
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test3`.`t3`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-10
/*!100001 SET @@session.gtid_seq_no=10*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> DELETE test1.t1, test2.t2
#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-11
/*!100001 SET @@session.gtid_seq_no=11*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> INSERT INTO test2.v2 VALUES (1), (2), (3)
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-12
/*!100001 SET @@session.gtid_seq_no=12*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> DELETE xtest1.xt1, test2.t2
#Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
#Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
#
#####################################################################################
# mysqlbinlog --database=test1
# The following Annotate should appear in this output:
# - DELETE test1.t1, test2.t2 FROM <...>
#####################################################################################
/*!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 #
#010909  4:46:40 server id #  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Gtid list []
# at #
#010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=1*//*!*/;
/*!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP DATABASE IF EXISTS test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-4
/*!100001 SET @@session.gtid_seq_no=4*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-5
/*!100001 SET @@session.gtid_seq_no=5*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-6
/*!100001 SET @@session.gtid_seq_no=6*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-7
/*!100001 SET @@session.gtid_seq_no=7*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test1`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-8
/*!100001 SET @@session.gtid_seq_no=8*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-9
/*!100001 SET @@session.gtid_seq_no=9*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-10
/*!100001 SET @@session.gtid_seq_no=10*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> DELETE test1.t1, test2.t2
#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
'/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-11
/*!100001 SET @@session.gtid_seq_no=11*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-12
/*!100001 SET @@session.gtid_seq_no=12*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
#
#####################################################################################
# mysqlbinlog --skip-annotate-row-events
# No Annotates should appear in this output
#####################################################################################
/*!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 #
#010909  4:46:40 server id #  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Gtid list []
# at #
#010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=1*//*!*/;
/*!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP DATABASE IF EXISTS test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-4
/*!100001 SET @@session.gtid_seq_no=4*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-5
/*!100001 SET @@session.gtid_seq_no=5*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-6
/*!100001 SET @@session.gtid_seq_no=6*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-7
/*!100001 SET @@session.gtid_seq_no=7*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test1`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-8
/*!100001 SET @@session.gtid_seq_no=8*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-9
/*!100001 SET @@session.gtid_seq_no=9*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test3`.`t3`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-10
/*!100001 SET @@session.gtid_seq_no=10*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-11
/*!100001 SET @@session.gtid_seq_no=11*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-12
/*!100001 SET @@session.gtid_seq_no=12*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
#
#####################################################################################
# mysqlbinlog --read-from-remote-server
# The following Annotates should appear in this output:
# - INSERT INTO test2.t2 VALUES (1), (2), (3)
# - INSERT INTO test3.t3 VALUES (1), (2), (3)
# - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps)
# - INSERT INTO test2.t2 VALUES (1), (2), (3)
# - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map)
#####################################################################################
/*!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 #
#010909  4:46:40 server id #  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Gtid list []
# at #
#010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=1*//*!*/;
/*!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP DATABASE IF EXISTS test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-4
/*!100001 SET @@session.gtid_seq_no=4*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-5
/*!100001 SET @@session.gtid_seq_no=5*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-6
/*!100001 SET @@session.gtid_seq_no=6*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-7
/*!100001 SET @@session.gtid_seq_no=7*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test1`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-8
/*!100001 SET @@session.gtid_seq_no=8*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> INSERT INTO test2.t2 VALUES (1), (2), (3)
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-9
/*!100001 SET @@session.gtid_seq_no=9*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> INSERT INTO test3.t3 VALUES (1), (2), (3)
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test3`.`t3`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-10
/*!100001 SET @@session.gtid_seq_no=10*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> DELETE test1.t1, test2.t2
#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-11
/*!100001 SET @@session.gtid_seq_no=11*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> INSERT INTO test2.v2 VALUES (1), (2), (3)
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-12
/*!100001 SET @@session.gtid_seq_no=12*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> DELETE xtest1.xt1, test2.t2
#Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
#Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
#
#####################################################################################
# mysqlbinlog --read-from-remote-server --database=test1
# The following Annotate should appear in this output:
# - DELETE test1.t1, test2.t2 FROM <...>
#####################################################################################
/*!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 #
#010909  4:46:40 server id #  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Gtid list []
# at #
#010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=1*//*!*/;
/*!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP DATABASE IF EXISTS test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-4
/*!100001 SET @@session.gtid_seq_no=4*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-5
/*!100001 SET @@session.gtid_seq_no=5*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-6
/*!100001 SET @@session.gtid_seq_no=6*//*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-7
/*!100001 SET @@session.gtid_seq_no=7*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test1`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-8
/*!100001 SET @@session.gtid_seq_no=8*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-9
/*!100001 SET @@session.gtid_seq_no=9*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-10
/*!100001 SET @@session.gtid_seq_no=10*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Annotate_rows:
#Q> DELETE test1.t1, test2.t2
#Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
#Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
'/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-11
/*!100001 SET @@session.gtid_seq_no=11*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-12
/*!100001 SET @@session.gtid_seq_no=12*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
#
#####################################################################################
# mysqlbinlog --read-from-remote-server --skip-annotate-row-events
# No Annotates should appear in this output
#####################################################################################
/*!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 #
#010909  4:46:40 server id #  end_log_pos # 	Start: binlog v 4, server v #.##.## created 010909  4:46:40 at startup
ROLLBACK/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Gtid list []
# at #
#010909  4:46:40 server id #  end_log_pos # 	Binlog checkpoint master-bin.000001
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-1
/*!100001 SET @@session.gtid_domain_id=0*//*!*/;
/*!100001 SET @@session.server_id=1*//*!*/;
/*!100001 SET @@session.gtid_seq_no=1*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
SET @@session.pseudo_thread_id=#/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP DATABASE IF EXISTS test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-2
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-3
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
DROP DATABASE IF EXISTS test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-4
/*!100001 SET @@session.gtid_seq_no=4*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test1
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-5
/*!100001 SET @@session.gtid_seq_no=5*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test2
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-6
/*!100001 SET @@session.gtid_seq_no=6*//*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
CREATE DATABASE test3
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-7
/*!100001 SET @@session.gtid_seq_no=7*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test1`.`t1`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test1`.`t1`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-8
/*!100001 SET @@session.gtid_seq_no=8*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-9
/*!100001 SET @@session.gtid_seq_no=9*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test3`.`t3` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test3`.`t3`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test3`.`t3`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-10
/*!100001 SET @@session.gtid_seq_no=10*//*!*/;
BEGIN
/*!*/;
# at #
# at #
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test1`.`t1` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test1`.`t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-11
/*!100001 SET @@session.gtid_seq_no=11*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Write_rows: table id # flags: STMT_END_F
### INSERT INTO `test2`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### INSERT INTO `test2`.`t2`
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	GTID 0-1-12
/*!100001 SET @@session.gtid_seq_no=12*//*!*/;
BEGIN
/*!*/;
# at #
# at #
#010909  4:46:40 server id #  end_log_pos # 	Table_map: `test2`.`t2` mapped to number #
#010909  4:46:40 server id #  end_log_pos # 	Delete_rows: table id # flags: STMT_END_F
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
### DELETE FROM `test2`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
# at #
#010909  4:46:40 server id #  end_log_pos # 	Query	thread_id=#	exec_time=#	error_code=0
SET TIMESTAMP=1000000000/*!*/;
COMMIT
/*!*/;
# at #
#010909  4:46:40 server id #  end_log_pos # 	Rotate to master-bin.000002  pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
