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 106;
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 106;
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	106	Server version, Binlog ver: 4
master-bin.000001	106	Query	1	205	use `test`; create table t1(n int) engine=innodb
master-bin.000001	205	Query	1	273	BEGIN
master-bin.000001	273	Table_map	1	314	table_id: # (test.t1)
master-bin.000001	314	Write_rows	1	348	table_id: # flags: STMT_END_F
master-bin.000001	348	Table_map	1	389	table_id: # (test.t1)
master-bin.000001	389	Write_rows	1	423	table_id: # flags: STMT_END_F
master-bin.000001	423	Table_map	1	464	table_id: # (test.t1)
master-bin.000001	464	Write_rows	1	498	table_id: # flags: STMT_END_F
master-bin.000001	498	Xid	1	525	COMMIT /* XID */
master-bin.000001	525	Query	1	601	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	106	Server version, Binlog ver: 4
master-bin.000001	106	Query	1	206	use `test`; create table t1 (a 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	Table_map	1	540	table_id: # (test.t1)
master-bin.000001	540	Write_rows	1	574	table_id: # flags: STMT_END_F
master-bin.000001	574	Table_map	1	615	table_id: # (test.t1)
master-bin.000001	615	Write_rows	1	649	table_id: # flags: STMT_END_F
master-bin.000001	649	Table_map	1	690	table_id: # (test.t1)
master-bin.000001	690	Write_rows	1	724	table_id: # flags: STMT_END_F
master-bin.000001	724	Table_map	1	765	table_id: # (test.t1)
master-bin.000001	765	Write_rows	1	799	table_id: # flags: STMT_END_F
master-bin.000001	799	Table_map	1	840	table_id: # (test.t1)
master-bin.000001	840	Write_rows	1	874	table_id: # flags: STMT_END_F
master-bin.000001	874	Table_map	1	915	table_id: # (test.t1)
master-bin.000001	915	Write_rows	1	949	table_id: # flags: STMT_END_F
master-bin.000001	949	Table_map	1	990	table_id: # (test.t1)
master-bin.000001	990	Write_rows	1	1024	table_id: # flags: STMT_END_F
master-bin.000001	1024	Table_map	1	1065	table_id: # (test.t1)
master-bin.000001	1065	Write_rows	1	1099	table_id: # flags: STMT_END_F
master-bin.000001	1099	Table_map	1	1140	table_id: # (test.t1)
master-bin.000001	1140	Write_rows	1	1174	table_id: # flags: STMT_END_F
master-bin.000001	1174	Table_map	1	1215	table_id: # (test.t1)
master-bin.000001	1215	Write_rows	1	1249	table_id: # flags: STMT_END_F
master-bin.000001	1249	Table_map	1	1290	table_id: # (test.t1)
master-bin.000001	1290	Write_rows	1	1324	table_id: # flags: STMT_END_F
master-bin.000001	1324	Table_map	1	1365	table_id: # (test.t1)
master-bin.000001	1365	Write_rows	1	1399	table_id: # flags: STMT_END_F
master-bin.000001	1399	Table_map	1	1440	table_id: # (test.t1)
master-bin.000001	1440	Write_rows	1	1474	table_id: # flags: STMT_END_F
master-bin.000001	1474	Table_map	1	1515	table_id: # (test.t1)
master-bin.000001	1515	Write_rows	1	1549	table_id: # flags: STMT_END_F
master-bin.000001	1549	Table_map	1	1590	table_id: # (test.t1)
master-bin.000001	1590	Write_rows	1	1624	table_id: # flags: STMT_END_F
master-bin.000001	1624	Table_map	1	1665	table_id: # (test.t1)
master-bin.000001	1665	Write_rows	1	1699	table_id: # flags: STMT_END_F
master-bin.000001	1699	Table_map	1	1740	table_id: # (test.t1)
master-bin.000001	1740	Write_rows	1	1774	table_id: # flags: STMT_END_F
master-bin.000001	1774	Table_map	1	1815	table_id: # (test.t1)
master-bin.000001	1815	Write_rows	1	1849	table_id: # flags: STMT_END_F
master-bin.000001	1849	Table_map	1	1890	table_id: # (test.t1)
master-bin.000001	1890	Write_rows	1	1924	table_id: # flags: STMT_END_F
master-bin.000001	1924	Table_map	1	1965	table_id: # (test.t1)
master-bin.000001	1965	Write_rows	1	1999	table_id: # flags: STMT_END_F
master-bin.000001	1999	Table_map	1	2040	table_id: # (test.t1)
master-bin.000001	2040	Write_rows	1	2074	table_id: # flags: STMT_END_F
master-bin.000001	2074	Table_map	1	2115	table_id: # (test.t1)
master-bin.000001	2115	Write_rows	1	2149	table_id: # flags: STMT_END_F
master-bin.000001	2149	Table_map	1	2190	table_id: # (test.t1)
master-bin.000001	2190	Write_rows	1	2224	table_id: # flags: STMT_END_F
master-bin.000001	2224	Table_map	1	2265	table_id: # (test.t1)
master-bin.000001	2265	Write_rows	1	2299	table_id: # flags: STMT_END_F
master-bin.000001	2299	Table_map	1	2340	table_id: # (test.t1)
master-bin.000001	2340	Write_rows	1	2374	table_id: # flags: STMT_END_F
master-bin.000001	2374	Table_map	1	2415	table_id: # (test.t1)
master-bin.000001	2415	Write_rows	1	2449	table_id: # flags: STMT_END_F
master-bin.000001	2449	Table_map	1	2490	table_id: # (test.t1)
master-bin.000001	2490	Write_rows	1	2524	table_id: # flags: STMT_END_F
master-bin.000001	2524	Table_map	1	2565	table_id: # (test.t1)
master-bin.000001	2565	Write_rows	1	2599	table_id: # flags: STMT_END_F
master-bin.000001	2599	Table_map	1	2640	table_id: # (test.t1)
master-bin.000001	2640	Write_rows	1	2674	table_id: # flags: STMT_END_F
master-bin.000001	2674	Table_map	1	2715	table_id: # (test.t1)
master-bin.000001	2715	Write_rows	1	2749	table_id: # flags: STMT_END_F
master-bin.000001	2749	Table_map	1	2790	table_id: # (test.t1)
master-bin.000001	2790	Write_rows	1	2824	table_id: # flags: STMT_END_F
master-bin.000001	2824	Table_map	1	2865	table_id: # (test.t1)
master-bin.000001	2865	Write_rows	1	2899	table_id: # flags: STMT_END_F
master-bin.000001	2899	Table_map	1	2940	table_id: # (test.t1)
master-bin.000001	2940	Write_rows	1	2974	table_id: # flags: STMT_END_F
master-bin.000001	2974	Table_map	1	3015	table_id: # (test.t1)
master-bin.000001	3015	Write_rows	1	3049	table_id: # flags: STMT_END_F
master-bin.000001	3049	Table_map	1	3090	table_id: # (test.t1)
master-bin.000001	3090	Write_rows	1	3124	table_id: # flags: STMT_END_F
master-bin.000001	3124	Table_map	1	3165	table_id: # (test.t1)
master-bin.000001	3165	Write_rows	1	3199	table_id: # flags: STMT_END_F
master-bin.000001	3199	Table_map	1	3240	table_id: # (test.t1)
master-bin.000001	3240	Write_rows	1	3274	table_id: # flags: STMT_END_F
master-bin.000001	3274	Table_map	1	3315	table_id: # (test.t1)
master-bin.000001	3315	Write_rows	1	3349	table_id: # flags: STMT_END_F
master-bin.000001	3349	Table_map	1	3390	table_id: # (test.t1)
master-bin.000001	3390	Write_rows	1	3424	table_id: # flags: STMT_END_F
master-bin.000001	3424	Table_map	1	3465	table_id: # (test.t1)
master-bin.000001	3465	Write_rows	1	3499	table_id: # flags: STMT_END_F
master-bin.000001	3499	Table_map	1	3540	table_id: # (test.t1)
master-bin.000001	3540	Write_rows	1	3574	table_id: # flags: STMT_END_F
master-bin.000001	3574	Table_map	1	3615	table_id: # (test.t1)
master-bin.000001	3615	Write_rows	1	3649	table_id: # flags: STMT_END_F
master-bin.000001	3649	Table_map	1	3690	table_id: # (test.t1)
master-bin.000001	3690	Write_rows	1	3724	table_id: # flags: STMT_END_F
master-bin.000001	3724	Table_map	1	3765	table_id: # (test.t1)
master-bin.000001	3765	Write_rows	1	3799	table_id: # flags: STMT_END_F
master-bin.000001	3799	Table_map	1	3840	table_id: # (test.t1)
master-bin.000001	3840	Write_rows	1	3874	table_id: # flags: STMT_END_F
master-bin.000001	3874	Table_map	1	3915	table_id: # (test.t1)
master-bin.000001	3915	Write_rows	1	3949	table_id: # flags: STMT_END_F
master-bin.000001	3949	Table_map	1	3990	table_id: # (test.t1)
master-bin.000001	3990	Write_rows	1	4024	table_id: # flags: STMT_END_F
master-bin.000001	4024	Table_map	1	4065	table_id: # (test.t1)
master-bin.000001	4065	Write_rows	1	4099	table_id: # flags: STMT_END_F
master-bin.000001	4099	Table_map	1	4140	table_id: # (test.t1)
master-bin.000001	4140	Write_rows	1	4174	table_id: # flags: STMT_END_F
master-bin.000001	4174	Table_map	1	4215	table_id: # (test.t1)
master-bin.000001	4215	Write_rows	1	4249	table_id: # flags: STMT_END_F
master-bin.000001	4249	Table_map	1	4290	table_id: # (test.t1)
master-bin.000001	4290	Write_rows	1	4324	table_id: # flags: STMT_END_F
master-bin.000001	4324	Table_map	1	4365	table_id: # (test.t1)
master-bin.000001	4365	Write_rows	1	4399	table_id: # flags: STMT_END_F
master-bin.000001	4399	Table_map	1	4440	table_id: # (test.t1)
master-bin.000001	4440	Write_rows	1	4474	table_id: # flags: STMT_END_F
master-bin.000001	4474	Table_map	1	4515	table_id: # (test.t1)
master-bin.000001	4515	Write_rows	1	4549	table_id: # flags: STMT_END_F
master-bin.000001	4549	Table_map	1	4590	table_id: # (test.t1)
master-bin.000001	4590	Write_rows	1	4624	table_id: # flags: STMT_END_F
master-bin.000001	4624	Table_map	1	4665	table_id: # (test.t1)
master-bin.000001	4665	Write_rows	1	4699	table_id: # flags: STMT_END_F
master-bin.000001	4699	Table_map	1	4740	table_id: # (test.t1)
master-bin.000001	4740	Write_rows	1	4774	table_id: # flags: STMT_END_F
master-bin.000001	4774	Table_map	1	4815	table_id: # (test.t1)
master-bin.000001	4815	Write_rows	1	4849	table_id: # flags: STMT_END_F
master-bin.000001	4849	Table_map	1	4890	table_id: # (test.t1)
master-bin.000001	4890	Write_rows	1	4924	table_id: # flags: STMT_END_F
master-bin.000001	4924	Table_map	1	4965	table_id: # (test.t1)
master-bin.000001	4965	Write_rows	1	4999	table_id: # flags: STMT_END_F
master-bin.000001	4999	Table_map	1	5040	table_id: # (test.t1)
master-bin.000001	5040	Write_rows	1	5074	table_id: # flags: STMT_END_F
master-bin.000001	5074	Table_map	1	5115	table_id: # (test.t1)
master-bin.000001	5115	Write_rows	1	5149	table_id: # flags: STMT_END_F
master-bin.000001	5149	Table_map	1	5190	table_id: # (test.t1)
master-bin.000001	5190	Write_rows	1	5224	table_id: # flags: STMT_END_F
master-bin.000001	5224	Table_map	1	5265	table_id: # (test.t1)
master-bin.000001	5265	Write_rows	1	5299	table_id: # flags: STMT_END_F
master-bin.000001	5299	Table_map	1	5340	table_id: # (test.t1)
master-bin.000001	5340	Write_rows	1	5374	table_id: # flags: STMT_END_F
master-bin.000001	5374	Table_map	1	5415	table_id: # (test.t1)
master-bin.000001	5415	Write_rows	1	5449	table_id: # flags: STMT_END_F
master-bin.000001	5449	Table_map	1	5490	table_id: # (test.t1)
master-bin.000001	5490	Write_rows	1	5524	table_id: # flags: STMT_END_F
master-bin.000001	5524	Table_map	1	5565	table_id: # (test.t1)
master-bin.000001	5565	Write_rows	1	5599	table_id: # flags: STMT_END_F
master-bin.000001	5599	Table_map	1	5640	table_id: # (test.t1)
master-bin.000001	5640	Write_rows	1	5674	table_id: # flags: STMT_END_F
master-bin.000001	5674	Table_map	1	5715	table_id: # (test.t1)
master-bin.000001	5715	Write_rows	1	5749	table_id: # flags: STMT_END_F
master-bin.000001	5749	Table_map	1	5790	table_id: # (test.t1)
master-bin.000001	5790	Write_rows	1	5824	table_id: # flags: STMT_END_F
master-bin.000001	5824	Table_map	1	5865	table_id: # (test.t1)
master-bin.000001	5865	Write_rows	1	5899	table_id: # flags: STMT_END_F
master-bin.000001	5899	Table_map	1	5940	table_id: # (test.t1)
master-bin.000001	5940	Write_rows	1	5974	table_id: # flags: STMT_END_F
master-bin.000001	5974	Table_map	1	6015	table_id: # (test.t1)
master-bin.000001	6015	Write_rows	1	6049	table_id: # flags: STMT_END_F
master-bin.000001	6049	Table_map	1	6090	table_id: # (test.t1)
master-bin.000001	6090	Write_rows	1	6124	table_id: # flags: STMT_END_F
master-bin.000001	6124	Table_map	1	6165	table_id: # (test.t1)
master-bin.000001	6165	Write_rows	1	6199	table_id: # flags: STMT_END_F
master-bin.000001	6199	Table_map	1	6240	table_id: # (test.t1)
master-bin.000001	6240	Write_rows	1	6274	table_id: # flags: STMT_END_F
master-bin.000001	6274	Table_map	1	6315	table_id: # (test.t1)
master-bin.000001	6315	Write_rows	1	6349	table_id: # flags: STMT_END_F
master-bin.000001	6349	Table_map	1	6390	table_id: # (test.t1)
master-bin.000001	6390	Write_rows	1	6424	table_id: # flags: STMT_END_F
master-bin.000001	6424	Table_map	1	6465	table_id: # (test.t1)
master-bin.000001	6465	Write_rows	1	6499	table_id: # flags: STMT_END_F
master-bin.000001	6499	Table_map	1	6540	table_id: # (test.t1)
master-bin.000001	6540	Write_rows	1	6574	table_id: # flags: STMT_END_F
master-bin.000001	6574	Table_map	1	6615	table_id: # (test.t1)
master-bin.000001	6615	Write_rows	1	6649	table_id: # flags: STMT_END_F
master-bin.000001	6649	Table_map	1	6690	table_id: # (test.t1)
master-bin.000001	6690	Write_rows	1	6724	table_id: # flags: STMT_END_F
master-bin.000001	6724	Table_map	1	6765	table_id: # (test.t1)
master-bin.000001	6765	Write_rows	1	6799	table_id: # flags: STMT_END_F
master-bin.000001	6799	Table_map	1	6840	table_id: # (test.t1)
master-bin.000001	6840	Write_rows	1	6874	table_id: # flags: STMT_END_F
master-bin.000001	6874	Table_map	1	6915	table_id: # (test.t1)
master-bin.000001	6915	Write_rows	1	6949	table_id: # flags: STMT_END_F
master-bin.000001	6949	Table_map	1	6990	table_id: # (test.t1)
master-bin.000001	6990	Write_rows	1	7024	table_id: # flags: STMT_END_F
master-bin.000001	7024	Table_map	1	7065	table_id: # (test.t1)
master-bin.000001	7065	Write_rows	1	7099	table_id: # flags: STMT_END_F
master-bin.000001	7099	Table_map	1	7140	table_id: # (test.t1)
master-bin.000001	7140	Write_rows	1	7174	table_id: # flags: STMT_END_F
master-bin.000001	7174	Table_map	1	7215	table_id: # (test.t1)
master-bin.000001	7215	Write_rows	1	7249	table_id: # flags: STMT_END_F
master-bin.000001	7249	Table_map	1	7290	table_id: # (test.t1)
master-bin.000001	7290	Write_rows	1	7324	table_id: # flags: STMT_END_F
master-bin.000001	7324	Table_map	1	7365	table_id: # (test.t1)
master-bin.000001	7365	Write_rows	1	7399	table_id: # flags: STMT_END_F
master-bin.000001	7399	Table_map	1	7440	table_id: # (test.t1)
master-bin.000001	7440	Write_rows	1	7474	table_id: # flags: STMT_END_F
master-bin.000001	7474	Table_map	1	7515	table_id: # (test.t1)
master-bin.000001	7515	Write_rows	1	7549	table_id: # flags: STMT_END_F
master-bin.000001	7549	Table_map	1	7590	table_id: # (test.t1)
master-bin.000001	7590	Write_rows	1	7624	table_id: # flags: STMT_END_F
master-bin.000001	7624	Table_map	1	7665	table_id: # (test.t1)
master-bin.000001	7665	Write_rows	1	7699	table_id: # flags: STMT_END_F
master-bin.000001	7699	Table_map	1	7740	table_id: # (test.t1)
master-bin.000001	7740	Write_rows	1	7774	table_id: # flags: STMT_END_F
master-bin.000001	7774	Table_map	1	7815	table_id: # (test.t1)
master-bin.000001	7815	Write_rows	1	7849	table_id: # flags: STMT_END_F
master-bin.000001	7849	Table_map	1	7890	table_id: # (test.t1)
master-bin.000001	7890	Write_rows	1	7924	table_id: # flags: STMT_END_F
master-bin.000001	7924	Table_map	1	7965	table_id: # (test.t1)
master-bin.000001	7965	Write_rows	1	7999	table_id: # flags: STMT_END_F
master-bin.000001	7999	Table_map	1	8040	table_id: # (test.t1)
master-bin.000001	8040	Write_rows	1	8074	table_id: # flags: STMT_END_F
master-bin.000001	8074	Table_map	1	8115	table_id: # (test.t1)
master-bin.000001	8115	Write_rows	1	8149	table_id: # flags: STMT_END_F
master-bin.000001	8149	Table_map	1	8190	table_id: # (test.t1)
master-bin.000001	8190	Write_rows	1	8224	table_id: # flags: STMT_END_F
master-bin.000001	8224	Table_map	1	8265	table_id: # (test.t1)
master-bin.000001	8265	Write_rows	1	8299	table_id: # flags: STMT_END_F
master-bin.000001	8299	Table_map	1	8340	table_id: # (test.t1)
master-bin.000001	8340	Write_rows	1	8374	table_id: # flags: STMT_END_F
master-bin.000001	8374	Table_map	1	8415	table_id: # (test.t1)
master-bin.000001	8415	Write_rows	1	8449	table_id: # flags: STMT_END_F
master-bin.000001	8449	Table_map	1	8490	table_id: # (test.t1)
master-bin.000001	8490	Write_rows	1	8524	table_id: # flags: STMT_END_F
master-bin.000001	8524	Table_map	1	8565	table_id: # (test.t1)
master-bin.000001	8565	Write_rows	1	8599	table_id: # flags: STMT_END_F
master-bin.000001	8599	Table_map	1	8640	table_id: # (test.t1)
master-bin.000001	8640	Write_rows	1	8674	table_id: # flags: STMT_END_F
master-bin.000001	8674	Table_map	1	8715	table_id: # (test.t1)
master-bin.000001	8715	Write_rows	1	8749	table_id: # flags: STMT_END_F
master-bin.000001	8749	Table_map	1	8790	table_id: # (test.t1)
master-bin.000001	8790	Write_rows	1	8824	table_id: # flags: STMT_END_F
master-bin.000001	8824	Table_map	1	8865	table_id: # (test.t1)
master-bin.000001	8865	Write_rows	1	8899	table_id: # flags: STMT_END_F
master-bin.000001	8899	Table_map	1	8940	table_id: # (test.t1)
master-bin.000001	8940	Write_rows	1	8974	table_id: # flags: STMT_END_F
master-bin.000001	8974	Table_map	1	9015	table_id: # (test.t1)
master-bin.000001	9015	Write_rows	1	9049	table_id: # flags: STMT_END_F
master-bin.000001	9049	Table_map	1	9090	table_id: # (test.t1)
master-bin.000001	9090	Write_rows	1	9124	table_id: # flags: STMT_END_F
master-bin.000001	9124	Table_map	1	9165	table_id: # (test.t1)
master-bin.000001	9165	Write_rows	1	9199	table_id: # flags: STMT_END_F
master-bin.000001	9199	Table_map	1	9240	table_id: # (test.t1)
master-bin.000001	9240	Write_rows	1	9274	table_id: # flags: STMT_END_F
master-bin.000001	9274	Table_map	1	9315	table_id: # (test.t1)
master-bin.000001	9315	Write_rows	1	9349	table_id: # flags: STMT_END_F
master-bin.000001	9349	Table_map	1	9390	table_id: # (test.t1)
master-bin.000001	9390	Write_rows	1	9424	table_id: # flags: STMT_END_F
master-bin.000001	9424	Table_map	1	9465	table_id: # (test.t1)
master-bin.000001	9465	Write_rows	1	9499	table_id: # flags: STMT_END_F
master-bin.000001	9499	Table_map	1	9540	table_id: # (test.t1)
master-bin.000001	9540	Write_rows	1	9574	table_id: # flags: STMT_END_F
master-bin.000001	9574	Table_map	1	9615	table_id: # (test.t1)
master-bin.000001	9615	Write_rows	1	9649	table_id: # flags: STMT_END_F
master-bin.000001	9649	Table_map	1	9690	table_id: # (test.t1)
master-bin.000001	9690	Write_rows	1	9724	table_id: # flags: STMT_END_F
master-bin.000001	9724	Table_map	1	9765	table_id: # (test.t1)
master-bin.000001	9765	Write_rows	1	9799	table_id: # flags: STMT_END_F
master-bin.000001	9799	Table_map	1	9840	table_id: # (test.t1)
master-bin.000001	9840	Write_rows	1	9874	table_id: # flags: STMT_END_F
master-bin.000001	9874	Table_map	1	9915	table_id: # (test.t1)
master-bin.000001	9915	Write_rows	1	9949	table_id: # flags: STMT_END_F
master-bin.000001	9949	Table_map	1	9990	table_id: # (test.t1)
master-bin.000001	9990	Write_rows	1	10024	table_id: # flags: STMT_END_F
master-bin.000001	10024	Table_map	1	10065	table_id: # (test.t1)
master-bin.000001	10065	Write_rows	1	10099	table_id: # flags: STMT_END_F
master-bin.000001	10099	Table_map	1	10140	table_id: # (test.t1)
master-bin.000001	10140	Write_rows	1	10174	table_id: # flags: STMT_END_F
master-bin.000001	10174	Table_map	1	10215	table_id: # (test.t1)
master-bin.000001	10215	Write_rows	1	10249	table_id: # flags: STMT_END_F
master-bin.000001	10249	Table_map	1	10290	table_id: # (test.t1)
master-bin.000001	10290	Write_rows	1	10324	table_id: # flags: STMT_END_F
master-bin.000001	10324	Table_map	1	10365	table_id: # (test.t1)
master-bin.000001	10365	Write_rows	1	10399	table_id: # flags: STMT_END_F
master-bin.000001	10399	Table_map	1	10440	table_id: # (test.t1)
master-bin.000001	10440	Write_rows	1	10474	table_id: # flags: STMT_END_F
master-bin.000001	10474	Table_map	1	10515	table_id: # (test.t1)
master-bin.000001	10515	Write_rows	1	10549	table_id: # flags: STMT_END_F
master-bin.000001	10549	Table_map	1	10590	table_id: # (test.t1)
master-bin.000001	10590	Write_rows	1	10624	table_id: # flags: STMT_END_F
master-bin.000001	10624	Table_map	1	10665	table_id: # (test.t1)
master-bin.000001	10665	Write_rows	1	10699	table_id: # flags: STMT_END_F
master-bin.000001	10699	Table_map	1	10740	table_id: # (test.t1)
master-bin.000001	10740	Write_rows	1	10774	table_id: # flags: STMT_END_F
master-bin.000001	10774	Table_map	1	10815	table_id: # (test.t1)
master-bin.000001	10815	Write_rows	1	10849	table_id: # flags: STMT_END_F
master-bin.000001	10849	Table_map	1	10890	table_id: # (test.t1)
master-bin.000001	10890	Write_rows	1	10924	table_id: # flags: STMT_END_F
master-bin.000001	10924	Table_map	1	10965	table_id: # (test.t1)
master-bin.000001	10965	Write_rows	1	10999	table_id: # flags: STMT_END_F
master-bin.000001	10999	Table_map	1	11040	table_id: # (test.t1)
master-bin.000001	11040	Write_rows	1	11074	table_id: # flags: STMT_END_F
master-bin.000001	11074	Table_map	1	11115	table_id: # (test.t1)
master-bin.000001	11115	Write_rows	1	11149	table_id: # flags: STMT_END_F
master-bin.000001	11149	Table_map	1	11190	table_id: # (test.t1)
master-bin.000001	11190	Write_rows	1	11224	table_id: # flags: STMT_END_F
master-bin.000001	11224	Table_map	1	11265	table_id: # (test.t1)
master-bin.000001	11265	Write_rows	1	11299	table_id: # flags: STMT_END_F
master-bin.000001	11299	Table_map	1	11340	table_id: # (test.t1)
master-bin.000001	11340	Write_rows	1	11374	table_id: # flags: STMT_END_F
master-bin.000001	11374	Table_map	1	11415	table_id: # (test.t1)
master-bin.000001	11415	Write_rows	1	11449	table_id: # flags: STMT_END_F
master-bin.000001	11449	Table_map	1	11490	table_id: # (test.t1)
master-bin.000001	11490	Write_rows	1	11524	table_id: # flags: STMT_END_F
master-bin.000001	11524	Table_map	1	11565	table_id: # (test.t1)
master-bin.000001	11565	Write_rows	1	11599	table_id: # flags: STMT_END_F
master-bin.000001	11599	Table_map	1	11640	table_id: # (test.t1)
master-bin.000001	11640	Write_rows	1	11674	table_id: # flags: STMT_END_F
master-bin.000001	11674	Table_map	1	11715	table_id: # (test.t1)
master-bin.000001	11715	Write_rows	1	11749	table_id: # flags: STMT_END_F
master-bin.000001	11749	Table_map	1	11790	table_id: # (test.t1)
master-bin.000001	11790	Write_rows	1	11824	table_id: # flags: STMT_END_F
master-bin.000001	11824	Table_map	1	11865	table_id: # (test.t1)
master-bin.000001	11865	Write_rows	1	11899	table_id: # flags: STMT_END_F
master-bin.000001	11899	Table_map	1	11940	table_id: # (test.t1)
master-bin.000001	11940	Write_rows	1	11974	table_id: # flags: STMT_END_F
master-bin.000001	11974	Table_map	1	12015	table_id: # (test.t1)
master-bin.000001	12015	Write_rows	1	12049	table_id: # flags: STMT_END_F
master-bin.000001	12049	Table_map	1	12090	table_id: # (test.t1)
master-bin.000001	12090	Write_rows	1	12124	table_id: # flags: STMT_END_F
master-bin.000001	12124	Table_map	1	12165	table_id: # (test.t1)
master-bin.000001	12165	Write_rows	1	12199	table_id: # flags: STMT_END_F
master-bin.000001	12199	Table_map	1	12240	table_id: # (test.t1)
master-bin.000001	12240	Write_rows	1	12274	table_id: # flags: STMT_END_F
master-bin.000001	12274	Table_map	1	12315	table_id: # (test.t1)
master-bin.000001	12315	Write_rows	1	12349	table_id: # flags: STMT_END_F
master-bin.000001	12349	Table_map	1	12390	table_id: # (test.t1)
master-bin.000001	12390	Write_rows	1	12424	table_id: # flags: STMT_END_F
master-bin.000001	12424	Table_map	1	12465	table_id: # (test.t1)
master-bin.000001	12465	Write_rows	1	12499	table_id: # flags: STMT_END_F
master-bin.000001	12499	Table_map	1	12540	table_id: # (test.t1)
master-bin.000001	12540	Write_rows	1	12574	table_id: # flags: STMT_END_F
master-bin.000001	12574	Table_map	1	12615	table_id: # (test.t1)
master-bin.000001	12615	Write_rows	1	12649	table_id: # flags: STMT_END_F
master-bin.000001	12649	Table_map	1	12690	table_id: # (test.t1)
master-bin.000001	12690	Write_rows	1	12724	table_id: # flags: STMT_END_F
master-bin.000001	12724	Table_map	1	12765	table_id: # (test.t1)
master-bin.000001	12765	Write_rows	1	12799	table_id: # flags: STMT_END_F
master-bin.000001	12799	Table_map	1	12840	table_id: # (test.t1)
master-bin.000001	12840	Write_rows	1	12874	table_id: # flags: STMT_END_F
master-bin.000001	12874	Table_map	1	12915	table_id: # (test.t1)
master-bin.000001	12915	Write_rows	1	12949	table_id: # flags: STMT_END_F
master-bin.000001	12949	Table_map	1	12990	table_id: # (test.t1)
master-bin.000001	12990	Write_rows	1	13024	table_id: # flags: STMT_END_F
master-bin.000001	13024	Table_map	1	13065	table_id: # (test.t1)
master-bin.000001	13065	Write_rows	1	13099	table_id: # flags: STMT_END_F
master-bin.000001	13099	Table_map	1	13140	table_id: # (test.t1)
master-bin.000001	13140	Write_rows	1	13174	table_id: # flags: STMT_END_F
master-bin.000001	13174	Table_map	1	13215	table_id: # (test.t1)
master-bin.000001	13215	Write_rows	1	13249	table_id: # flags: STMT_END_F
master-bin.000001	13249	Table_map	1	13290	table_id: # (test.t1)
master-bin.000001	13290	Write_rows	1	13324	table_id: # flags: STMT_END_F
master-bin.000001	13324	Table_map	1	13365	table_id: # (test.t1)
master-bin.000001	13365	Write_rows	1	13399	table_id: # flags: STMT_END_F
master-bin.000001	13399	Table_map	1	13440	table_id: # (test.t1)
master-bin.000001	13440	Write_rows	1	13474	table_id: # flags: STMT_END_F
master-bin.000001	13474	Table_map	1	13515	table_id: # (test.t1)
master-bin.000001	13515	Write_rows	1	13549	table_id: # flags: STMT_END_F
master-bin.000001	13549	Table_map	1	13590	table_id: # (test.t1)
master-bin.000001	13590	Write_rows	1	13624	table_id: # flags: STMT_END_F
master-bin.000001	13624	Table_map	1	13665	table_id: # (test.t1)
master-bin.000001	13665	Write_rows	1	13699	table_id: # flags: STMT_END_F
master-bin.000001	13699	Table_map	1	13740	table_id: # (test.t1)
master-bin.000001	13740	Write_rows	1	13774	table_id: # flags: STMT_END_F
master-bin.000001	13774	Table_map	1	13815	table_id: # (test.t1)
master-bin.000001	13815	Write_rows	1	13849	table_id: # flags: STMT_END_F
master-bin.000001	13849	Table_map	1	13890	table_id: # (test.t1)
master-bin.000001	13890	Write_rows	1	13924	table_id: # flags: STMT_END_F
master-bin.000001	13924	Table_map	1	13965	table_id: # (test.t1)
master-bin.000001	13965	Write_rows	1	13999	table_id: # flags: STMT_END_F
master-bin.000001	13999	Table_map	1	14040	table_id: # (test.t1)
master-bin.000001	14040	Write_rows	1	14074	table_id: # flags: STMT_END_F
master-bin.000001	14074	Table_map	1	14115	table_id: # (test.t1)
master-bin.000001	14115	Write_rows	1	14149	table_id: # flags: STMT_END_F
master-bin.000001	14149	Table_map	1	14190	table_id: # (test.t1)
master-bin.000001	14190	Write_rows	1	14224	table_id: # flags: STMT_END_F
master-bin.000001	14224	Table_map	1	14265	table_id: # (test.t1)
master-bin.000001	14265	Write_rows	1	14299	table_id: # flags: STMT_END_F
master-bin.000001	14299	Table_map	1	14340	table_id: # (test.t1)
master-bin.000001	14340	Write_rows	1	14374	table_id: # flags: STMT_END_F
master-bin.000001	14374	Table_map	1	14415	table_id: # (test.t1)
master-bin.000001	14415	Write_rows	1	14449	table_id: # flags: STMT_END_F
master-bin.000001	14449	Table_map	1	14490	table_id: # (test.t1)
master-bin.000001	14490	Write_rows	1	14524	table_id: # flags: STMT_END_F
master-bin.000001	14524	Table_map	1	14565	table_id: # (test.t1)
master-bin.000001	14565	Write_rows	1	14599	table_id: # flags: STMT_END_F
master-bin.000001	14599	Table_map	1	14640	table_id: # (test.t1)
master-bin.000001	14640	Write_rows	1	14674	table_id: # flags: STMT_END_F
master-bin.000001	14674	Table_map	1	14715	table_id: # (test.t1)
master-bin.000001	14715	Write_rows	1	14749	table_id: # flags: STMT_END_F
master-bin.000001	14749	Table_map	1	14790	table_id: # (test.t1)
master-bin.000001	14790	Write_rows	1	14824	table_id: # flags: STMT_END_F
master-bin.000001	14824	Table_map	1	14865	table_id: # (test.t1)
master-bin.000001	14865	Write_rows	1	14899	table_id: # flags: STMT_END_F
master-bin.000001	14899	Table_map	1	14940	table_id: # (test.t1)
master-bin.000001	14940	Write_rows	1	14974	table_id: # flags: STMT_END_F
master-bin.000001	14974	Table_map	1	15015	table_id: # (test.t1)
master-bin.000001	15015	Write_rows	1	15049	table_id: # flags: STMT_END_F
master-bin.000001	15049	Table_map	1	15090	table_id: # (test.t1)
master-bin.000001	15090	Write_rows	1	15124	table_id: # flags: STMT_END_F
master-bin.000001	15124	Table_map	1	15165	table_id: # (test.t1)
master-bin.000001	15165	Write_rows	1	15199	table_id: # flags: STMT_END_F
master-bin.000001	15199	Table_map	1	15240	table_id: # (test.t1)
master-bin.000001	15240	Write_rows	1	15274	table_id: # flags: STMT_END_F
master-bin.000001	15274	Table_map	1	15315	table_id: # (test.t1)
master-bin.000001	15315	Write_rows	1	15349	table_id: # flags: STMT_END_F
master-bin.000001	15349	Table_map	1	15390	table_id: # (test.t1)
master-bin.000001	15390	Write_rows	1	15424	table_id: # flags: STMT_END_F
master-bin.000001	15424	Table_map	1	15465	table_id: # (test.t1)
master-bin.000001	15465	Write_rows	1	15499	table_id: # flags: STMT_END_F
master-bin.000001	15499	Table_map	1	15540	table_id: # (test.t1)
master-bin.000001	15540	Write_rows	1	15574	table_id: # flags: STMT_END_F
master-bin.000001	15574	Table_map	1	15615	table_id: # (test.t1)
master-bin.000001	15615	Write_rows	1	15649	table_id: # flags: STMT_END_F
master-bin.000001	15649	Table_map	1	15690	table_id: # (test.t1)
master-bin.000001	15690	Write_rows	1	15724	table_id: # flags: STMT_END_F
master-bin.000001	15724	Table_map	1	15765	table_id: # (test.t1)
master-bin.000001	15765	Write_rows	1	15799	table_id: # flags: STMT_END_F
master-bin.000001	15799	Table_map	1	15840	table_id: # (test.t1)
master-bin.000001	15840	Write_rows	1	15874	table_id: # flags: STMT_END_F
master-bin.000001	15874	Table_map	1	15915	table_id: # (test.t1)
master-bin.000001	15915	Write_rows	1	15949	table_id: # flags: STMT_END_F
master-bin.000001	15949	Table_map	1	15990	table_id: # (test.t1)
master-bin.000001	15990	Write_rows	1	16024	table_id: # flags: STMT_END_F
master-bin.000001	16024	Table_map	1	16065	table_id: # (test.t1)
master-bin.000001	16065	Write_rows	1	16099	table_id: # flags: STMT_END_F
master-bin.000001	16099	Table_map	1	16140	table_id: # (test.t1)
master-bin.000001	16140	Write_rows	1	16174	table_id: # flags: STMT_END_F
master-bin.000001	16174	Table_map	1	16215	table_id: # (test.t1)
master-bin.000001	16215	Write_rows	1	16249	table_id: # flags: STMT_END_F
master-bin.000001	16249	Table_map	1	16290	table_id: # (test.t1)
master-bin.000001	16290	Write_rows	1	16324	table_id: # flags: STMT_END_F
master-bin.000001	16324	Table_map	1	16365	table_id: # (test.t1)
master-bin.000001	16365	Write_rows	1	16399	table_id: # flags: STMT_END_F
master-bin.000001	16399	Table_map	1	16440	table_id: # (test.t1)
master-bin.000001	16440	Write_rows	1	16474	table_id: # flags: STMT_END_F
master-bin.000001	16474	Table_map	1	16515	table_id: # (test.t1)
master-bin.000001	16515	Write_rows	1	16549	table_id: # flags: STMT_END_F
master-bin.000001	16549	Table_map	1	16590	table_id: # (test.t1)
master-bin.000001	16590	Write_rows	1	16624	table_id: # flags: STMT_END_F
master-bin.000001	16624	Table_map	1	16665	table_id: # (test.t1)
master-bin.000001	16665	Write_rows	1	16699	table_id: # flags: STMT_END_F
master-bin.000001	16699	Table_map	1	16740	table_id: # (test.t1)
master-bin.000001	16740	Write_rows	1	16774	table_id: # flags: STMT_END_F
master-bin.000001	16774	Table_map	1	16815	table_id: # (test.t1)
master-bin.000001	16815	Write_rows	1	16849	table_id: # flags: STMT_END_F
master-bin.000001	16849	Table_map	1	16890	table_id: # (test.t1)
master-bin.000001	16890	Write_rows	1	16924	table_id: # flags: STMT_END_F
master-bin.000001	16924	Table_map	1	16965	table_id: # (test.t1)
master-bin.000001	16965	Write_rows	1	16999	table_id: # flags: STMT_END_F
master-bin.000001	16999	Table_map	1	17040	table_id: # (test.t1)
master-bin.000001	17040	Write_rows	1	17074	table_id: # flags: STMT_END_F
master-bin.000001	17074	Table_map	1	17115	table_id: # (test.t1)
master-bin.000001	17115	Write_rows	1	17149	table_id: # flags: STMT_END_F
master-bin.000001	17149	Table_map	1	17190	table_id: # (test.t1)
master-bin.000001	17190	Write_rows	1	17224	table_id: # flags: STMT_END_F
master-bin.000001	17224	Table_map	1	17265	table_id: # (test.t1)
master-bin.000001	17265	Write_rows	1	17299	table_id: # flags: STMT_END_F
master-bin.000001	17299	Table_map	1	17340	table_id: # (test.t1)
master-bin.000001	17340	Write_rows	1	17374	table_id: # flags: STMT_END_F
master-bin.000001	17374	Table_map	1	17415	table_id: # (test.t1)
master-bin.000001	17415	Write_rows	1	17449	table_id: # flags: STMT_END_F
master-bin.000001	17449	Table_map	1	17490	table_id: # (test.t1)
master-bin.000001	17490	Write_rows	1	17524	table_id: # flags: STMT_END_F
master-bin.000001	17524	Table_map	1	17565	table_id: # (test.t1)
master-bin.000001	17565	Write_rows	1	17599	table_id: # flags: STMT_END_F
master-bin.000001	17599	Table_map	1	17640	table_id: # (test.t1)
master-bin.000001	17640	Write_rows	1	17674	table_id: # flags: STMT_END_F
master-bin.000001	17674	Table_map	1	17715	table_id: # (test.t1)
master-bin.000001	17715	Write_rows	1	17749	table_id: # flags: STMT_END_F
master-bin.000001	17749	Table_map	1	17790	table_id: # (test.t1)
master-bin.000001	17790	Write_rows	1	17824	table_id: # flags: STMT_END_F
master-bin.000001	17824	Table_map	1	17865	table_id: # (test.t1)
master-bin.000001	17865	Write_rows	1	17899	table_id: # flags: STMT_END_F
master-bin.000001	17899	Table_map	1	17940	table_id: # (test.t1)
master-bin.000001	17940	Write_rows	1	17974	table_id: # flags: STMT_END_F
master-bin.000001	17974	Table_map	1	18015	table_id: # (test.t1)
master-bin.000001	18015	Write_rows	1	18049	table_id: # flags: STMT_END_F
master-bin.000001	18049	Table_map	1	18090	table_id: # (test.t1)
master-bin.000001	18090	Write_rows	1	18124	table_id: # flags: STMT_END_F
master-bin.000001	18124	Table_map	1	18165	table_id: # (test.t1)
master-bin.000001	18165	Write_rows	1	18199	table_id: # flags: STMT_END_F
master-bin.000001	18199	Table_map	1	18240	table_id: # (test.t1)
master-bin.000001	18240	Write_rows	1	18274	table_id: # flags: STMT_END_F
master-bin.000001	18274	Table_map	1	18315	table_id: # (test.t1)
master-bin.000001	18315	Write_rows	1	18349	table_id: # flags: STMT_END_F
master-bin.000001	18349	Table_map	1	18390	table_id: # (test.t1)
master-bin.000001	18390	Write_rows	1	18424	table_id: # flags: STMT_END_F
master-bin.000001	18424	Table_map	1	18465	table_id: # (test.t1)
master-bin.000001	18465	Write_rows	1	18499	table_id: # flags: STMT_END_F
master-bin.000001	18499	Table_map	1	18540	table_id: # (test.t1)
master-bin.000001	18540	Write_rows	1	18574	table_id: # flags: STMT_END_F
master-bin.000001	18574	Table_map	1	18615	table_id: # (test.t1)
master-bin.000001	18615	Write_rows	1	18649	table_id: # flags: STMT_END_F
master-bin.000001	18649	Table_map	1	18690	table_id: # (test.t1)
master-bin.000001	18690	Write_rows	1	18724	table_id: # flags: STMT_END_F
master-bin.000001	18724	Table_map	1	18765	table_id: # (test.t1)
master-bin.000001	18765	Write_rows	1	18799	table_id: # flags: STMT_END_F
master-bin.000001	18799	Table_map	1	18840	table_id: # (test.t1)
master-bin.000001	18840	Write_rows	1	18874	table_id: # flags: STMT_END_F
master-bin.000001	18874	Table_map	1	18915	table_id: # (test.t1)
master-bin.000001	18915	Write_rows	1	18949	table_id: # flags: STMT_END_F
master-bin.000001	18949	Table_map	1	18990	table_id: # (test.t1)
master-bin.000001	18990	Write_rows	1	19024	table_id: # flags: STMT_END_F
master-bin.000001	19024	Table_map	1	19065	table_id: # (test.t1)
master-bin.000001	19065	Write_rows	1	19099	table_id: # flags: STMT_END_F
master-bin.000001	19099	Table_map	1	19140	table_id: # (test.t1)
master-bin.000001	19140	Write_rows	1	19174	table_id: # flags: STMT_END_F
master-bin.000001	19174	Table_map	1	19215	table_id: # (test.t1)
master-bin.000001	19215	Write_rows	1	19249	table_id: # flags: STMT_END_F
master-bin.000001	19249	Table_map	1	19290	table_id: # (test.t1)
master-bin.000001	19290	Write_rows	1	19324	table_id: # flags: STMT_END_F
master-bin.000001	19324	Table_map	1	19365	table_id: # (test.t1)
master-bin.000001	19365	Write_rows	1	19399	table_id: # flags: STMT_END_F
master-bin.000001	19399	Table_map	1	19440	table_id: # (test.t1)
master-bin.000001	19440	Write_rows	1	19474	table_id: # flags: STMT_END_F
master-bin.000001	19474	Table_map	1	19515	table_id: # (test.t1)
master-bin.000001	19515	Write_rows	1	19549	table_id: # flags: STMT_END_F
master-bin.000001	19549	Table_map	1	19590	table_id: # (test.t1)
master-bin.000001	19590	Write_rows	1	19624	table_id: # flags: STMT_END_F
master-bin.000001	19624	Table_map	1	19665	table_id: # (test.t1)
master-bin.000001	19665	Write_rows	1	19699	table_id: # flags: STMT_END_F
master-bin.000001	19699	Table_map	1	19740	table_id: # (test.t1)
master-bin.000001	19740	Write_rows	1	19774	table_id: # flags: STMT_END_F
master-bin.000001	19774	Table_map	1	19815	table_id: # (test.t1)
master-bin.000001	19815	Write_rows	1	19849	table_id: # flags: STMT_END_F
master-bin.000001	19849	Table_map	1	19890	table_id: # (test.t1)
master-bin.000001	19890	Write_rows	1	19924	table_id: # flags: STMT_END_F
master-bin.000001	19924	Table_map	1	19965	table_id: # (test.t1)
master-bin.000001	19965	Write_rows	1	19999	table_id: # flags: STMT_END_F
master-bin.000001	19999	Table_map	1	20040	table_id: # (test.t1)
master-bin.000001	20040	Write_rows	1	20074	table_id: # flags: STMT_END_F
master-bin.000001	20074	Table_map	1	20115	table_id: # (test.t1)
master-bin.000001	20115	Write_rows	1	20149	table_id: # flags: STMT_END_F
master-bin.000001	20149	Table_map	1	20190	table_id: # (test.t1)
master-bin.000001	20190	Write_rows	1	20224	table_id: # flags: STMT_END_F
master-bin.000001	20224	Table_map	1	20265	table_id: # (test.t1)
master-bin.000001	20265	Write_rows	1	20299	table_id: # flags: STMT_END_F
master-bin.000001	20299	Table_map	1	20340	table_id: # (test.t1)
master-bin.000001	20340	Write_rows	1	20374	table_id: # flags: STMT_END_F
master-bin.000001	20374	Table_map	1	20415	table_id: # (test.t1)
master-bin.000001	20415	Write_rows	1	20449	table_id: # flags: STMT_END_F
master-bin.000001	20449	Table_map	1	20490	table_id: # (test.t1)
master-bin.000001	20490	Write_rows	1	20524	table_id: # flags: STMT_END_F
master-bin.000001	20524	Table_map	1	20565	table_id: # (test.t1)
master-bin.000001	20565	Write_rows	1	20599	table_id: # flags: STMT_END_F
master-bin.000001	20599	Table_map	1	20640	table_id: # (test.t1)
master-bin.000001	20640	Write_rows	1	20674	table_id: # flags: STMT_END_F
master-bin.000001	20674	Table_map	1	20715	table_id: # (test.t1)
master-bin.000001	20715	Write_rows	1	20749	table_id: # flags: STMT_END_F
master-bin.000001	20749	Table_map	1	20790	table_id: # (test.t1)
master-bin.000001	20790	Write_rows	1	20824	table_id: # flags: STMT_END_F
master-bin.000001	20824	Table_map	1	20865	table_id: # (test.t1)
master-bin.000001	20865	Write_rows	1	20899	table_id: # flags: STMT_END_F
master-bin.000001	20899	Table_map	1	20940	table_id: # (test.t1)
master-bin.000001	20940	Write_rows	1	20974	table_id: # flags: STMT_END_F
master-bin.000001	20974	Table_map	1	21015	table_id: # (test.t1)
master-bin.000001	21015	Write_rows	1	21049	table_id: # flags: STMT_END_F
master-bin.000001	21049	Table_map	1	21090	table_id: # (test.t1)
master-bin.000001	21090	Write_rows	1	21124	table_id: # flags: STMT_END_F
master-bin.000001	21124	Table_map	1	21165	table_id: # (test.t1)
master-bin.000001	21165	Write_rows	1	21199	table_id: # flags: STMT_END_F
master-bin.000001	21199	Table_map	1	21240	table_id: # (test.t1)
master-bin.000001	21240	Write_rows	1	21274	table_id: # flags: STMT_END_F
master-bin.000001	21274	Table_map	1	21315	table_id: # (test.t1)
master-bin.000001	21315	Write_rows	1	21349	table_id: # flags: STMT_END_F
master-bin.000001	21349	Table_map	1	21390	table_id: # (test.t1)
master-bin.000001	21390	Write_rows	1	21424	table_id: # flags: STMT_END_F
master-bin.000001	21424	Table_map	1	21465	table_id: # (test.t1)
master-bin.000001	21465	Write_rows	1	21499	table_id: # flags: STMT_END_F
master-bin.000001	21499	Table_map	1	21540	table_id: # (test.t1)
master-bin.000001	21540	Write_rows	1	21574	table_id: # flags: STMT_END_F
master-bin.000001	21574	Table_map	1	21615	table_id: # (test.t1)
master-bin.000001	21615	Write_rows	1	21649	table_id: # flags: STMT_END_F
master-bin.000001	21649	Table_map	1	21690	table_id: # (test.t1)
master-bin.000001	21690	Write_rows	1	21724	table_id: # flags: STMT_END_F
master-bin.000001	21724	Table_map	1	21765	table_id: # (test.t1)
master-bin.000001	21765	Write_rows	1	21799	table_id: # flags: STMT_END_F
master-bin.000001	21799	Table_map	1	21840	table_id: # (test.t1)
master-bin.000001	21840	Write_rows	1	21874	table_id: # flags: STMT_END_F
master-bin.000001	21874	Table_map	1	21915	table_id: # (test.t1)
master-bin.000001	21915	Write_rows	1	21949	table_id: # flags: STMT_END_F
master-bin.000001	21949	Table_map	1	21990	table_id: # (test.t1)
master-bin.000001	21990	Write_rows	1	22024	table_id: # flags: STMT_END_F
master-bin.000001	22024	Table_map	1	22065	table_id: # (test.t1)
master-bin.000001	22065	Write_rows	1	22099	table_id: # flags: STMT_END_F
master-bin.000001	22099	Table_map	1	22140	table_id: # (test.t1)
master-bin.000001	22140	Write_rows	1	22174	table_id: # flags: STMT_END_F
master-bin.000001	22174	Table_map	1	22215	table_id: # (test.t1)
master-bin.000001	22215	Write_rows	1	22249	table_id: # flags: STMT_END_F
master-bin.000001	22249	Table_map	1	22290	table_id: # (test.t1)
master-bin.000001	22290	Write_rows	1	22324	table_id: # flags: STMT_END_F
master-bin.000001	22324	Table_map	1	22365	table_id: # (test.t1)
master-bin.000001	22365	Write_rows	1	22399	table_id: # flags: STMT_END_F
master-bin.000001	22399	Table_map	1	22440	table_id: # (test.t1)
master-bin.000001	22440	Write_rows	1	22474	table_id: # flags: STMT_END_F
master-bin.000001	22474	Table_map	1	22515	table_id: # (test.t1)
master-bin.000001	22515	Write_rows	1	22549	table_id: # flags: STMT_END_F
master-bin.000001	22549	Table_map	1	22590	table_id: # (test.t1)
master-bin.000001	22590	Write_rows	1	22624	table_id: # flags: STMT_END_F
master-bin.000001	22624	Table_map	1	22665	table_id: # (test.t1)
master-bin.000001	22665	Write_rows	1	22699	table_id: # flags: STMT_END_F
master-bin.000001	22699	Table_map	1	22740	table_id: # (test.t1)
master-bin.000001	22740	Write_rows	1	22774	table_id: # flags: STMT_END_F
master-bin.000001	22774	Table_map	1	22815	table_id: # (test.t1)
master-bin.000001	22815	Write_rows	1	22849	table_id: # flags: STMT_END_F
master-bin.000001	22849	Table_map	1	22890	table_id: # (test.t1)
master-bin.000001	22890	Write_rows	1	22924	table_id: # flags: STMT_END_F
master-bin.000001	22924	Table_map	1	22965	table_id: # (test.t1)
master-bin.000001	22965	Write_rows	1	22999	table_id: # flags: STMT_END_F
master-bin.000001	22999	Table_map	1	23040	table_id: # (test.t1)
master-bin.000001	23040	Write_rows	1	23074	table_id: # flags: STMT_END_F
master-bin.000001	23074	Table_map	1	23115	table_id: # (test.t1)
master-bin.000001	23115	Write_rows	1	23149	table_id: # flags: STMT_END_F
master-bin.000001	23149	Table_map	1	23190	table_id: # (test.t1)
master-bin.000001	23190	Write_rows	1	23224	table_id: # flags: STMT_END_F
master-bin.000001	23224	Table_map	1	23265	table_id: # (test.t1)
master-bin.000001	23265	Write_rows	1	23299	table_id: # flags: STMT_END_F
master-bin.000001	23299	Table_map	1	23340	table_id: # (test.t1)
master-bin.000001	23340	Write_rows	1	23374	table_id: # flags: STMT_END_F
master-bin.000001	23374	Table_map	1	23415	table_id: # (test.t1)
master-bin.000001	23415	Write_rows	1	23449	table_id: # flags: STMT_END_F
master-bin.000001	23449	Table_map	1	23490	table_id: # (test.t1)
master-bin.000001	23490	Write_rows	1	23524	table_id: # flags: STMT_END_F
master-bin.000001	23524	Table_map	1	23565	table_id: # (test.t1)
master-bin.000001	23565	Write_rows	1	23599	table_id: # flags: STMT_END_F
master-bin.000001	23599	Table_map	1	23640	table_id: # (test.t1)
master-bin.000001	23640	Write_rows	1	23674	table_id: # flags: STMT_END_F
master-bin.000001	23674	Table_map	1	23715	table_id: # (test.t1)
master-bin.000001	23715	Write_rows	1	23749	table_id: # flags: STMT_END_F
master-bin.000001	23749	Table_map	1	23790	table_id: # (test.t1)
master-bin.000001	23790	Write_rows	1	23824	table_id: # flags: STMT_END_F
master-bin.000001	23824	Table_map	1	23865	table_id: # (test.t1)
master-bin.000001	23865	Write_rows	1	23899	table_id: # flags: STMT_END_F
master-bin.000001	23899	Table_map	1	23940	table_id: # (test.t1)
master-bin.000001	23940	Write_rows	1	23974	table_id: # flags: STMT_END_F
master-bin.000001	23974	Table_map	1	24015	table_id: # (test.t1)
master-bin.000001	24015	Write_rows	1	24049	table_id: # flags: STMT_END_F
master-bin.000001	24049	Table_map	1	24090	table_id: # (test.t1)
master-bin.000001	24090	Write_rows	1	24124	table_id: # flags: STMT_END_F
master-bin.000001	24124	Table_map	1	24165	table_id: # (test.t1)
master-bin.000001	24165	Write_rows	1	24199	table_id: # flags: STMT_END_F
master-bin.000001	24199	Table_map	1	24240	table_id: # (test.t1)
master-bin.000001	24240	Write_rows	1	24274	table_id: # flags: STMT_END_F
master-bin.000001	24274	Table_map	1	24315	table_id: # (test.t1)
master-bin.000001	24315	Write_rows	1	24349	table_id: # flags: STMT_END_F
master-bin.000001	24349	Table_map	1	24390	table_id: # (test.t1)
master-bin.000001	24390	Write_rows	1	24424	table_id: # flags: STMT_END_F
master-bin.000001	24424	Table_map	1	24465	table_id: # (test.t1)
master-bin.000001	24465	Write_rows	1	24499	table_id: # flags: STMT_END_F
master-bin.000001	24499	Table_map	1	24540	table_id: # (test.t1)
master-bin.000001	24540	Write_rows	1	24574	table_id: # flags: STMT_END_F
master-bin.000001	24574	Table_map	1	24615	table_id: # (test.t1)
master-bin.000001	24615	Write_rows	1	24649	table_id: # flags: STMT_END_F
master-bin.000001	24649	Table_map	1	24690	table_id: # (test.t1)
master-bin.000001	24690	Write_rows	1	24724	table_id: # flags: STMT_END_F
master-bin.000001	24724	Table_map	1	24765	table_id: # (test.t1)
master-bin.000001	24765	Write_rows	1	24799	table_id: # flags: STMT_END_F
master-bin.000001	24799	Table_map	1	24840	table_id: # (test.t1)
master-bin.000001	24840	Write_rows	1	24874	table_id: # flags: STMT_END_F
master-bin.000001	24874	Table_map	1	24915	table_id: # (test.t1)
master-bin.000001	24915	Write_rows	1	24949	table_id: # flags: STMT_END_F
master-bin.000001	24949	Table_map	1	24990	table_id: # (test.t1)
master-bin.000001	24990	Write_rows	1	25024	table_id: # flags: STMT_END_F
master-bin.000001	25024	Table_map	1	25065	table_id: # (test.t1)
master-bin.000001	25065	Write_rows	1	25099	table_id: # flags: STMT_END_F
master-bin.000001	25099	Table_map	1	25140	table_id: # (test.t1)
master-bin.000001	25140	Write_rows	1	25174	table_id: # flags: STMT_END_F
master-bin.000001	25174	Table_map	1	25215	table_id: # (test.t1)
master-bin.000001	25215	Write_rows	1	25249	table_id: # flags: STMT_END_F
master-bin.000001	25249	Table_map	1	25290	table_id: # (test.t1)
master-bin.000001	25290	Write_rows	1	25324	table_id: # flags: STMT_END_F
master-bin.000001	25324	Table_map	1	25365	table_id: # (test.t1)
master-bin.000001	25365	Write_rows	1	25399	table_id: # flags: STMT_END_F
master-bin.000001	25399	Table_map	1	25440	table_id: # (test.t1)
master-bin.000001	25440	Write_rows	1	25474	table_id: # flags: STMT_END_F
master-bin.000001	25474	Table_map	1	25515	table_id: # (test.t1)
master-bin.000001	25515	Write_rows	1	25549	table_id: # flags: STMT_END_F
master-bin.000001	25549	Table_map	1	25590	table_id: # (test.t1)
master-bin.000001	25590	Write_rows	1	25624	table_id: # flags: STMT_END_F
master-bin.000001	25624	Table_map	1	25665	table_id: # (test.t1)
master-bin.000001	25665	Write_rows	1	25699	table_id: # flags: STMT_END_F
master-bin.000001	25699	Table_map	1	25740	table_id: # (test.t1)
master-bin.000001	25740	Write_rows	1	25774	table_id: # flags: STMT_END_F
master-bin.000001	25774	Table_map	1	25815	table_id: # (test.t1)
master-bin.000001	25815	Write_rows	1	25849	table_id: # flags: STMT_END_F
master-bin.000001	25849	Table_map	1	25890	table_id: # (test.t1)
master-bin.000001	25890	Write_rows	1	25924	table_id: # flags: STMT_END_F
master-bin.000001	25924	Table_map	1	25965	table_id: # (test.t1)
master-bin.000001	25965	Write_rows	1	25999	table_id: # flags: STMT_END_F
master-bin.000001	25999	Table_map	1	26040	table_id: # (test.t1)
master-bin.000001	26040	Write_rows	1	26074	table_id: # flags: STMT_END_F
master-bin.000001	26074	Table_map	1	26115	table_id: # (test.t1)
master-bin.000001	26115	Write_rows	1	26149	table_id: # flags: STMT_END_F
master-bin.000001	26149	Table_map	1	26190	table_id: # (test.t1)
master-bin.000001	26190	Write_rows	1	26224	table_id: # flags: STMT_END_F
master-bin.000001	26224	Table_map	1	26265	table_id: # (test.t1)
master-bin.000001	26265	Write_rows	1	26299	table_id: # flags: STMT_END_F
master-bin.000001	26299	Table_map	1	26340	table_id: # (test.t1)
master-bin.000001	26340	Write_rows	1	26374	table_id: # flags: STMT_END_F
master-bin.000001	26374	Table_map	1	26415	table_id: # (test.t1)
master-bin.000001	26415	Write_rows	1	26449	table_id: # flags: STMT_END_F
master-bin.000001	26449	Table_map	1	26490	table_id: # (test.t1)
master-bin.000001	26490	Write_rows	1	26524	table_id: # flags: STMT_END_F
master-bin.000001	26524	Table_map	1	26565	table_id: # (test.t1)
master-bin.000001	26565	Write_rows	1	26599	table_id: # flags: STMT_END_F
master-bin.000001	26599	Table_map	1	26640	table_id: # (test.t1)
master-bin.000001	26640	Write_rows	1	26674	table_id: # flags: STMT_END_F
master-bin.000001	26674	Table_map	1	26715	table_id: # (test.t1)
master-bin.000001	26715	Write_rows	1	26749	table_id: # flags: STMT_END_F
master-bin.000001	26749	Table_map	1	26790	table_id: # (test.t1)
master-bin.000001	26790	Write_rows	1	26824	table_id: # flags: STMT_END_F
master-bin.000001	26824	Table_map	1	26865	table_id: # (test.t1)
master-bin.000001	26865	Write_rows	1	26899	table_id: # flags: STMT_END_F
master-bin.000001	26899	Table_map	1	26940	table_id: # (test.t1)
master-bin.000001	26940	Write_rows	1	26974	table_id: # flags: STMT_END_F
master-bin.000001	26974	Table_map	1	27015	table_id: # (test.t1)
master-bin.000001	27015	Write_rows	1	27049	table_id: # flags: STMT_END_F
master-bin.000001	27049	Table_map	1	27090	table_id: # (test.t1)
master-bin.000001	27090	Write_rows	1	27124	table_id: # flags: STMT_END_F
master-bin.000001	27124	Table_map	1	27165	table_id: # (test.t1)
master-bin.000001	27165	Write_rows	1	27199	table_id: # flags: STMT_END_F
master-bin.000001	27199	Table_map	1	27240	table_id: # (test.t1)
master-bin.000001	27240	Write_rows	1	27274	table_id: # flags: STMT_END_F
master-bin.000001	27274	Table_map	1	27315	table_id: # (test.t1)
master-bin.000001	27315	Write_rows	1	27349	table_id: # flags: STMT_END_F
master-bin.000001	27349	Table_map	1	27390	table_id: # (test.t1)
master-bin.000001	27390	Write_rows	1	27424	table_id: # flags: STMT_END_F
master-bin.000001	27424	Table_map	1	27465	table_id: # (test.t1)
master-bin.000001	27465	Write_rows	1	27499	table_id: # flags: STMT_END_F
master-bin.000001	27499	Table_map	1	27540	table_id: # (test.t1)
master-bin.000001	27540	Write_rows	1	27574	table_id: # flags: STMT_END_F
master-bin.000001	27574	Table_map	1	27615	table_id: # (test.t1)
master-bin.000001	27615	Write_rows	1	27649	table_id: # flags: STMT_END_F
master-bin.000001	27649	Table_map	1	27690	table_id: # (test.t1)
master-bin.000001	27690	Write_rows	1	27724	table_id: # flags: STMT_END_F
master-bin.000001	27724	Table_map	1	27765	table_id: # (test.t1)
master-bin.000001	27765	Write_rows	1	27799	table_id: # flags: STMT_END_F
master-bin.000001	27799	Table_map	1	27840	table_id: # (test.t1)
master-bin.000001	27840	Write_rows	1	27874	table_id: # flags: STMT_END_F
master-bin.000001	27874	Table_map	1	27915	table_id: # (test.t1)
master-bin.000001	27915	Write_rows	1	27949	table_id: # flags: STMT_END_F
master-bin.000001	27949	Table_map	1	27990	table_id: # (test.t1)
master-bin.000001	27990	Write_rows	1	28024	table_id: # flags: STMT_END_F
master-bin.000001	28024	Table_map	1	28065	table_id: # (test.t1)
master-bin.000001	28065	Write_rows	1	28099	table_id: # flags: STMT_END_F
master-bin.000001	28099	Table_map	1	28140	table_id: # (test.t1)
master-bin.000001	28140	Write_rows	1	28174	table_id: # flags: STMT_END_F
master-bin.000001	28174	Table_map	1	28215	table_id: # (test.t1)
master-bin.000001	28215	Write_rows	1	28249	table_id: # flags: STMT_END_F
master-bin.000001	28249	Table_map	1	28290	table_id: # (test.t1)
master-bin.000001	28290	Write_rows	1	28324	table_id: # flags: STMT_END_F
master-bin.000001	28324	Table_map	1	28365	table_id: # (test.t1)
master-bin.000001	28365	Write_rows	1	28399	table_id: # flags: STMT_END_F
master-bin.000001	28399	Table_map	1	28440	table_id: # (test.t1)
master-bin.000001	28440	Write_rows	1	28474	table_id: # flags: STMT_END_F
master-bin.000001	28474	Table_map	1	28515	table_id: # (test.t1)
master-bin.000001	28515	Write_rows	1	28549	table_id: # flags: STMT_END_F
master-bin.000001	28549	Table_map	1	28590	table_id: # (test.t1)
master-bin.000001	28590	Write_rows	1	28624	table_id: # flags: STMT_END_F
master-bin.000001	28624	Table_map	1	28665	table_id: # (test.t1)
master-bin.000001	28665	Write_rows	1	28699	table_id: # flags: STMT_END_F
master-bin.000001	28699	Table_map	1	28740	table_id: # (test.t1)
master-bin.000001	28740	Write_rows	1	28774	table_id: # flags: STMT_END_F
master-bin.000001	28774	Table_map	1	28815	table_id: # (test.t1)
master-bin.000001	28815	Write_rows	1	28849	table_id: # flags: STMT_END_F
master-bin.000001	28849	Table_map	1	28890	table_id: # (test.t1)
master-bin.000001	28890	Write_rows	1	28924	table_id: # flags: STMT_END_F
master-bin.000001	28924	Table_map	1	28965	table_id: # (test.t1)
master-bin.000001	28965	Write_rows	1	28999	table_id: # flags: STMT_END_F
master-bin.000001	28999	Table_map	1	29040	table_id: # (test.t1)
master-bin.000001	29040	Write_rows	1	29074	table_id: # flags: STMT_END_F
master-bin.000001	29074	Table_map	1	29115	table_id: # (test.t1)
master-bin.000001	29115	Write_rows	1	29149	table_id: # flags: STMT_END_F
master-bin.000001	29149	Table_map	1	29190	table_id: # (test.t1)
master-bin.000001	29190	Write_rows	1	29224	table_id: # flags: STMT_END_F
master-bin.000001	29224	Table_map	1	29265	table_id: # (test.t1)
master-bin.000001	29265	Write_rows	1	29299	table_id: # flags: STMT_END_F
master-bin.000001	29299	Table_map	1	29340	table_id: # (test.t1)
master-bin.000001	29340	Write_rows	1	29374	table_id: # flags: STMT_END_F
master-bin.000001	29374	Table_map	1	29415	table_id: # (test.t1)
master-bin.000001	29415	Write_rows	1	29449	table_id: # flags: STMT_END_F
master-bin.000001	29449	Table_map	1	29490	table_id: # (test.t1)
master-bin.000001	29490	Write_rows	1	29524	table_id: # flags: STMT_END_F
master-bin.000001	29524	Table_map	1	29565	table_id: # (test.t1)
master-bin.000001	29565	Write_rows	1	29599	table_id: # flags: STMT_END_F
master-bin.000001	29599	Table_map	1	29640	table_id: # (test.t1)
master-bin.000001	29640	Write_rows	1	29674	table_id: # flags: STMT_END_F
master-bin.000001	29674	Table_map	1	29715	table_id: # (test.t1)
master-bin.000001	29715	Write_rows	1	29749	table_id: # flags: STMT_END_F
master-bin.000001	29749	Table_map	1	29790	table_id: # (test.t1)
master-bin.000001	29790	Write_rows	1	29824	table_id: # flags: STMT_END_F
master-bin.000001	29824	Table_map	1	29865	table_id: # (test.t1)
master-bin.000001	29865	Write_rows	1	29899	table_id: # flags: STMT_END_F
master-bin.000001	29899	Table_map	1	29940	table_id: # (test.t1)
master-bin.000001	29940	Write_rows	1	29974	table_id: # flags: STMT_END_F
master-bin.000001	29974	Table_map	1	30015	table_id: # (test.t1)
master-bin.000001	30015	Write_rows	1	30049	table_id: # flags: STMT_END_F
master-bin.000001	30049	Table_map	1	30090	table_id: # (test.t1)
master-bin.000001	30090	Write_rows	1	30124	table_id: # flags: STMT_END_F
master-bin.000001	30124	Table_map	1	30165	table_id: # (test.t1)
master-bin.000001	30165	Write_rows	1	30199	table_id: # flags: STMT_END_F
master-bin.000001	30199	Table_map	1	30240	table_id: # (test.t1)
master-bin.000001	30240	Write_rows	1	30274	table_id: # flags: STMT_END_F
master-bin.000001	30274	Xid	1	30301	COMMIT /* XID */
master-bin.000001	30301	Rotate	1	30345	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	106	Server version, Binlog ver: 4
master-bin.000001	106	Query	1	227	use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
master-bin.000001	227	Query	1	295	BEGIN
master-bin.000001	295	Table_map	1	337	table_id: # (test.t1)
master-bin.000001	337	Write_rows	1	383	table_id: # flags: STMT_END_F
master-bin.000001	383	Query	1	452	COMMIT
master-bin.000001	452	Query	1	528	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	346		
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	106		
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;