path: root/mysql-test/suite/binlog/r/binlog_row_binlog.result

drop table if exists t1, t2;
reset master;
create table t1 (a int) engine=innodb;
create table t2 (a int) engine=innodb;
begin;
insert t1 values (5);
commit;
begin;
insert t2 values (5);
commit;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int) engine=innodb
master-bin.000001	#	Query	#	#	use `test`; create table t2 (a int) engine=innodb
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t2)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
drop table t1,t2;
reset master;
create table t1 (n int) engine=innodb;
begin;
commit;
drop table t1;
show binlog events in 'master-bin.000001' from 107;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; create table t1 (n int) engine=innodb
master-bin.000001	#	Query	1	#	BEGIN
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Xid	1	#	COMMIT /* xid= */
master-bin.000001	#	Rotate	1	#	master-bin.000002;pos=4
show binlog events in 'master-bin.000002' from 107;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000002	#	Query	1	#	use `test`; drop table t1
set @ac = @@autocommit;
set autocommit= 0;
reset master;
create table t1(n int) engine=innodb;
begin;
insert into t1 values (1);
insert into t1 values (2);
insert into t1 values (3);
commit;
drop table t1;
show binlog events from 0;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
master-bin.000001	107	Query	1	206	use `test`; create table t1(n int) engine=innodb
master-bin.000001	206	Query	1	274	BEGIN
master-bin.000001	274	Table_map	1	315	table_id: # (test.t1)
master-bin.000001	315	Write_rows	1	349	table_id: # flags: STMT_END_F
master-bin.000001	349	Table_map	1	390	table_id: # (test.t1)
master-bin.000001	390	Write_rows	1	424	table_id: # flags: STMT_END_F
master-bin.000001	424	Table_map	1	465	table_id: # (test.t1)
master-bin.000001	465	Write_rows	1	499	table_id: # flags: STMT_END_F
master-bin.000001	499	Xid	1	526	COMMIT /* XID */
master-bin.000001	526	Query	1	602	use `test`; drop table t1
set @bcs = @@binlog_cache_size;
set global binlog_cache_size=4096;
reset master;
create table t1 (a int) engine=innodb;
show binlog events from 0;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
master-bin.000001	107	Query	1	207	use `test`; create table t1 (a int) engine=innodb
master-bin.000001	207	Query	1	275	BEGIN
master-bin.000001	275	Table_map	1	316	table_id: # (test.t1)
master-bin.000001	316	Write_rows	1	350	table_id: # flags: STMT_END_F
master-bin.000001	350	Table_map	1	391	table_id: # (test.t1)
master-bin.000001	391	Write_rows	1	425	table_id: # flags: STMT_END_F
master-bin.000001	425	Table_map	1	466	table_id: # (test.t1)
master-bin.000001	466	Write_rows	1	500	table_id: # flags: STMT_END_F
master-bin.000001	500	Table_map	1	541	table_id: # (test.t1)
master-bin.000001	541	Write_rows	1	575	table_id: # flags: STMT_END_F
master-bin.000001	575	Table_map	1	616	table_id: # (test.t1)
master-bin.000001	616	Write_rows	1	650	table_id: # flags: STMT_END_F
master-bin.000001	650	Table_map	1	691	table_id: # (test.t1)
master-bin.000001	691	Write_rows	1	725	table_id: # flags: STMT_END_F
master-bin.000001	725	Table_map	1	766	table_id: # (test.t1)
master-bin.000001	766	Write_rows	1	800	table_id: # flags: STMT_END_F
master-bin.000001	800	Table_map	1	841	table_id: # (test.t1)
master-bin.000001	841	Write_rows	1	875	table_id: # flags: STMT_END_F
master-bin.000001	875	Table_map	1	916	table_id: # (test.t1)
master-bin.000001	916	Write_rows	1	950	table_id: # flags: STMT_END_F
master-bin.000001	950	Table_map	1	991	table_id: # (test.t1)
master-bin.000001	991	Write_rows	1	1025	table_id: # flags: STMT_END_F
master-bin.000001	1025	Table_map	1	1066	table_id: # (test.t1)
master-bin.000001	1066	Write_rows	1	1100	table_id: # flags: STMT_END_F
master-bin.000001	1100	Table_map	1	1141	table_id: # (test.t1)
master-bin.000001	1141	Write_rows	1	1175	table_id: # flags: STMT_END_F
master-bin.000001	1175	Table_map	1	1216	table_id: # (test.t1)
master-bin.000001	1216	Write_rows	1	1250	table_id: # flags: STMT_END_F
master-bin.000001	1250	Table_map	1	1291	table_id: # (test.t1)
master-bin.000001	1291	Write_rows	1	1325	table_id: # flags: STMT_END_F
master-bin.000001	1325	Table_map	1	1366	table_id: # (test.t1)
master-bin.000001	1366	Write_rows	1	1400	table_id: # flags: STMT_END_F
master-bin.000001	1400	Table_map	1	1441	table_id: # (test.t1)
master-bin.000001	1441	Write_rows	1	1475	table_id: # flags: STMT_END_F
master-bin.000001	1475	Table_map	1	1516	table_id: # (test.t1)
master-bin.000001	1516	Write_rows	1	1550	table_id: # flags: STMT_END_F
master-bin.000001	1550	Table_map	1	1591	table_id: # (test.t1)
master-bin.000001	1591	Write_rows	1	1625	table_id: # flags: STMT_END_F
master-bin.000001	1625	Table_map	1	1666	table_id: # (test.t1)
master-bin.000001	1666	Write_rows	1	1700	table_id: # flags: STMT_END_F
master-bin.000001	1700	Table_map	1	1741	table_id: # (test.t1)
master-bin.000001	1741	Write_rows	1	1775	table_id: # flags: STMT_END_F
master-bin.000001	1775	Table_map	1	1816	table_id: # (test.t1)
master-bin.000001	1816	Write_rows	1	1850	table_id: # flags: STMT_END_F
master-bin.000001	1850	Table_map	1	1891	table_id: # (test.t1)
master-bin.000001	1891	Write_rows	1	1925	table_id: # flags: STMT_END_F
master-bin.000001	1925	Table_map	1	1966	table_id: # (test.t1)
master-bin.000001	1966	Write_rows	1	2000	table_id: # flags: STMT_END_F
master-bin.000001	2000	Table_map	1	2041	table_id: # (test.t1)
master-bin.000001	2041	Write_rows	1	2075	table_id: # flags: STMT_END_F
master-bin.000001	2075	Table_map	1	2116	table_id: # (test.t1)
master-bin.000001	2116	Write_rows	1	2150	table_id: # flags: STMT_END_F
master-bin.000001	2150	Table_map	1	2191	table_id: # (test.t1)
master-bin.000001	2191	Write_rows	1	2225	table_id: # flags: STMT_END_F
master-bin.000001	2225	Table_map	1	2266	table_id: # (test.t1)
master-bin.000001	2266	Write_rows	1	2300	table_id: # flags: STMT_END_F
master-bin.000001	2300	Table_map	1	2341	table_id: # (test.t1)
master-bin.000001	2341	Write_rows	1	2375	table_id: # flags: STMT_END_F
master-bin.000001	2375	Table_map	1	2416	table_id: # (test.t1)
master-bin.000001	2416	Write_rows	1	2450	table_id: # flags: STMT_END_F
master-bin.000001	2450	Table_map	1	2491	table_id: # (test.t1)
master-bin.000001	2491	Write_rows	1	2525	table_id: # flags: STMT_END_F
master-bin.000001	2525	Table_map	1	2566	table_id: # (test.t1)
master-bin.000001	2566	Write_rows	1	2600	table_id: # flags: STMT_END_F
master-bin.000001	2600	Table_map	1	2641	table_id: # (test.t1)
master-bin.000001	2641	Write_rows	1	2675	table_id: # flags: STMT_END_F
master-bin.000001	2675	Table_map	1	2716	table_id: # (test.t1)
master-bin.000001	2716	Write_rows	1	2750	table_id: # flags: STMT_END_F
master-bin.000001	2750	Table_map	1	2791	table_id: # (test.t1)
master-bin.000001	2791	Write_rows	1	2825	table_id: # flags: STMT_END_F
master-bin.000001	2825	Table_map	1	2866	table_id: # (test.t1)
master-bin.000001	2866	Write_rows	1	2900	table_id: # flags: STMT_END_F
master-bin.000001	2900	Table_map	1	2941	table_id: # (test.t1)
master-bin.000001	2941	Write_rows	1	2975	table_id: # flags: STMT_END_F
master-bin.000001	2975	Table_map	1	3016	table_id: # (test.t1)
master-bin.000001	3016	Write_rows	1	3050	table_id: # flags: STMT_END_F
master-bin.000001	3050	Table_map	1	3091	table_id: # (test.t1)
master-bin.000001	3091	Write_rows	1	3125	table_id: # flags: STMT_END_F
master-bin.000001	3125	Table_map	1	3166	table_id: # (test.t1)
master-bin.000001	3166	Write_rows	1	3200	table_id: # flags: STMT_END_F
master-bin.000001	3200	Table_map	1	3241	table_id: # (test.t1)
master-bin.000001	3241	Write_rows	1	3275	table_id: # flags: STMT_END_F
master-bin.000001	3275	Table_map	1	3316	table_id: # (test.t1)
master-bin.000001	3316	Write_rows	1	3350	table_id: # flags: STMT_END_F
master-bin.000001	3350	Table_map	1	3391	table_id: # (test.t1)
master-bin.000001	3391	Write_rows	1	3425	table_id: # flags: STMT_END_F
master-bin.000001	3425	Table_map	1	3466	table_id: # (test.t1)
master-bin.000001	3466	Write_rows	1	3500	table_id: # flags: STMT_END_F
master-bin.000001	3500	Table_map	1	3541	table_id: # (test.t1)
master-bin.000001	3541	Write_rows	1	3575	table_id: # flags: STMT_END_F
master-bin.000001	3575	Table_map	1	3616	table_id: # (test.t1)
master-bin.000001	3616	Write_rows	1	3650	table_id: # flags: STMT_END_F
master-bin.000001	3650	Table_map	1	3691	table_id: # (test.t1)
master-bin.000001	3691	Write_rows	1	3725	table_id: # flags: STMT_END_F
master-bin.000001	3725	Table_map	1	3766	table_id: # (test.t1)
master-bin.000001	3766	Write_rows	1	3800	table_id: # flags: STMT_END_F
master-bin.000001	3800	Table_map	1	3841	table_id: # (test.t1)
master-bin.000001	3841	Write_rows	1	3875	table_id: # flags: STMT_END_F
master-bin.000001	3875	Table_map	1	3916	table_id: # (test.t1)
master-bin.000001	3916	Write_rows	1	3950	table_id: # flags: STMT_END_F
master-bin.000001	3950	Table_map	1	3991	table_id: # (test.t1)
master-bin.000001	3991	Write_rows	1	4025	table_id: # flags: STMT_END_F
master-bin.000001	4025	Table_map	1	4066	table_id: # (test.t1)
master-bin.000001	4066	Write_rows	1	4100	table_id: # flags: STMT_END_F
master-bin.000001	4100	Table_map	1	4141	table_id: # (test.t1)
master-bin.000001	4141	Write_rows	1	4175	table_id: # flags: STMT_END_F
master-bin.000001	4175	Table_map	1	4216	table_id: # (test.t1)
master-bin.000001	4216	Write_rows	1	4250	table_id: # flags: STMT_END_F
master-bin.000001	4250	Table_map	1	4291	table_id: # (test.t1)
master-bin.000001	4291	Write_rows	1	4325	table_id: # flags: STMT_END_F
master-bin.000001	4325	Table_map	1	4366	table_id: # (test.t1)
master-bin.000001	4366	Write_rows	1	4400	table_id: # flags: STMT_END_F
master-bin.000001	4400	Table_map	1	4441	table_id: # (test.t1)
master-bin.000001	4441	Write_rows	1	4475	table_id: # flags: STMT_END_F
master-bin.000001	4475	Table_map	1	4516	table_id: # (test.t1)
master-bin.000001	4516	Write_rows	1	4550	table_id: # flags: STMT_END_F
master-bin.000001	4550	Table_map	1	4591	table_id: # (test.t1)
master-bin.000001	4591	Write_rows	1	4625	table_id: # flags: STMT_END_F
master-bin.000001	4625	Table_map	1	4666	table_id: # (test.t1)
master-bin.000001	4666	Write_rows	1	4700	table_id: # flags: STMT_END_F
master-bin.000001	4700	Table_map	1	4741	table_id: # (test.t1)
master-bin.000001	4741	Write_rows	1	4775	table_id: # flags: STMT_END_F
master-bin.000001	4775	Table_map	1	4816	table_id: # (test.t1)
master-bin.000001	4816	Write_rows	1	4850	table_id: # flags: STMT_END_F
master-bin.000001	4850	Table_map	1	4891	table_id: # (test.t1)
master-bin.000001	4891	Write_rows	1	4925	table_id: # flags: STMT_END_F
master-bin.000001	4925	Table_map	1	4966	table_id: # (test.t1)
master-bin.000001	4966	Write_rows	1	5000	table_id: # flags: STMT_END_F
master-bin.000001	5000	Table_map	1	5041	table_id: # (test.t1)
master-bin.000001	5041	Write_rows	1	5075	table_id: # flags: STMT_END_F
master-bin.000001	5075	Table_map	1	5116	table_id: # (test.t1)
master-bin.000001	5116	Write_rows	1	5150	table_id: # flags: STMT_END_F
master-bin.000001	5150	Table_map	1	5191	table_id: # (test.t1)
master-bin.000001	5191	Write_rows	1	5225	table_id: # flags: STMT_END_F
master-bin.000001	5225	Table_map	1	5266	table_id: # (test.t1)
master-bin.000001	5266	Write_rows	1	5300	table_id: # flags: STMT_END_F
master-bin.000001	5300	Table_map	1	5341	table_id: # (test.t1)
master-bin.000001	5341	Write_rows	1	5375	table_id: # flags: STMT_END_F
master-bin.000001	5375	Table_map	1	5416	table_id: # (test.t1)
master-bin.000001	5416	Write_rows	1	5450	table_id: # flags: STMT_END_F
master-bin.000001	5450	Table_map	1	5491	table_id: # (test.t1)
master-bin.000001	5491	Write_rows	1	5525	table_id: # flags: STMT_END_F
master-bin.000001	5525	Table_map	1	5566	table_id: # (test.t1)
master-bin.000001	5566	Write_rows	1	5600	table_id: # flags: STMT_END_F
master-bin.000001	5600	Table_map	1	5641	table_id: # (test.t1)
master-bin.000001	5641	Write_rows	1	5675	table_id: # flags: STMT_END_F
master-bin.000001	5675	Table_map	1	5716	table_id: # (test.t1)
master-bin.000001	5716	Write_rows	1	5750	table_id: # flags: STMT_END_F
master-bin.000001	5750	Table_map	1	5791	table_id: # (test.t1)
master-bin.000001	5791	Write_rows	1	5825	table_id: # flags: STMT_END_F
master-bin.000001	5825	Table_map	1	5866	table_id: # (test.t1)
master-bin.000001	5866	Write_rows	1	5900	table_id: # flags: STMT_END_F
master-bin.000001	5900	Table_map	1	5941	table_id: # (test.t1)
master-bin.000001	5941	Write_rows	1	5975	table_id: # flags: STMT_END_F
master-bin.000001	5975	Table_map	1	6016	table_id: # (test.t1)
master-bin.000001	6016	Write_rows	1	6050	table_id: # flags: STMT_END_F
master-bin.000001	6050	Table_map	1	6091	table_id: # (test.t1)
master-bin.000001	6091	Write_rows	1	6125	table_id: # flags: STMT_END_F
master-bin.000001	6125	Table_map	1	6166	table_id: # (test.t1)
master-bin.000001	6166	Write_rows	1	6200	table_id: # flags: STMT_END_F
master-bin.000001	6200	Table_map	1	6241	table_id: # (test.t1)
master-bin.000001	6241	Write_rows	1	6275	table_id: # flags: STMT_END_F
master-bin.000001	6275	Table_map	1	6316	table_id: # (test.t1)
master-bin.000001	6316	Write_rows	1	6350	table_id: # flags: STMT_END_F
master-bin.000001	6350	Table_map	1	6391	table_id: # (test.t1)
master-bin.000001	6391	Write_rows	1	6425	table_id: # flags: STMT_END_F
master-bin.000001	6425	Table_map	1	6466	table_id: # (test.t1)
master-bin.000001	6466	Write_rows	1	6500	table_id: # flags: STMT_END_F
master-bin.000001	6500	Table_map	1	6541	table_id: # (test.t1)
master-bin.000001	6541	Write_rows	1	6575	table_id: # flags: STMT_END_F
master-bin.000001	6575	Table_map	1	6616	table_id: # (test.t1)
master-bin.000001	6616	Write_rows	1	6650	table_id: # flags: STMT_END_F
master-bin.000001	6650	Table_map	1	6691	table_id: # (test.t1)
master-bin.000001	6691	Write_rows	1	6725	table_id: # flags: STMT_END_F
master-bin.000001	6725	Table_map	1	6766	table_id: # (test.t1)
master-bin.000001	6766	Write_rows	1	6800	table_id: # flags: STMT_END_F
master-bin.000001	6800	Table_map	1	6841	table_id: # (test.t1)
master-bin.000001	6841	Write_rows	1	6875	table_id: # flags: STMT_END_F
master-bin.000001	6875	Table_map	1	6916	table_id: # (test.t1)
master-bin.000001	6916	Write_rows	1	6950	table_id: # flags: STMT_END_F
master-bin.000001	6950	Table_map	1	6991	table_id: # (test.t1)
master-bin.000001	6991	Write_rows	1	7025	table_id: # flags: STMT_END_F
master-bin.000001	7025	Table_map	1	7066	table_id: # (test.t1)
master-bin.000001	7066	Write_rows	1	7100	table_id: # flags: STMT_END_F
master-bin.000001	7100	Table_map	1	7141	table_id: # (test.t1)
master-bin.000001	7141	Write_rows	1	7175	table_id: # flags: STMT_END_F
master-bin.000001	7175	Table_map	1	7216	table_id: # (test.t1)
master-bin.000001	7216	Write_rows	1	7250	table_id: # flags: STMT_END_F
master-bin.000001	7250	Table_map	1	7291	table_id: # (test.t1)
master-bin.000001	7291	Write_rows	1	7325	table_id: # flags: STMT_END_F
master-bin.000001	7325	Table_map	1	7366	table_id: # (test.t1)
master-bin.000001	7366	Write_rows	1	7400	table_id: # flags: STMT_END_F
master-bin.000001	7400	Table_map	1	7441	table_id: # (test.t1)
master-bin.000001	7441	Write_rows	1	7475	table_id: # flags: STMT_END_F
master-bin.000001	7475	Table_map	1	7516	table_id: # (test.t1)
master-bin.000001	7516	Write_rows	1	7550	table_id: # flags: STMT_END_F
master-bin.000001	7550	Table_map	1	7591	table_id: # (test.t1)
master-bin.000001	7591	Write_rows	1	7625	table_id: # flags: STMT_END_F
master-bin.000001	7625	Table_map	1	7666	table_id: # (test.t1)
master-bin.000001	7666	Write_rows	1	7700	table_id: # flags: STMT_END_F
master-bin.000001	7700	Table_map	1	7741	table_id: # (test.t1)
master-bin.000001	7741	Write_rows	1	7775	table_id: # flags: STMT_END_F
master-bin.000001	7775	Table_map	1	7816	table_id: # (test.t1)
master-bin.000001	7816	Write_rows	1	7850	table_id: # flags: STMT_END_F
master-bin.000001	7850	Table_map	1	7891	table_id: # (test.t1)
master-bin.000001	7891	Write_rows	1	7925	table_id: # flags: STMT_END_F
master-bin.000001	7925	Table_map	1	7966	table_id: # (test.t1)
master-bin.000001	7966	Write_rows	1	8000	table_id: # flags: STMT_END_F
master-bin.000001	8000	Table_map	1	8041	table_id: # (test.t1)
master-bin.000001	8041	Write_rows	1	8075	table_id: # flags: STMT_END_F
master-bin.000001	8075	Table_map	1	8116	table_id: # (test.t1)
master-bin.000001	8116	Write_rows	1	8150	table_id: # flags: STMT_END_F
master-bin.000001	8150	Table_map	1	8191	table_id: # (test.t1)
master-bin.000001	8191	Write_rows	1	8225	table_id: # flags: STMT_END_F
master-bin.000001	8225	Table_map	1	8266	table_id: # (test.t1)
master-bin.000001	8266	Write_rows	1	8300	table_id: # flags: STMT_END_F
master-bin.000001	8300	Table_map	1	8341	table_id: # (test.t1)
master-bin.000001	8341	Write_rows	1	8375	table_id: # flags: STMT_END_F
master-bin.000001	8375	Table_map	1	8416	table_id: # (test.t1)
master-bin.000001	8416	Write_rows	1	8450	table_id: # flags: STMT_END_F
master-bin.000001	8450	Table_map	1	8491	table_id: # (test.t1)
master-bin.000001	8491	Write_rows	1	8525	table_id: # flags: STMT_END_F
master-bin.000001	8525	Table_map	1	8566	table_id: # (test.t1)
master-bin.000001	8566	Write_rows	1	8600	table_id: # flags: STMT_END_F
master-bin.000001	8600	Table_map	1	8641	table_id: # (test.t1)
master-bin.000001	8641	Write_rows	1	8675	table_id: # flags: STMT_END_F
master-bin.000001	8675	Table_map	1	8716	table_id: # (test.t1)
master-bin.000001	8716	Write_rows	1	8750	table_id: # flags: STMT_END_F
master-bin.000001	8750	Table_map	1	8791	table_id: # (test.t1)
master-bin.000001	8791	Write_rows	1	8825	table_id: # flags: STMT_END_F
master-bin.000001	8825	Table_map	1	8866	table_id: # (test.t1)
master-bin.000001	8866	Write_rows	1	8900	table_id: # flags: STMT_END_F
master-bin.000001	8900	Table_map	1	8941	table_id: # (test.t1)
master-bin.000001	8941	Write_rows	1	8975	table_id: # flags: STMT_END_F
master-bin.000001	8975	Table_map	1	9016	table_id: # (test.t1)
master-bin.000001	9016	Write_rows	1	9050	table_id: # flags: STMT_END_F
master-bin.000001	9050	Table_map	1	9091	table_id: # (test.t1)
master-bin.000001	9091	Write_rows	1	9125	table_id: # flags: STMT_END_F
master-bin.000001	9125	Table_map	1	9166	table_id: # (test.t1)
master-bin.000001	9166	Write_rows	1	9200	table_id: # flags: STMT_END_F
master-bin.000001	9200	Table_map	1	9241	table_id: # (test.t1)
master-bin.000001	9241	Write_rows	1	9275	table_id: # flags: STMT_END_F
master-bin.000001	9275	Table_map	1	9316	table_id: # (test.t1)
master-bin.000001	9316	Write_rows	1	9350	table_id: # flags: STMT_END_F
master-bin.000001	9350	Table_map	1	9391	table_id: # (test.t1)
master-bin.000001	9391	Write_rows	1	9425	table_id: # flags: STMT_END_F
master-bin.000001	9425	Table_map	1	9466	table_id: # (test.t1)
master-bin.000001	9466	Write_rows	1	9500	table_id: # flags: STMT_END_F
master-bin.000001	9500	Table_map	1	9541	table_id: # (test.t1)
master-bin.000001	9541	Write_rows	1	9575	table_id: # flags: STMT_END_F
master-bin.000001	9575	Table_map	1	9616	table_id: # (test.t1)
master-bin.000001	9616	Write_rows	1	9650	table_id: # flags: STMT_END_F
master-bin.000001	9650	Table_map	1	9691	table_id: # (test.t1)
master-bin.000001	9691	Write_rows	1	9725	table_id: # flags: STMT_END_F
master-bin.000001	9725	Table_map	1	9766	table_id: # (test.t1)
master-bin.000001	9766	Write_rows	1	9800	table_id: # flags: STMT_END_F
master-bin.000001	9800	Table_map	1	9841	table_id: # (test.t1)
master-bin.000001	9841	Write_rows	1	9875	table_id: # flags: STMT_END_F
master-bin.000001	9875	Table_map	1	9916	table_id: # (test.t1)
master-bin.000001	9916	Write_rows	1	9950	table_id: # flags: STMT_END_F
master-bin.000001	9950	Table_map	1	9991	table_id: # (test.t1)
master-bin.000001	9991	Write_rows	1	10025	table_id: # flags: STMT_END_F
master-bin.000001	10025	Table_map	1	10066	table_id: # (test.t1)
master-bin.000001	10066	Write_rows	1	10100	table_id: # flags: STMT_END_F
master-bin.000001	10100	Table_map	1	10141	table_id: # (test.t1)
master-bin.000001	10141	Write_rows	1	10175	table_id: # flags: STMT_END_F
master-bin.000001	10175	Table_map	1	10216	table_id: # (test.t1)
master-bin.000001	10216	Write_rows	1	10250	table_id: # flags: STMT_END_F
master-bin.000001	10250	Table_map	1	10291	table_id: # (test.t1)
master-bin.000001	10291	Write_rows	1	10325	table_id: # flags: STMT_END_F
master-bin.000001	10325	Table_map	1	10366	table_id: # (test.t1)
master-bin.000001	10366	Write_rows	1	10400	table_id: # flags: STMT_END_F
master-bin.000001	10400	Table_map	1	10441	table_id: # (test.t1)
master-bin.000001	10441	Write_rows	1	10475	table_id: # flags: STMT_END_F
master-bin.000001	10475	Table_map	1	10516	table_id: # (test.t1)
master-bin.000001	10516	Write_rows	1	10550	table_id: # flags: STMT_END_F
master-bin.000001	10550	Table_map	1	10591	table_id: # (test.t1)
master-bin.000001	10591	Write_rows	1	10625	table_id: # flags: STMT_END_F
master-bin.000001	10625	Table_map	1	10666	table_id: # (test.t1)
master-bin.000001	10666	Write_rows	1	10700	table_id: # flags: STMT_END_F
master-bin.000001	10700	Table_map	1	10741	table_id: # (test.t1)
master-bin.000001	10741	Write_rows	1	10775	table_id: # flags: STMT_END_F
master-bin.000001	10775	Table_map	1	10816	table_id: # (test.t1)
master-bin.000001	10816	Write_rows	1	10850	table_id: # flags: STMT_END_F
master-bin.000001	10850	Table_map	1	10891	table_id: # (test.t1)
master-bin.000001	10891	Write_rows	1	10925	table_id: # flags: STMT_END_F
master-bin.000001	10925	Table_map	1	10966	table_id: # (test.t1)
master-bin.000001	10966	Write_rows	1	11000	table_id: # flags: STMT_END_F
master-bin.000001	11000	Table_map	1	11041	table_id: # (test.t1)
master-bin.000001	11041	Write_rows	1	11075	table_id: # flags: STMT_END_F
master-bin.000001	11075	Table_map	1	11116	table_id: # (test.t1)
master-bin.000001	11116	Write_rows	1	11150	table_id: # flags: STMT_END_F
master-bin.000001	11150	Table_map	1	11191	table_id: # (test.t1)
master-bin.000001	11191	Write_rows	1	11225	table_id: # flags: STMT_END_F
master-bin.000001	11225	Table_map	1	11266	table_id: # (test.t1)
master-bin.000001	11266	Write_rows	1	11300	table_id: # flags: STMT_END_F
master-bin.000001	11300	Table_map	1	11341	table_id: # (test.t1)
master-bin.000001	11341	Write_rows	1	11375	table_id: # flags: STMT_END_F
master-bin.000001	11375	Table_map	1	11416	table_id: # (test.t1)
master-bin.000001	11416	Write_rows	1	11450	table_id: # flags: STMT_END_F
master-bin.000001	11450	Table_map	1	11491	table_id: # (test.t1)
master-bin.000001	11491	Write_rows	1	11525	table_id: # flags: STMT_END_F
master-bin.000001	11525	Table_map	1	11566	table_id: # (test.t1)
master-bin.000001	11566	Write_rows	1	11600	table_id: # flags: STMT_END_F
master-bin.000001	11600	Table_map	1	11641	table_id: # (test.t1)
master-bin.000001	11641	Write_rows	1	11675	table_id: # flags: STMT_END_F
master-bin.000001	11675	Table_map	1	11716	table_id: # (test.t1)
master-bin.000001	11716	Write_rows	1	11750	table_id: # flags: STMT_END_F
master-bin.000001	11750	Table_map	1	11791	table_id: # (test.t1)
master-bin.000001	11791	Write_rows	1	11825	table_id: # flags: STMT_END_F
master-bin.000001	11825	Table_map	1	11866	table_id: # (test.t1)
master-bin.000001	11866	Write_rows	1	11900	table_id: # flags: STMT_END_F
master-bin.000001	11900	Table_map	1	11941	table_id: # (test.t1)
master-bin.000001	11941	Write_rows	1	11975	table_id: # flags: STMT_END_F
master-bin.000001	11975	Table_map	1	12016	table_id: # (test.t1)
master-bin.000001	12016	Write_rows	1	12050	table_id: # flags: STMT_END_F
master-bin.000001	12050	Table_map	1	12091	table_id: # (test.t1)
master-bin.000001	12091	Write_rows	1	12125	table_id: # flags: STMT_END_F
master-bin.000001	12125	Table_map	1	12166	table_id: # (test.t1)
master-bin.000001	12166	Write_rows	1	12200	table_id: # flags: STMT_END_F
master-bin.000001	12200	Table_map	1	12241	table_id: # (test.t1)
master-bin.000001	12241	Write_rows	1	12275	table_id: # flags: STMT_END_F
master-bin.000001	12275	Table_map	1	12316	table_id: # (test.t1)
master-bin.000001	12316	Write_rows	1	12350	table_id: # flags: STMT_END_F
master-bin.000001	12350	Table_map	1	12391	table_id: # (test.t1)
master-bin.000001	12391	Write_rows	1	12425	table_id: # flags: STMT_END_F
master-bin.000001	12425	Table_map	1	12466	table_id: # (test.t1)
master-bin.000001	12466	Write_rows	1	12500	table_id: # flags: STMT_END_F
master-bin.000001	12500	Table_map	1	12541	table_id: # (test.t1)
master-bin.000001	12541	Write_rows	1	12575	table_id: # flags: STMT_END_F
master-bin.000001	12575	Table_map	1	12616	table_id: # (test.t1)
master-bin.000001	12616	Write_rows	1	12650	table_id: # flags: STMT_END_F
master-bin.000001	12650	Table_map	1	12691	table_id: # (test.t1)
master-bin.000001	12691	Write_rows	1	12725	table_id: # flags: STMT_END_F
master-bin.000001	12725	Table_map	1	12766	table_id: # (test.t1)
master-bin.000001	12766	Write_rows	1	12800	table_id: # flags: STMT_END_F
master-bin.000001	12800	Table_map	1	12841	table_id: # (test.t1)
master-bin.000001	12841	Write_rows	1	12875	table_id: # flags: STMT_END_F
master-bin.000001	12875	Table_map	1	12916	table_id: # (test.t1)
master-bin.000001	12916	Write_rows	1	12950	table_id: # flags: STMT_END_F
master-bin.000001	12950	Table_map	1	12991	table_id: # (test.t1)
master-bin.000001	12991	Write_rows	1	13025	table_id: # flags: STMT_END_F
master-bin.000001	13025	Table_map	1	13066	table_id: # (test.t1)
master-bin.000001	13066	Write_rows	1	13100	table_id: # flags: STMT_END_F
master-bin.000001	13100	Table_map	1	13141	table_id: # (test.t1)
master-bin.000001	13141	Write_rows	1	13175	table_id: # flags: STMT_END_F
master-bin.000001	13175	Table_map	1	13216	table_id: # (test.t1)
master-bin.000001	13216	Write_rows	1	13250	table_id: # flags: STMT_END_F
master-bin.000001	13250	Table_map	1	13291	table_id: # (test.t1)
master-bin.000001	13291	Write_rows	1	13325	table_id: # flags: STMT_END_F
master-bin.000001	13325	Table_map	1	13366	table_id: # (test.t1)
master-bin.000001	13366	Write_rows	1	13400	table_id: # flags: STMT_END_F
master-bin.000001	13400	Table_map	1	13441	table_id: # (test.t1)
master-bin.000001	13441	Write_rows	1	13475	table_id: # flags: STMT_END_F
master-bin.000001	13475	Table_map	1	13516	table_id: # (test.t1)
master-bin.000001	13516	Write_rows	1	13550	table_id: # flags: STMT_END_F
master-bin.000001	13550	Table_map	1	13591	table_id: # (test.t1)
master-bin.000001	13591	Write_rows	1	13625	table_id: # flags: STMT_END_F
master-bin.000001	13625	Table_map	1	13666	table_id: # (test.t1)
master-bin.000001	13666	Write_rows	1	13700	table_id: # flags: STMT_END_F
master-bin.000001	13700	Table_map	1	13741	table_id: # (test.t1)
master-bin.000001	13741	Write_rows	1	13775	table_id: # flags: STMT_END_F
master-bin.000001	13775	Table_map	1	13816	table_id: # (test.t1)
master-bin.000001	13816	Write_rows	1	13850	table_id: # flags: STMT_END_F
master-bin.000001	13850	Table_map	1	13891	table_id: # (test.t1)
master-bin.000001	13891	Write_rows	1	13925	table_id: # flags: STMT_END_F
master-bin.000001	13925	Table_map	1	13966	table_id: # (test.t1)
master-bin.000001	13966	Write_rows	1	14000	table_id: # flags: STMT_END_F
master-bin.000001	14000	Table_map	1	14041	table_id: # (test.t1)
master-bin.000001	14041	Write_rows	1	14075	table_id: # flags: STMT_END_F
master-bin.000001	14075	Table_map	1	14116	table_id: # (test.t1)
master-bin.000001	14116	Write_rows	1	14150	table_id: # flags: STMT_END_F
master-bin.000001	14150	Table_map	1	14191	table_id: # (test.t1)
master-bin.000001	14191	Write_rows	1	14225	table_id: # flags: STMT_END_F
master-bin.000001	14225	Table_map	1	14266	table_id: # (test.t1)
master-bin.000001	14266	Write_rows	1	14300	table_id: # flags: STMT_END_F
master-bin.000001	14300	Table_map	1	14341	table_id: # (test.t1)
master-bin.000001	14341	Write_rows	1	14375	table_id: # flags: STMT_END_F
master-bin.000001	14375	Table_map	1	14416	table_id: # (test.t1)
master-bin.000001	14416	Write_rows	1	14450	table_id: # flags: STMT_END_F
master-bin.000001	14450	Table_map	1	14491	table_id: # (test.t1)
master-bin.000001	14491	Write_rows	1	14525	table_id: # flags: STMT_END_F
master-bin.000001	14525	Table_map	1	14566	table_id: # (test.t1)
master-bin.000001	14566	Write_rows	1	14600	table_id: # flags: STMT_END_F
master-bin.000001	14600	Table_map	1	14641	table_id: # (test.t1)
master-bin.000001	14641	Write_rows	1	14675	table_id: # flags: STMT_END_F
master-bin.000001	14675	Table_map	1	14716	table_id: # (test.t1)
master-bin.000001	14716	Write_rows	1	14750	table_id: # flags: STMT_END_F
master-bin.000001	14750	Table_map	1	14791	table_id: # (test.t1)
master-bin.000001	14791	Write_rows	1	14825	table_id: # flags: STMT_END_F
master-bin.000001	14825	Table_map	1	14866	table_id: # (test.t1)
master-bin.000001	14866	Write_rows	1	14900	table_id: # flags: STMT_END_F
master-bin.000001	14900	Table_map	1	14941	table_id: # (test.t1)
master-bin.000001	14941	Write_rows	1	14975	table_id: # flags: STMT_END_F
master-bin.000001	14975	Table_map	1	15016	table_id: # (test.t1)
master-bin.000001	15016	Write_rows	1	15050	table_id: # flags: STMT_END_F
master-bin.000001	15050	Table_map	1	15091	table_id: # (test.t1)
master-bin.000001	15091	Write_rows	1	15125	table_id: # flags: STMT_END_F
master-bin.000001	15125	Table_map	1	15166	table_id: # (test.t1)
master-bin.000001	15166	Write_rows	1	15200	table_id: # flags: STMT_END_F
master-bin.000001	15200	Table_map	1	15241	table_id: # (test.t1)
master-bin.000001	15241	Write_rows	1	15275	table_id: # flags: STMT_END_F
master-bin.000001	15275	Table_map	1	15316	table_id: # (test.t1)
master-bin.000001	15316	Write_rows	1	15350	table_id: # flags: STMT_END_F
master-bin.000001	15350	Table_map	1	15391	table_id: # (test.t1)
master-bin.000001	15391	Write_rows	1	15425	table_id: # flags: STMT_END_F
master-bin.000001	15425	Table_map	1	15466	table_id: # (test.t1)
master-bin.000001	15466	Write_rows	1	15500	table_id: # flags: STMT_END_F
master-bin.000001	15500	Table_map	1	15541	table_id: # (test.t1)
master-bin.000001	15541	Write_rows	1	15575	table_id: # flags: STMT_END_F
master-bin.000001	15575	Table_map	1	15616	table_id: # (test.t1)
master-bin.000001	15616	Write_rows	1	15650	table_id: # flags: STMT_END_F
master-bin.000001	15650	Table_map	1	15691	table_id: # (test.t1)
master-bin.000001	15691	Write_rows	1	15725	table_id: # flags: STMT_END_F
master-bin.000001	15725	Table_map	1	15766	table_id: # (test.t1)
master-bin.000001	15766	Write_rows	1	15800	table_id: # flags: STMT_END_F
master-bin.000001	15800	Table_map	1	15841	table_id: # (test.t1)
master-bin.000001	15841	Write_rows	1	15875	table_id: # flags: STMT_END_F
master-bin.000001	15875	Table_map	1	15916	table_id: # (test.t1)
master-bin.000001	15916	Write_rows	1	15950	table_id: # flags: STMT_END_F
master-bin.000001	15950	Table_map	1	15991	table_id: # (test.t1)
master-bin.000001	15991	Write_rows	1	16025	table_id: # flags: STMT_END_F
master-bin.000001	16025	Table_map	1	16066	table_id: # (test.t1)
master-bin.000001	16066	Write_rows	1	16100	table_id: # flags: STMT_END_F
master-bin.000001	16100	Table_map	1	16141	table_id: # (test.t1)
master-bin.000001	16141	Write_rows	1	16175	table_id: # flags: STMT_END_F
master-bin.000001	16175	Table_map	1	16216	table_id: # (test.t1)
master-bin.000001	16216	Write_rows	1	16250	table_id: # flags: STMT_END_F
master-bin.000001	16250	Table_map	1	16291	table_id: # (test.t1)
master-bin.000001	16291	Write_rows	1	16325	table_id: # flags: STMT_END_F
master-bin.000001	16325	Table_map	1	16366	table_id: # (test.t1)
master-bin.000001	16366	Write_rows	1	16400	table_id: # flags: STMT_END_F
master-bin.000001	16400	Table_map	1	16441	table_id: # (test.t1)
master-bin.000001	16441	Write_rows	1	16475	table_id: # flags: STMT_END_F
master-bin.000001	16475	Table_map	1	16516	table_id: # (test.t1)
master-bin.000001	16516	Write_rows	1	16550	table_id: # flags: STMT_END_F
master-bin.000001	16550	Table_map	1	16591	table_id: # (test.t1)
master-bin.000001	16591	Write_rows	1	16625	table_id: # flags: STMT_END_F
master-bin.000001	16625	Table_map	1	16666	table_id: # (test.t1)
master-bin.000001	16666	Write_rows	1	16700	table_id: # flags: STMT_END_F
master-bin.000001	16700	Table_map	1	16741	table_id: # (test.t1)
master-bin.000001	16741	Write_rows	1	16775	table_id: # flags: STMT_END_F
master-bin.000001	16775	Table_map	1	16816	table_id: # (test.t1)
master-bin.000001	16816	Write_rows	1	16850	table_id: # flags: STMT_END_F
master-bin.000001	16850	Table_map	1	16891	table_id: # (test.t1)
master-bin.000001	16891	Write_rows	1	16925	table_id: # flags: STMT_END_F
master-bin.000001	16925	Table_map	1	16966	table_id: # (test.t1)
master-bin.000001	16966	Write_rows	1	17000	table_id: # flags: STMT_END_F
master-bin.000001	17000	Table_map	1	17041	table_id: # (test.t1)
master-bin.000001	17041	Write_rows	1	17075	table_id: # flags: STMT_END_F
master-bin.000001	17075	Table_map	1	17116	table_id: # (test.t1)
master-bin.000001	17116	Write_rows	1	17150	table_id: # flags: STMT_END_F
master-bin.000001	17150	Table_map	1	17191	table_id: # (test.t1)
master-bin.000001	17191	Write_rows	1	17225	table_id: # flags: STMT_END_F
master-bin.000001	17225	Table_map	1	17266	table_id: # (test.t1)
master-bin.000001	17266	Write_rows	1	17300	table_id: # flags: STMT_END_F
master-bin.000001	17300	Table_map	1	17341	table_id: # (test.t1)
master-bin.000001	17341	Write_rows	1	17375	table_id: # flags: STMT_END_F
master-bin.000001	17375	Table_map	1	17416	table_id: # (test.t1)
master-bin.000001	17416	Write_rows	1	17450	table_id: # flags: STMT_END_F
master-bin.000001	17450	Table_map	1	17491	table_id: # (test.t1)
master-bin.000001	17491	Write_rows	1	17525	table_id: # flags: STMT_END_F
master-bin.000001	17525	Table_map	1	17566	table_id: # (test.t1)
master-bin.000001	17566	Write_rows	1	17600	table_id: # flags: STMT_END_F
master-bin.000001	17600	Table_map	1	17641	table_id: # (test.t1)
master-bin.000001	17641	Write_rows	1	17675	table_id: # flags: STMT_END_F
master-bin.000001	17675	Table_map	1	17716	table_id: # (test.t1)
master-bin.000001	17716	Write_rows	1	17750	table_id: # flags: STMT_END_F
master-bin.000001	17750	Table_map	1	17791	table_id: # (test.t1)
master-bin.000001	17791	Write_rows	1	17825	table_id: # flags: STMT_END_F
master-bin.000001	17825	Table_map	1	17866	table_id: # (test.t1)
master-bin.000001	17866	Write_rows	1	17900	table_id: # flags: STMT_END_F
master-bin.000001	17900	Table_map	1	17941	table_id: # (test.t1)
master-bin.000001	17941	Write_rows	1	17975	table_id: # flags: STMT_END_F
master-bin.000001	17975	Table_map	1	18016	table_id: # (test.t1)
master-bin.000001	18016	Write_rows	1	18050	table_id: # flags: STMT_END_F
master-bin.000001	18050	Table_map	1	18091	table_id: # (test.t1)
master-bin.000001	18091	Write_rows	1	18125	table_id: # flags: STMT_END_F
master-bin.000001	18125	Table_map	1	18166	table_id: # (test.t1)
master-bin.000001	18166	Write_rows	1	18200	table_id: # flags: STMT_END_F
master-bin.000001	18200	Table_map	1	18241	table_id: # (test.t1)
master-bin.000001	18241	Write_rows	1	18275	table_id: # flags: STMT_END_F
master-bin.000001	18275	Table_map	1	18316	table_id: # (test.t1)
master-bin.000001	18316	Write_rows	1	18350	table_id: # flags: STMT_END_F
master-bin.000001	18350	Table_map	1	18391	table_id: # (test.t1)
master-bin.000001	18391	Write_rows	1	18425	table_id: # flags: STMT_END_F
master-bin.000001	18425	Table_map	1	18466	table_id: # (test.t1)
master-bin.000001	18466	Write_rows	1	18500	table_id: # flags: STMT_END_F
master-bin.000001	18500	Table_map	1	18541	table_id: # (test.t1)
master-bin.000001	18541	Write_rows	1	18575	table_id: # flags: STMT_END_F
master-bin.000001	18575	Table_map	1	18616	table_id: # (test.t1)
master-bin.000001	18616	Write_rows	1	18650	table_id: # flags: STMT_END_F
master-bin.000001	18650	Table_map	1	18691	table_id: # (test.t1)
master-bin.000001	18691	Write_rows	1	18725	table_id: # flags: STMT_END_F
master-bin.000001	18725	Table_map	1	18766	table_id: # (test.t1)
master-bin.000001	18766	Write_rows	1	18800	table_id: # flags: STMT_END_F
master-bin.000001	18800	Table_map	1	18841	table_id: # (test.t1)
master-bin.000001	18841	Write_rows	1	18875	table_id: # flags: STMT_END_F
master-bin.000001	18875	Table_map	1	18916	table_id: # (test.t1)
master-bin.000001	18916	Write_rows	1	18950	table_id: # flags: STMT_END_F
master-bin.000001	18950	Table_map	1	18991	table_id: # (test.t1)
master-bin.000001	18991	Write_rows	1	19025	table_id: # flags: STMT_END_F
master-bin.000001	19025	Table_map	1	19066	table_id: # (test.t1)
master-bin.000001	19066	Write_rows	1	19100	table_id: # flags: STMT_END_F
master-bin.000001	19100	Table_map	1	19141	table_id: # (test.t1)
master-bin.000001	19141	Write_rows	1	19175	table_id: # flags: STMT_END_F
master-bin.000001	19175	Table_map	1	19216	table_id: # (test.t1)
master-bin.000001	19216	Write_rows	1	19250	table_id: # flags: STMT_END_F
master-bin.000001	19250	Table_map	1	19291	table_id: # (test.t1)
master-bin.000001	19291	Write_rows	1	19325	table_id: # flags: STMT_END_F
master-bin.000001	19325	Table_map	1	19366	table_id: # (test.t1)
master-bin.000001	19366	Write_rows	1	19400	table_id: # flags: STMT_END_F
master-bin.000001	19400	Table_map	1	19441	table_id: # (test.t1)
master-bin.000001	19441	Write_rows	1	19475	table_id: # flags: STMT_END_F
master-bin.000001	19475	Table_map	1	19516	table_id: # (test.t1)
master-bin.000001	19516	Write_rows	1	19550	table_id: # flags: STMT_END_F
master-bin.000001	19550	Table_map	1	19591	table_id: # (test.t1)
master-bin.000001	19591	Write_rows	1	19625	table_id: # flags: STMT_END_F
master-bin.000001	19625	Table_map	1	19666	table_id: # (test.t1)
master-bin.000001	19666	Write_rows	1	19700	table_id: # flags: STMT_END_F
master-bin.000001	19700	Table_map	1	19741	table_id: # (test.t1)
master-bin.000001	19741	Write_rows	1	19775	table_id: # flags: STMT_END_F
master-bin.000001	19775	Table_map	1	19816	table_id: # (test.t1)
master-bin.000001	19816	Write_rows	1	19850	table_id: # flags: STMT_END_F
master-bin.000001	19850	Table_map	1	19891	table_id: # (test.t1)
master-bin.000001	19891	Write_rows	1	19925	table_id: # flags: STMT_END_F
master-bin.000001	19925	Table_map	1	19966	table_id: # (test.t1)
master-bin.000001	19966	Write_rows	1	20000	table_id: # flags: STMT_END_F
master-bin.000001	20000	Table_map	1	20041	table_id: # (test.t1)
master-bin.000001	20041	Write_rows	1	20075	table_id: # flags: STMT_END_F
master-bin.000001	20075	Table_map	1	20116	table_id: # (test.t1)
master-bin.000001	20116	Write_rows	1	20150	table_id: # flags: STMT_END_F
master-bin.000001	20150	Table_map	1	20191	table_id: # (test.t1)
master-bin.000001	20191	Write_rows	1	20225	table_id: # flags: STMT_END_F
master-bin.000001	20225	Table_map	1	20266	table_id: # (test.t1)
master-bin.000001	20266	Write_rows	1	20300	table_id: # flags: STMT_END_F
master-bin.000001	20300	Table_map	1	20341	table_id: # (test.t1)
master-bin.000001	20341	Write_rows	1	20375	table_id: # flags: STMT_END_F
master-bin.000001	20375	Table_map	1	20416	table_id: # (test.t1)
master-bin.000001	20416	Write_rows	1	20450	table_id: # flags: STMT_END_F
master-bin.000001	20450	Table_map	1	20491	table_id: # (test.t1)
master-bin.000001	20491	Write_rows	1	20525	table_id: # flags: STMT_END_F
master-bin.000001	20525	Table_map	1	20566	table_id: # (test.t1)
master-bin.000001	20566	Write_rows	1	20600	table_id: # flags: STMT_END_F
master-bin.000001	20600	Table_map	1	20641	table_id: # (test.t1)
master-bin.000001	20641	Write_rows	1	20675	table_id: # flags: STMT_END_F
master-bin.000001	20675	Table_map	1	20716	table_id: # (test.t1)
master-bin.000001	20716	Write_rows	1	20750	table_id: # flags: STMT_END_F
master-bin.000001	20750	Table_map	1	20791	table_id: # (test.t1)
master-bin.000001	20791	Write_rows	1	20825	table_id: # flags: STMT_END_F
master-bin.000001	20825	Table_map	1	20866	table_id: # (test.t1)
master-bin.000001	20866	Write_rows	1	20900	table_id: # flags: STMT_END_F
master-bin.000001	20900	Table_map	1	20941	table_id: # (test.t1)
master-bin.000001	20941	Write_rows	1	20975	table_id: # flags: STMT_END_F
master-bin.000001	20975	Table_map	1	21016	table_id: # (test.t1)
master-bin.000001	21016	Write_rows	1	21050	table_id: # flags: STMT_END_F
master-bin.000001	21050	Table_map	1	21091	table_id: # (test.t1)
master-bin.000001	21091	Write_rows	1	21125	table_id: # flags: STMT_END_F
master-bin.000001	21125	Table_map	1	21166	table_id: # (test.t1)
master-bin.000001	21166	Write_rows	1	21200	table_id: # flags: STMT_END_F
master-bin.000001	21200	Table_map	1	21241	table_id: # (test.t1)
master-bin.000001	21241	Write_rows	1	21275	table_id: # flags: STMT_END_F
master-bin.000001	21275	Table_map	1	21316	table_id: # (test.t1)
master-bin.000001	21316	Write_rows	1	21350	table_id: # flags: STMT_END_F
master-bin.000001	21350	Table_map	1	21391	table_id: # (test.t1)
master-bin.000001	21391	Write_rows	1	21425	table_id: # flags: STMT_END_F
master-bin.000001	21425	Table_map	1	21466	table_id: # (test.t1)
master-bin.000001	21466	Write_rows	1	21500	table_id: # flags: STMT_END_F
master-bin.000001	21500	Table_map	1	21541	table_id: # (test.t1)
master-bin.000001	21541	Write_rows	1	21575	table_id: # flags: STMT_END_F
master-bin.000001	21575	Table_map	1	21616	table_id: # (test.t1)
master-bin.000001	21616	Write_rows	1	21650	table_id: # flags: STMT_END_F
master-bin.000001	21650	Table_map	1	21691	table_id: # (test.t1)
master-bin.000001	21691	Write_rows	1	21725	table_id: # flags: STMT_END_F
master-bin.000001	21725	Table_map	1	21766	table_id: # (test.t1)
master-bin.000001	21766	Write_rows	1	21800	table_id: # flags: STMT_END_F
master-bin.000001	21800	Table_map	1	21841	table_id: # (test.t1)
master-bin.000001	21841	Write_rows	1	21875	table_id: # flags: STMT_END_F
master-bin.000001	21875	Table_map	1	21916	table_id: # (test.t1)
master-bin.000001	21916	Write_rows	1	21950	table_id: # flags: STMT_END_F
master-bin.000001	21950	Table_map	1	21991	table_id: # (test.t1)
master-bin.000001	21991	Write_rows	1	22025	table_id: # flags: STMT_END_F
master-bin.000001	22025	Table_map	1	22066	table_id: # (test.t1)
master-bin.000001	22066	Write_rows	1	22100	table_id: # flags: STMT_END_F
master-bin.000001	22100	Table_map	1	22141	table_id: # (test.t1)
master-bin.000001	22141	Write_rows	1	22175	table_id: # flags: STMT_END_F
master-bin.000001	22175	Table_map	1	22216	table_id: # (test.t1)
master-bin.000001	22216	Write_rows	1	22250	table_id: # flags: STMT_END_F
master-bin.000001	22250	Table_map	1	22291	table_id: # (test.t1)
master-bin.000001	22291	Write_rows	1	22325	table_id: # flags: STMT_END_F
master-bin.000001	22325	Table_map	1	22366	table_id: # (test.t1)
master-bin.000001	22366	Write_rows	1	22400	table_id: # flags: STMT_END_F
master-bin.000001	22400	Table_map	1	22441	table_id: # (test.t1)
master-bin.000001	22441	Write_rows	1	22475	table_id: # flags: STMT_END_F
master-bin.000001	22475	Table_map	1	22516	table_id: # (test.t1)
master-bin.000001	22516	Write_rows	1	22550	table_id: # flags: STMT_END_F
master-bin.000001	22550	Table_map	1	22591	table_id: # (test.t1)
master-bin.000001	22591	Write_rows	1	22625	table_id: # flags: STMT_END_F
master-bin.000001	22625	Table_map	1	22666	table_id: # (test.t1)
master-bin.000001	22666	Write_rows	1	22700	table_id: # flags: STMT_END_F
master-bin.000001	22700	Table_map	1	22741	table_id: # (test.t1)
master-bin.000001	22741	Write_rows	1	22775	table_id: # flags: STMT_END_F
master-bin.000001	22775	Table_map	1	22816	table_id: # (test.t1)
master-bin.000001	22816	Write_rows	1	22850	table_id: # flags: STMT_END_F
master-bin.000001	22850	Table_map	1	22891	table_id: # (test.t1)
master-bin.000001	22891	Write_rows	1	22925	table_id: # flags: STMT_END_F
master-bin.000001	22925	Table_map	1	22966	table_id: # (test.t1)
master-bin.000001	22966	Write_rows	1	23000	table_id: # flags: STMT_END_F
master-bin.000001	23000	Table_map	1	23041	table_id: # (test.t1)
master-bin.000001	23041	Write_rows	1	23075	table_id: # flags: STMT_END_F
master-bin.000001	23075	Table_map	1	23116	table_id: # (test.t1)
master-bin.000001	23116	Write_rows	1	23150	table_id: # flags: STMT_END_F
master-bin.000001	23150	Table_map	1	23191	table_id: # (test.t1)
master-bin.000001	23191	Write_rows	1	23225	table_id: # flags: STMT_END_F
master-bin.000001	23225	Table_map	1	23266	table_id: # (test.t1)
master-bin.000001	23266	Write_rows	1	23300	table_id: # flags: STMT_END_F
master-bin.000001	23300	Table_map	1	23341	table_id: # (test.t1)
master-bin.000001	23341	Write_rows	1	23375	table_id: # flags: STMT_END_F
master-bin.000001	23375	Table_map	1	23416	table_id: # (test.t1)
master-bin.000001	23416	Write_rows	1	23450	table_id: # flags: STMT_END_F
master-bin.000001	23450	Table_map	1	23491	table_id: # (test.t1)
master-bin.000001	23491	Write_rows	1	23525	table_id: # flags: STMT_END_F
master-bin.000001	23525	Table_map	1	23566	table_id: # (test.t1)
master-bin.000001	23566	Write_rows	1	23600	table_id: # flags: STMT_END_F
master-bin.000001	23600	Table_map	1	23641	table_id: # (test.t1)
master-bin.000001	23641	Write_rows	1	23675	table_id: # flags: STMT_END_F
master-bin.000001	23675	Table_map	1	23716	table_id: # (test.t1)
master-bin.000001	23716	Write_rows	1	23750	table_id: # flags: STMT_END_F
master-bin.000001	23750	Table_map	1	23791	table_id: # (test.t1)
master-bin.000001	23791	Write_rows	1	23825	table_id: # flags: STMT_END_F
master-bin.000001	23825	Table_map	1	23866	table_id: # (test.t1)
master-bin.000001	23866	Write_rows	1	23900	table_id: # flags: STMT_END_F
master-bin.000001	23900	Table_map	1	23941	table_id: # (test.t1)
master-bin.000001	23941	Write_rows	1	23975	table_id: # flags: STMT_END_F
master-bin.000001	23975	Table_map	1	24016	table_id: # (test.t1)
master-bin.000001	24016	Write_rows	1	24050	table_id: # flags: STMT_END_F
master-bin.000001	24050	Table_map	1	24091	table_id: # (test.t1)
master-bin.000001	24091	Write_rows	1	24125	table_id: # flags: STMT_END_F
master-bin.000001	24125	Table_map	1	24166	table_id: # (test.t1)
master-bin.000001	24166	Write_rows	1	24200	table_id: # flags: STMT_END_F
master-bin.000001	24200	Table_map	1	24241	table_id: # (test.t1)
master-bin.000001	24241	Write_rows	1	24275	table_id: # flags: STMT_END_F
master-bin.000001	24275	Table_map	1	24316	table_id: # (test.t1)
master-bin.000001	24316	Write_rows	1	24350	table_id: # flags: STMT_END_F
master-bin.000001	24350	Table_map	1	24391	table_id: # (test.t1)
master-bin.000001	24391	Write_rows	1	24425	table_id: # flags: STMT_END_F
master-bin.000001	24425	Table_map	1	24466	table_id: # (test.t1)
master-bin.000001	24466	Write_rows	1	24500	table_id: # flags: STMT_END_F
master-bin.000001	24500	Table_map	1	24541	table_id: # (test.t1)
master-bin.000001	24541	Write_rows	1	24575	table_id: # flags: STMT_END_F
master-bin.000001	24575	Table_map	1	24616	table_id: # (test.t1)
master-bin.000001	24616	Write_rows	1	24650	table_id: # flags: STMT_END_F
master-bin.000001	24650	Table_map	1	24691	table_id: # (test.t1)
master-bin.000001	24691	Write_rows	1	24725	table_id: # flags: STMT_END_F
master-bin.000001	24725	Table_map	1	24766	table_id: # (test.t1)
master-bin.000001	24766	Write_rows	1	24800	table_id: # flags: STMT_END_F
master-bin.000001	24800	Table_map	1	24841	table_id: # (test.t1)
master-bin.000001	24841	Write_rows	1	24875	table_id: # flags: STMT_END_F
master-bin.000001	24875	Table_map	1	24916	table_id: # (test.t1)
master-bin.000001	24916	Write_rows	1	24950	table_id: # flags: STMT_END_F
master-bin.000001	24950	Table_map	1	24991	table_id: # (test.t1)
master-bin.000001	24991	Write_rows	1	25025	table_id: # flags: STMT_END_F
master-bin.000001	25025	Table_map	1	25066	table_id: # (test.t1)
master-bin.000001	25066	Write_rows	1	25100	table_id: # flags: STMT_END_F
master-bin.000001	25100	Table_map	1	25141	table_id: # (test.t1)
master-bin.000001	25141	Write_rows	1	25175	table_id: # flags: STMT_END_F
master-bin.000001	25175	Table_map	1	25216	table_id: # (test.t1)
master-bin.000001	25216	Write_rows	1	25250	table_id: # flags: STMT_END_F
master-bin.000001	25250	Table_map	1	25291	table_id: # (test.t1)
master-bin.000001	25291	Write_rows	1	25325	table_id: # flags: STMT_END_F
master-bin.000001	25325	Table_map	1	25366	table_id: # (test.t1)
master-bin.000001	25366	Write_rows	1	25400	table_id: # flags: STMT_END_F
master-bin.000001	25400	Table_map	1	25441	table_id: # (test.t1)
master-bin.000001	25441	Write_rows	1	25475	table_id: # flags: STMT_END_F
master-bin.000001	25475	Table_map	1	25516	table_id: # (test.t1)
master-bin.000001	25516	Write_rows	1	25550	table_id: # flags: STMT_END_F
master-bin.000001	25550	Table_map	1	25591	table_id: # (test.t1)
master-bin.000001	25591	Write_rows	1	25625	table_id: # flags: STMT_END_F
master-bin.000001	25625	Table_map	1	25666	table_id: # (test.t1)
master-bin.000001	25666	Write_rows	1	25700	table_id: # flags: STMT_END_F
master-bin.000001	25700	Table_map	1	25741	table_id: # (test.t1)
master-bin.000001	25741	Write_rows	1	25775	table_id: # flags: STMT_END_F
master-bin.000001	25775	Table_map	1	25816	table_id: # (test.t1)
master-bin.000001	25816	Write_rows	1	25850	table_id: # flags: STMT_END_F
master-bin.000001	25850	Table_map	1	25891	table_id: # (test.t1)
master-bin.000001	25891	Write_rows	1	25925	table_id: # flags: STMT_END_F
master-bin.000001	25925	Table_map	1	25966	table_id: # (test.t1)
master-bin.000001	25966	Write_rows	1	26000	table_id: # flags: STMT_END_F
master-bin.000001	26000	Table_map	1	26041	table_id: # (test.t1)
master-bin.000001	26041	Write_rows	1	26075	table_id: # flags: STMT_END_F
master-bin.000001	26075	Table_map	1	26116	table_id: # (test.t1)
master-bin.000001	26116	Write_rows	1	26150	table_id: # flags: STMT_END_F
master-bin.000001	26150	Table_map	1	26191	table_id: # (test.t1)
master-bin.000001	26191	Write_rows	1	26225	table_id: # flags: STMT_END_F
master-bin.000001	26225	Table_map	1	26266	table_id: # (test.t1)
master-bin.000001	26266	Write_rows	1	26300	table_id: # flags: STMT_END_F
master-bin.000001	26300	Table_map	1	26341	table_id: # (test.t1)
master-bin.000001	26341	Write_rows	1	26375	table_id: # flags: STMT_END_F
master-bin.000001	26375	Table_map	1	26416	table_id: # (test.t1)
master-bin.000001	26416	Write_rows	1	26450	table_id: # flags: STMT_END_F
master-bin.000001	26450	Table_map	1	26491	table_id: # (test.t1)
master-bin.000001	26491	Write_rows	1	26525	table_id: # flags: STMT_END_F
master-bin.000001	26525	Table_map	1	26566	table_id: # (test.t1)
master-bin.000001	26566	Write_rows	1	26600	table_id: # flags: STMT_END_F
master-bin.000001	26600	Table_map	1	26641	table_id: # (test.t1)
master-bin.000001	26641	Write_rows	1	26675	table_id: # flags: STMT_END_F
master-bin.000001	26675	Table_map	1	26716	table_id: # (test.t1)
master-bin.000001	26716	Write_rows	1	26750	table_id: # flags: STMT_END_F
master-bin.000001	26750	Table_map	1	26791	table_id: # (test.t1)
master-bin.000001	26791	Write_rows	1	26825	table_id: # flags: STMT_END_F
master-bin.000001	26825	Table_map	1	26866	table_id: # (test.t1)
master-bin.000001	26866	Write_rows	1	26900	table_id: # flags: STMT_END_F
master-bin.000001	26900	Table_map	1	26941	table_id: # (test.t1)
master-bin.000001	26941	Write_rows	1	26975	table_id: # flags: STMT_END_F
master-bin.000001	26975	Table_map	1	27016	table_id: # (test.t1)
master-bin.000001	27016	Write_rows	1	27050	table_id: # flags: STMT_END_F
master-bin.000001	27050	Table_map	1	27091	table_id: # (test.t1)
master-bin.000001	27091	Write_rows	1	27125	table_id: # flags: STMT_END_F
master-bin.000001	27125	Table_map	1	27166	table_id: # (test.t1)
master-bin.000001	27166	Write_rows	1	27200	table_id: # flags: STMT_END_F
master-bin.000001	27200	Table_map	1	27241	table_id: # (test.t1)
master-bin.000001	27241	Write_rows	1	27275	table_id: # flags: STMT_END_F
master-bin.000001	27275	Table_map	1	27316	table_id: # (test.t1)
master-bin.000001	27316	Write_rows	1	27350	table_id: # flags: STMT_END_F
master-bin.000001	27350	Table_map	1	27391	table_id: # (test.t1)
master-bin.000001	27391	Write_rows	1	27425	table_id: # flags: STMT_END_F
master-bin.000001	27425	Table_map	1	27466	table_id: # (test.t1)
master-bin.000001	27466	Write_rows	1	27500	table_id: # flags: STMT_END_F
master-bin.000001	27500	Table_map	1	27541	table_id: # (test.t1)
master-bin.000001	27541	Write_rows	1	27575	table_id: # flags: STMT_END_F
master-bin.000001	27575	Table_map	1	27616	table_id: # (test.t1)
master-bin.000001	27616	Write_rows	1	27650	table_id: # flags: STMT_END_F
master-bin.000001	27650	Table_map	1	27691	table_id: # (test.t1)
master-bin.000001	27691	Write_rows	1	27725	table_id: # flags: STMT_END_F
master-bin.000001	27725	Table_map	1	27766	table_id: # (test.t1)
master-bin.000001	27766	Write_rows	1	27800	table_id: # flags: STMT_END_F
master-bin.000001	27800	Table_map	1	27841	table_id: # (test.t1)
master-bin.000001	27841	Write_rows	1	27875	table_id: # flags: STMT_END_F
master-bin.000001	27875	Table_map	1	27916	table_id: # (test.t1)
master-bin.000001	27916	Write_rows	1	27950	table_id: # flags: STMT_END_F
master-bin.000001	27950	Table_map	1	27991	table_id: # (test.t1)
master-bin.000001	27991	Write_rows	1	28025	table_id: # flags: STMT_END_F
master-bin.000001	28025	Table_map	1	28066	table_id: # (test.t1)
master-bin.000001	28066	Write_rows	1	28100	table_id: # flags: STMT_END_F
master-bin.000001	28100	Table_map	1	28141	table_id: # (test.t1)
master-bin.000001	28141	Write_rows	1	28175	table_id: # flags: STMT_END_F
master-bin.000001	28175	Table_map	1	28216	table_id: # (test.t1)
master-bin.000001	28216	Write_rows	1	28250	table_id: # flags: STMT_END_F
master-bin.000001	28250	Table_map	1	28291	table_id: # (test.t1)
master-bin.000001	28291	Write_rows	1	28325	table_id: # flags: STMT_END_F
master-bin.000001	28325	Table_map	1	28366	table_id: # (test.t1)
master-bin.000001	28366	Write_rows	1	28400	table_id: # flags: STMT_END_F
master-bin.000001	28400	Table_map	1	28441	table_id: # (test.t1)
master-bin.000001	28441	Write_rows	1	28475	table_id: # flags: STMT_END_F
master-bin.000001	28475	Table_map	1	28516	table_id: # (test.t1)
master-bin.000001	28516	Write_rows	1	28550	table_id: # flags: STMT_END_F
master-bin.000001	28550	Table_map	1	28591	table_id: # (test.t1)
master-bin.000001	28591	Write_rows	1	28625	table_id: # flags: STMT_END_F
master-bin.000001	28625	Table_map	1	28666	table_id: # (test.t1)
master-bin.000001	28666	Write_rows	1	28700	table_id: # flags: STMT_END_F
master-bin.000001	28700	Table_map	1	28741	table_id: # (test.t1)
master-bin.000001	28741	Write_rows	1	28775	table_id: # flags: STMT_END_F
master-bin.000001	28775	Table_map	1	28816	table_id: # (test.t1)
master-bin.000001	28816	Write_rows	1	28850	table_id: # flags: STMT_END_F
master-bin.000001	28850	Table_map	1	28891	table_id: # (test.t1)
master-bin.000001	28891	Write_rows	1	28925	table_id: # flags: STMT_END_F
master-bin.000001	28925	Table_map	1	28966	table_id: # (test.t1)
master-bin.000001	28966	Write_rows	1	29000	table_id: # flags: STMT_END_F
master-bin.000001	29000	Table_map	1	29041	table_id: # (test.t1)
master-bin.000001	29041	Write_rows	1	29075	table_id: # flags: STMT_END_F
master-bin.000001	29075	Table_map	1	29116	table_id: # (test.t1)
master-bin.000001	29116	Write_rows	1	29150	table_id: # flags: STMT_END_F
master-bin.000001	29150	Table_map	1	29191	table_id: # (test.t1)
master-bin.000001	29191	Write_rows	1	29225	table_id: # flags: STMT_END_F
master-bin.000001	29225	Table_map	1	29266	table_id: # (test.t1)
master-bin.000001	29266	Write_rows	1	29300	table_id: # flags: STMT_END_F
master-bin.000001	29300	Table_map	1	29341	table_id: # (test.t1)
master-bin.000001	29341	Write_rows	1	29375	table_id: # flags: STMT_END_F
master-bin.000001	29375	Table_map	1	29416	table_id: # (test.t1)
master-bin.000001	29416	Write_rows	1	29450	table_id: # flags: STMT_END_F
master-bin.000001	29450	Table_map	1	29491	table_id: # (test.t1)
master-bin.000001	29491	Write_rows	1	29525	table_id: # flags: STMT_END_F
master-bin.000001	29525	Table_map	1	29566	table_id: # (test.t1)
master-bin.000001	29566	Write_rows	1	29600	table_id: # flags: STMT_END_F
master-bin.000001	29600	Table_map	1	29641	table_id: # (test.t1)
master-bin.000001	29641	Write_rows	1	29675	table_id: # flags: STMT_END_F
master-bin.000001	29675	Table_map	1	29716	table_id: # (test.t1)
master-bin.000001	29716	Write_rows	1	29750	table_id: # flags: STMT_END_F
master-bin.000001	29750	Table_map	1	29791	table_id: # (test.t1)
master-bin.000001	29791	Write_rows	1	29825	table_id: # flags: STMT_END_F
master-bin.000001	29825	Table_map	1	29866	table_id: # (test.t1)
master-bin.000001	29866	Write_rows	1	29900	table_id: # flags: STMT_END_F
master-bin.000001	29900	Table_map	1	29941	table_id: # (test.t1)
master-bin.000001	29941	Write_rows	1	29975	table_id: # flags: STMT_END_F
master-bin.000001	29975	Table_map	1	30016	table_id: # (test.t1)
master-bin.000001	30016	Write_rows	1	30050	table_id: # flags: STMT_END_F
master-bin.000001	30050	Table_map	1	30091	table_id: # (test.t1)
master-bin.000001	30091	Write_rows	1	30125	table_id: # flags: STMT_END_F
master-bin.000001	30125	Table_map	1	30166	table_id: # (test.t1)
master-bin.000001	30166	Write_rows	1	30200	table_id: # flags: STMT_END_F
master-bin.000001	30200	Table_map	1	30241	table_id: # (test.t1)
master-bin.000001	30241	Write_rows	1	30275	table_id: # flags: STMT_END_F
master-bin.000001	30275	Xid	1	30302	COMMIT /* XID */
master-bin.000001	30302	Rotate	1	30346	master-bin.000002;pos=4
drop table t1;
set global binlog_cache_size=@bcs;
set session autocommit = @ac;
drop table if exists t1;
reset master;
create table t1 (a bigint unsigned, b bigint(20) unsigned);
prepare stmt from "insert into t1 values (?,?)";
set @a= 9999999999999999;
set @b= 14632475938453979136;
execute stmt using @a, @b;
deallocate prepare stmt;
drop table t1;
show binlog events from 0;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
master-bin.000001	107	Query	1	228	use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
master-bin.000001	228	Query	1	296	BEGIN
master-bin.000001	296	Table_map	1	338	table_id: # (test.t1)
master-bin.000001	338	Write_rows	1	384	table_id: # flags: STMT_END_F
master-bin.000001	384	Query	1	453	COMMIT
master-bin.000001	453	Query	1	529	use `test`; drop table t1
reset master;
CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE bug39182;
CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE PROCEDURE p1()
BEGIN
DECLARE s1 VARCHAR(255);
SET s1= "test";
CREATE TEMPORARY TABLE tmp1
SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
SELECT 
COLLATION(NAME_CONST('s1', _utf8'test')) c1,
COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
COLLATION(s1) c3,
COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
COERCIBILITY(s1) d3;
DROP TEMPORARY TABLE tmp1;
END//
CALL p1();
c1	c2	c3	d1	d2	d3
utf8_general_ci	utf8_unicode_ci	utf8_unicode_ci	2	2	2
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
master-bin.000001	#	Query	#	#	use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
master-bin.000001	#	Query	#	#	use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
BEGIN
DECLARE s1 VARCHAR(255);
SET s1= "test";
CREATE TEMPORARY TABLE tmp1
SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
SELECT 
COLLATION(NAME_CONST('s1', _utf8'test')) c1,
COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
COLLATION(s1) c3,
COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
COERCIBILITY(s1) d3;
DROP TEMPORARY TABLE tmp1;
END
DROP PROCEDURE p1;
DROP TABLE t1;
DROP DATABASE bug39182;
USE test;
CREATE PROCEDURE p1(IN v1 INT)
BEGIN
CREATE TABLE t1 SELECT v1;
DROP TABLE t1;
END//
CREATE PROCEDURE p2()
BEGIN
DECLARE v1 INT;
CREATE TABLE t1 SELECT v1+1;
DROP TABLE t1;
END//
CREATE PROCEDURE p3(IN v1 INT)
BEGIN
CREATE TABLE t1 SELECT 1 FROM DUAL WHERE v1!=0;
DROP TABLE t1;
END//
CREATE PROCEDURE p4(IN v1 INT)
BEGIN
DECLARE v2 INT;
CREATE TABLE t1 SELECT 1, v1, v2;
DROP TABLE t1;
CREATE TABLE t1 SELECT 1, v1+1, v2;
DROP TABLE t1;
END//
CALL p1(1);
CALL p2();
CALL p3(0);
CALL p4(0);
DROP PROCEDURE p1;
DROP PROCEDURE p2;
DROP PROCEDURE p3;
DROP PROCEDURE p4;
End of 5.0 tests
reset master;
create table t1 (id tinyint auto_increment primary key);
set insert_id=128;
insert into t1 values(null);
Warnings:
Warning	1264	Out of range value for column 'id' at row 1
select * from t1;
id
127
drop table t1;
create table t1 (a int);
create table if not exists t2 select * from t1;
create temporary table tt1 (a int);
create table if not exists t3 like tt1;
USE mysql;
INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test');
UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
DELETE FROM user WHERE host='localhost' AND user='@#@';
use test;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1 (id tinyint auto_increment primary key)
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; drop table t1
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int)
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t2` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t3` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Delete_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
drop table t1,t2,t3,tt1;
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
insert delayed into t1 values (207);
insert delayed into t1 values (null);
insert delayed into t1 values (300);
FLUSH TABLES;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1 (id tinyint auto_increment primary key)
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; drop table t1
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int)
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t2` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t3` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Delete_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Query	#	#	use `test`; FLUSH TABLES
insert delayed into t1 values (null),(null),(null),(null);
insert delayed into t1 values (null),(null),(400),(null);
select * from t1;
a
207
208
300
301
302
303
304
305
306
400
401
drop table t1;
reset master;
drop table if exists t3;
create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
show master status;
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
master-bin.000001	347		
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
show master status /* must show new binlog index after rotating */;
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
master-bin.000002	107		
drop table t3;
#
# Bug #45998: database crashes when running "create as select"
#
CREATE DATABASE test1;
USE test1;
DROP DATABASE test1;
CREATE TABLE test.t1(a int);
INSERT INTO test.t1 VALUES (1), (2);
CREATE TABLE test.t2 SELECT * FROM test.t1;
USE test;
DROP TABLES t1, t2;
RESET MASTER;
CREATE TABLE t1 (a INT PRIMARY KEY);
BINLOG '
3u9kSA8KAAAAZgAAAGoAAAABAAQANS4xLjM1LW1hcmlhLWJldGExLWRlYnVnLWxvZwAAAAAAAAAA
AAAAAAAAAAAAAAAAAADe72RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
';
INSERT INTO t1 VALUES (1);
BINLOG '
3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
';
SHOW BINLOG EVENTS;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
#	#	Format_desc	1	#	Server ver: #, Binlog ver: #
#	#	Query	1	#	use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
#	#	Query	1	#	BEGIN
#	#	Table_map	1	#	table_id: # (test.t1)
#	#	Write_rows	1	#	table_id: # flags: STMT_END_F
#	#	Query	1	#	COMMIT
#	#	Query	1	#	BEGIN
#	#	Table_map	1	#	table_id: # (test.t1)
#	#	Write_rows	1	#	table_id: # flags: STMT_END_F
#	#	Query	1	#	COMMIT
DROP TABLE t1;