stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
SET AUTOCOMMIT = 1;
DROP DATABASE IF EXISTS mysqltest1;
DROP DATABASE IF EXISTS mysqltest2;
DROP DATABASE IF EXISTS mysqltest3;
CREATE DATABASE mysqltest1;
CREATE DATABASE mysqltest2;
CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB";
INSERT INTO mysqltest1.t1 SET f1= 0;
CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB";
CREATE INDEX my_idx6 ON mysqltest1.t6(f1);
CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB";
INSERT INTO mysqltest1.t7 SET f1= 0;
CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB";
CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT);
SET AUTOCOMMIT = 0;
use mysqltest1;

-------- switch to slave --------
SET AUTOCOMMIT = 0;
use mysqltest1;

-------- switch to master -------

######## COMMIT  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 0 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest1
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest2
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest3
master-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest1
master-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest2
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t1 SET f1= 0
master-bin.000001	#	Xid	1	#	COMMIT /* xid=14 */
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1)
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t7 SET f1= 0
master-bin.000001	#	Xid	1	#	COMMIT /* xid=24 */
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT)

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
0
SHOW BINLOG EVENTS IN 'slave-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000001	#	Query	2	#	use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest1
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest2
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest3
slave-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest1
slave-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest2
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t1 SET f1= 0
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1)
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t7 SET f1= 0
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT)

-------- switch to master -------
COMMIT;
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest1
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest2
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest3
master-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest1
master-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest2
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t1 SET f1= 0
master-bin.000001	#	Xid	1	#	COMMIT /* xid=14 */
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1)
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t7 SET f1= 0
master-bin.000001	#	Xid	1	#	COMMIT /* xid=24 */
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT)
master-bin.000001	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000001	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1
master-bin.000001	#	Xid	1	#	COMMIT /* xid=49 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'slave-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000001	#	Query	2	#	use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest1
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest2
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest3
slave-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest1
slave-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest2
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t1 SET f1= 0
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1)
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t7 SET f1= 0
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT)
slave-bin.000001	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
1

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest1
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest2
master-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest3
master-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest1
master-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest2
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t1 SET f1= 0
master-bin.000001	#	Xid	1	#	COMMIT /* xid=14 */
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1)
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t7 SET f1= 0
master-bin.000001	#	Xid	1	#	COMMIT /* xid=24 */
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"
master-bin.000001	#	Query	1	#	use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT)
master-bin.000001	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000001	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1
master-bin.000001	#	Xid	1	#	COMMIT /* xid=49 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
1

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000001	#	Query	2	#	use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest1
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest2
slave-bin.000001	#	Query	1	#	DROP DATABASE IF EXISTS mysqltest3
slave-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest1
slave-bin.000001	#	Query	1	#	CREATE DATABASE mysqltest2
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t1 SET f1= 0
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1)
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; INSERT INTO mysqltest1.t7 SET f1= 0
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"
slave-bin.000001	#	Query	1	#	use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT)
slave-bin.000001	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## ROLLBACK  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 1 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
2
SHOW BINLOG EVENTS IN 'master-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000002	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'slave-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000002	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'master-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000002	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'slave-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000002	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
1

TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000002	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
1

TEST-INFO: SLAVE:  The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000002	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## SET AUTOCOMMIT=1  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 1 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
2
SHOW BINLOG EVENTS IN 'master-bin.000003';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000003	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
1
SHOW BINLOG EVENTS IN 'slave-bin.000003';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000003	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
SET AUTOCOMMIT=1;
SELECT MAX(f1) FROM t1;
MAX(f1)
2
SHOW BINLOG EVENTS IN 'master-bin.000003';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000003	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000003	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1
master-bin.000003	#	Xid	1	#	COMMIT /* xid=88 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
2
SHOW BINLOG EVENTS IN 'slave-bin.000003';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000003	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000003	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
2

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000003';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000003	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000003	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1
master-bin.000003	#	Xid	1	#	COMMIT /* xid=88 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
2

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000003';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000003	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000003	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SET AUTOCOMMIT=0;

######## START TRANSACTION  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 2 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
3
SHOW BINLOG EVENTS IN 'master-bin.000004';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000004	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
2
SHOW BINLOG EVENTS IN 'slave-bin.000004';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000004	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
START TRANSACTION;
SELECT MAX(f1) FROM t1;
MAX(f1)
3
SHOW BINLOG EVENTS IN 'master-bin.000004';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000004	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000004	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000004	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1
master-bin.000004	#	Xid	1	#	COMMIT /* xid=131 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
3
SHOW BINLOG EVENTS IN 'slave-bin.000004';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000004	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000004	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
3

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000004';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000004	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000004	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000004	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1
master-bin.000004	#	Xid	1	#	COMMIT /* xid=131 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
3

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000004';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000004	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000004	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## BEGIN  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 3 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
4
SHOW BINLOG EVENTS IN 'master-bin.000005';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000005	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
3
SHOW BINLOG EVENTS IN 'slave-bin.000005';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000005	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
BEGIN;
SELECT MAX(f1) FROM t1;
MAX(f1)
4
SHOW BINLOG EVENTS IN 'master-bin.000005';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000005	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000005	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000005	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1
master-bin.000005	#	Xid	1	#	COMMIT /* xid=143 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
4
SHOW BINLOG EVENTS IN 'slave-bin.000005';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000005	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000005	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
4

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000005';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000005	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000005	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000005	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1
master-bin.000005	#	Xid	1	#	COMMIT /* xid=143 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
4

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000005';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000005	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000005	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## DROP TABLE mysqltest1.t2  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 4 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
5
SHOW BINLOG EVENTS IN 'master-bin.000006';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000006	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
4
SHOW BINLOG EVENTS IN 'slave-bin.000006';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000006	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
DROP TABLE mysqltest1.t2;
SELECT MAX(f1) FROM t1;
MAX(f1)
5
SHOW BINLOG EVENTS IN 'master-bin.000006';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000006	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000006	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000006	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1
master-bin.000006	#	Xid	1	#	COMMIT /* xid=170 */
master-bin.000006	#	Query	1	#	use `mysqltest1`; DROP TABLE mysqltest1.t2

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
5
SHOW BINLOG EVENTS IN 'slave-bin.000006';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000006	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000006	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1
slave-bin.000006	#	Query	1	#	use `mysqltest1`; DROP TABLE mysqltest1.t2

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
5

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000006';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000006	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000006	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000006	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1
master-bin.000006	#	Xid	1	#	COMMIT /* xid=170 */
master-bin.000006	#	Query	1	#	use `mysqltest1`; DROP TABLE mysqltest1.t2

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
5

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000006';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000006	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000006	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1
slave-bin.000006	#	Query	1	#	use `mysqltest1`; DROP TABLE mysqltest1.t2

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW TABLES LIKE 't2';
Tables_in_mysqltest1 (t2)

-------- switch to slave --------
SHOW TABLES LIKE 't2';
Tables_in_mysqltest1 (t2)

-------- switch to master -------

######## DROP TEMPORARY TABLE mysqltest1.t23  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 5 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'master-bin.000007';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000007	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
5
SHOW BINLOG EVENTS IN 'slave-bin.000007';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000007	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
DROP TEMPORARY TABLE mysqltest1.t23;
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'master-bin.000007';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000007	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
5
SHOW BINLOG EVENTS IN 'slave-bin.000007';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000007	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ROLLBACK;
Warnings:
Warning	1196	Some non-transactional changed tables couldn't be rolled back
SELECT MAX(f1) FROM t1;
MAX(f1)
5

TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000007';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000007	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000007	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000007	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1
master-bin.000007	#	Query	1	#	use `mysqltest1`; DROP TEMPORARY TABLE mysqltest1.t23
master-bin.000007	#	Query	1	#	use `mysqltest1`; ROLLBACK

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
6

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000007';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000007	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000007	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1
slave-bin.000007	#	Query	1	#	use `mysqltest1`; DROP TEMPORARY TABLE mysqltest1.t23

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW TABLES LIKE 't23';
Tables_in_mysqltest1 (t23)

-------- switch to slave --------
SHOW TABLES LIKE 't23';
Tables_in_mysqltest1 (t23)

-------- switch to master -------

######## RENAME TABLE mysqltest1.t3 to mysqltest1.t20  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 5 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'master-bin.000008';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000008	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'slave-bin.000008';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000008	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
RENAME TABLE mysqltest1.t3 to mysqltest1.t20;
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'master-bin.000008';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000008	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000008	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000008	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1
master-bin.000008	#	Xid	1	#	COMMIT /* xid=227 */
master-bin.000008	#	Query	1	#	use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'slave-bin.000008';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000008	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000008	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1
slave-bin.000008	#	Query	1	#	use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
6

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000008';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000008	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000008	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000008	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1
master-bin.000008	#	Xid	1	#	COMMIT /* xid=227 */
master-bin.000008	#	Query	1	#	use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
6

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000008';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000008	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000008	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1
slave-bin.000008	#	Query	1	#	use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW TABLES LIKE 't20';
Tables_in_mysqltest1 (t20)
t20

-------- switch to slave --------
SHOW TABLES LIKE 't20';
Tables_in_mysqltest1 (t20)
t20

-------- switch to master -------

######## ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 6 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
7
SHOW BINLOG EVENTS IN 'master-bin.000009';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000009	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
6
SHOW BINLOG EVENTS IN 'slave-bin.000009';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000009	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT;
SELECT MAX(f1) FROM t1;
MAX(f1)
7
SHOW BINLOG EVENTS IN 'master-bin.000009';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000009	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000009	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000009	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1
master-bin.000009	#	Xid	1	#	COMMIT /* xid=256 */
master-bin.000009	#	Query	1	#	use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
7
SHOW BINLOG EVENTS IN 'slave-bin.000009';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000009	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000009	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1
slave-bin.000009	#	Query	1	#	use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
7

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000009';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000009	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000009	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000009	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1
master-bin.000009	#	Xid	1	#	COMMIT /* xid=256 */
master-bin.000009	#	Query	1	#	use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
7

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000009';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000009	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000009	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1
slave-bin.000009	#	Query	1	#	use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
describe mysqltest1.t4;
Field	Type	Null	Key	Default	Extra
f1	bigint(20)	YES		NULL	
f2	bigint(20)	YES		NULL	

-------- switch to slave --------
describe mysqltest1.t4;
Field	Type	Null	Key	Default	Extra
f1	bigint(20)	YES		NULL	
f2	bigint(20)	YES		NULL	

-------- switch to master -------

######## CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 7 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
8
SHOW BINLOG EVENTS IN 'master-bin.000010';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000010	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
7
SHOW BINLOG EVENTS IN 'slave-bin.000010';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000010	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB";
SELECT MAX(f1) FROM t1;
MAX(f1)
8
SHOW BINLOG EVENTS IN 'master-bin.000010';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000010	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000010	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000010	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1
master-bin.000010	#	Xid	1	#	COMMIT /* xid=285 */
master-bin.000010	#	Query	1	#	use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
8
SHOW BINLOG EVENTS IN 'slave-bin.000010';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000010	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000010	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1
slave-bin.000010	#	Query	1	#	use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
8

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000010';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000010	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000010	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000010	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1
master-bin.000010	#	Xid	1	#	COMMIT /* xid=285 */
master-bin.000010	#	Query	1	#	use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
8

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000010';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000010	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000010	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1
slave-bin.000010	#	Query	1	#	use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT)  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 8 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'master-bin.000011';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000011	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
8
SHOW BINLOG EVENTS IN 'slave-bin.000011';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000011	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT);
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'master-bin.000011';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000011	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
8
SHOW BINLOG EVENTS IN 'slave-bin.000011';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000011	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ROLLBACK;
Warnings:
Warning	1196	Some non-transactional changed tables couldn't be rolled back
SELECT MAX(f1) FROM t1;
MAX(f1)
8

TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000011';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000011	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000011	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000011	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1
master-bin.000011	#	Query	1	#	use `mysqltest1`; CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT)
master-bin.000011	#	Query	1	#	use `mysqltest1`; ROLLBACK

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
9

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000011';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000011	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000011	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1
slave-bin.000011	#	Query	1	#	use `mysqltest1`; CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT)

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## TRUNCATE TABLE mysqltest1.t7  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 8 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'master-bin.000012';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000012	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'slave-bin.000012';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000012	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
TRUNCATE TABLE mysqltest1.t7;
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'master-bin.000012';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000012	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000012	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000012	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1
master-bin.000012	#	Xid	1	#	COMMIT /* xid=342 */
master-bin.000012	#	Query	1	#	use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7
master-bin.000012	#	Xid	1	#	COMMIT /* xid=363 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'slave-bin.000012';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000012	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000012	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1
slave-bin.000012	#	Query	1	#	use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
9

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000012';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000012	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000012	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000012	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1
master-bin.000012	#	Xid	1	#	COMMIT /* xid=342 */
master-bin.000012	#	Query	1	#	use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7
master-bin.000012	#	Xid	1	#	COMMIT /* xid=363 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
9

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000012';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000012	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000012	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1
slave-bin.000012	#	Query	1	#	use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SELECT * FROM mysqltest1.t7;
f1

-------- switch to slave --------
SELECT * FROM mysqltest1.t7;
f1

-------- switch to master -------

######## LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 9 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'master-bin.000013';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000013	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
9
SHOW BINLOG EVENTS IN 'slave-bin.000013';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000013	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ;
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'master-bin.000013';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000013	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000013	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000013	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1
master-bin.000013	#	Xid	1	#	COMMIT /* xid=369 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'slave-bin.000013';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000013	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000013	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
10

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000013';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000013	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000013	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000013	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1
master-bin.000013	#	Xid	1	#	COMMIT /* xid=369 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000013';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000013	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000013	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
UNLOCK TABLES;

######## UNLOCK TABLES  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 10 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
11
SHOW BINLOG EVENTS IN 'master-bin.000014';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000014	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'slave-bin.000014';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000014	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
UNLOCK TABLES;
SELECT MAX(f1) FROM t1;
MAX(f1)
11
SHOW BINLOG EVENTS IN 'master-bin.000014';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000014	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'slave-bin.000014';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000014	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
10

TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000014';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000014	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10

TEST-INFO: SLAVE:  The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000014';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000014	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
LOCK TABLES mysqltest1.t1 READ;

######## UNLOCK TABLES  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 10 + 1;
ERROR HY000: Table 't1' was locked with a READ lock and can't be updated
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'master-bin.000015';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000015	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'slave-bin.000015';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000015	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
UNLOCK TABLES;
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'master-bin.000015';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000015	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'slave-bin.000015';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000015	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
10

TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000015';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000015	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10

TEST-INFO: SLAVE:  The INSERT is not committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000015';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000015	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ;

######## UNLOCK TABLES  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 10 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
11
SHOW BINLOG EVENTS IN 'master-bin.000016';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000016	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
10
SHOW BINLOG EVENTS IN 'slave-bin.000016';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000016	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
UNLOCK TABLES;
SELECT MAX(f1) FROM t1;
MAX(f1)
11
SHOW BINLOG EVENTS IN 'master-bin.000016';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000016	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000016	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000016	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1
master-bin.000016	#	Xid	1	#	COMMIT /* xid=462 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
11
SHOW BINLOG EVENTS IN 'slave-bin.000016';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000016	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000016	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
11

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000016';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000016	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000016	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000016	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1
master-bin.000016	#	Xid	1	#	COMMIT /* xid=462 */

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
11

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000016';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000016	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000016	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------

######## DROP INDEX my_idx6 ON mysqltest1.t6  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 11 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
12
SHOW BINLOG EVENTS IN 'master-bin.000017';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000017	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
11
SHOW BINLOG EVENTS IN 'slave-bin.000017';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000017	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
DROP INDEX my_idx6 ON mysqltest1.t6;
SELECT MAX(f1) FROM t1;
MAX(f1)
12
SHOW BINLOG EVENTS IN 'master-bin.000017';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000017	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000017	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000017	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1
master-bin.000017	#	Xid	1	#	COMMIT /* xid=482 */
master-bin.000017	#	Query	1	#	use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
12
SHOW BINLOG EVENTS IN 'slave-bin.000017';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000017	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000017	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1
slave-bin.000017	#	Query	1	#	use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
12

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000017';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000017	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000017	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000017	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1
master-bin.000017	#	Xid	1	#	COMMIT /* xid=482 */
master-bin.000017	#	Query	1	#	use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
12

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000017';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000017	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000017	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1
slave-bin.000017	#	Query	1	#	use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW INDEX FROM mysqltest1.t6;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment

-------- switch to slave --------
SHOW INDEX FROM mysqltest1.t6;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment

-------- switch to master -------

######## CREATE INDEX my_idx5 ON mysqltest1.t5(f1)  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 12 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
13
SHOW BINLOG EVENTS IN 'master-bin.000018';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000018	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
12
SHOW BINLOG EVENTS IN 'slave-bin.000018';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000018	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
CREATE INDEX my_idx5 ON mysqltest1.t5(f1);
SELECT MAX(f1) FROM t1;
MAX(f1)
13
SHOW BINLOG EVENTS IN 'master-bin.000018';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000018	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000018	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000018	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1
master-bin.000018	#	Xid	1	#	COMMIT /* xid=509 */
master-bin.000018	#	Query	1	#	use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1)

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
13
SHOW BINLOG EVENTS IN 'slave-bin.000018';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000018	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000018	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1
slave-bin.000018	#	Query	1	#	use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1)

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
13

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000018';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000018	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000018	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000018	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1
master-bin.000018	#	Xid	1	#	COMMIT /* xid=509 */
master-bin.000018	#	Query	1	#	use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1)

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
13

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000018';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000018	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000018	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1
slave-bin.000018	#	Query	1	#	use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1)

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW INDEX FROM mysqltest1.t5;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t5	1	my_idx5	1	f1	A	0	NULL	NULL	YES	BTREE	

-------- switch to slave --------
SHOW INDEX FROM mysqltest1.t5;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t5	1	my_idx5	1	f1	A	NULL	NULL	NULL	YES	BTREE	

-------- switch to master -------

######## DROP DATABASE mysqltest2  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 13 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
14
SHOW BINLOG EVENTS IN 'master-bin.000019';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000019	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
13
SHOW BINLOG EVENTS IN 'slave-bin.000019';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000019	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
DROP DATABASE mysqltest2;
SELECT MAX(f1) FROM t1;
MAX(f1)
14
SHOW BINLOG EVENTS IN 'master-bin.000019';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000019	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000019	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000019	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1
master-bin.000019	#	Xid	1	#	COMMIT /* xid=538 */
master-bin.000019	#	Query	1	#	DROP DATABASE mysqltest2

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
14
SHOW BINLOG EVENTS IN 'slave-bin.000019';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000019	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000019	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1
slave-bin.000019	#	Query	1	#	DROP DATABASE mysqltest2

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
14

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000019';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000019	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000019	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000019	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1
master-bin.000019	#	Xid	1	#	COMMIT /* xid=538 */
master-bin.000019	#	Query	1	#	DROP DATABASE mysqltest2

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
14

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000019';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000019	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000019	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1
slave-bin.000019	#	Query	1	#	DROP DATABASE mysqltest2

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW DATABASES LIKE "mysqltest2";
Database (mysqltest2)

-------- switch to slave --------
SHOW DATABASES LIKE "mysqltest2";
Database (mysqltest2)

-------- switch to master -------

######## CREATE DATABASE mysqltest3  ########

-------- switch to master -------
INSERT INTO t1 SET f1= 14 + 1;
SELECT MAX(f1) FROM t1;
MAX(f1)
15
SHOW BINLOG EVENTS IN 'master-bin.000020';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000020	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
14
SHOW BINLOG EVENTS IN 'slave-bin.000020';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000020	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4

-------- switch to master -------
CREATE DATABASE mysqltest3;
SELECT MAX(f1) FROM t1;
MAX(f1)
15
SHOW BINLOG EVENTS IN 'master-bin.000020';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000020	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000020	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000020	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1
master-bin.000020	#	Xid	1	#	COMMIT /* xid=567 */
master-bin.000020	#	Query	1	#	CREATE DATABASE mysqltest3

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
15
SHOW BINLOG EVENTS IN 'slave-bin.000020';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000020	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000020	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1
slave-bin.000020	#	Query	1	#	CREATE DATABASE mysqltest3

-------- switch to master -------
ROLLBACK;
SELECT MAX(f1) FROM t1;
MAX(f1)
15

TEST-INFO: MASTER: The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'master-bin.000020';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000020	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000020	#	Query	1	#	use `mysqltest1`; BEGIN
master-bin.000020	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1
master-bin.000020	#	Xid	1	#	COMMIT /* xid=567 */
master-bin.000020	#	Query	1	#	CREATE DATABASE mysqltest3

-------- switch to slave --------
SELECT MAX(f1) FROM t1;
MAX(f1)
15

TEST-INFO: SLAVE:  The INSERT is committed (Succeeded)
SHOW BINLOG EVENTS IN 'slave-bin.000020';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000020	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000020	#	Query	1	#	use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1
slave-bin.000020	#	Query	1	#	CREATE DATABASE mysqltest3

-------- switch to master -------
flush logs;

-------- switch to slave --------
flush logs;

-------- switch to master -------
SHOW DATABASES LIKE "mysqltest3";
Database (mysqltest3)
mysqltest3

-------- switch to slave --------
SHOW DATABASES LIKE "mysqltest3";
Database (mysqltest3)
mysqltest3

-------- switch to master -------
DROP DATABASE IF EXISTS mysqltest1;
DROP DATABASE IF EXISTS mysqltest2;
DROP DATABASE IF EXISTS mysqltest3;