Merge mysql.com:/home/bkroot/mysql-5.0 into mysql.com:/home/bk/mysql-5.0

mysql-test/r/sp_trans.result:
  Auto merged
mysql-test/t/sp_trans.test:
  Auto merged
sql/sql_parse.cc:
  Auto merged

5 files changed, 1797 insertions, 9 deletions

diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result
index 4be9139f20b..95142caf36c 100644
--- a/mysql-test/r/ctype_utf8.result
+++ b/mysql-test/r/ctype_utf8.result
@@ -891,3 +891,14 @@ string
 create table t1 (a varchar(255)) default character set utf8;
 insert into t1 values (1.0);
 drop table t1;
+create table t1 (
+id int not null,
+city varchar(20) not null,
+key (city(7),id)
+) character set=utf8;
+insert into t1 values (1,'Durban North');
+insert into t1 values (2,'Durban');
+select * from t1 where city = 'Durban';
+id	city
+2	Durban
+drop table t1;
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result
index 31480e32c16..24ba58e0b68 100644
--- a/mysql-test/r/innodb.result
+++ b/mysql-test/r/innodb.result
@@ -909,7 +909,6 @@ set autocommit=0;
 create table t1 (a int not null) engine= innodb;
 insert into t1 values(1),(2);
 truncate table t1;
-ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
 commit;
 truncate table t1;
 truncate table t1;
@@ -1638,14 +1637,14 @@ t2	CREATE TABLE `t2` (
 drop table t2, t1;
 show status like "binlog_cache_use";
 Variable_name	Value
-Binlog_cache_use	153
+Binlog_cache_use	155
 show status like "binlog_cache_disk_use";
 Variable_name	Value
 Binlog_cache_disk_use	0
 create table t1 (a int) engine=innodb;
 show status like "binlog_cache_use";
 Variable_name	Value
-Binlog_cache_use	154
+Binlog_cache_use	156
 show status like "binlog_cache_disk_use";
 Variable_name	Value
 Binlog_cache_disk_use	1
@@ -1654,7 +1653,7 @@ delete from t1;
 commit;
 show status like "binlog_cache_use";
 Variable_name	Value
-Binlog_cache_use	155
+Binlog_cache_use	157
 show status like "binlog_cache_disk_use";
 Variable_name	Value
 Binlog_cache_disk_use	1
diff --git a/mysql-test/r/innodb_cache.result b/mysql-test/r/innodb_cache.result
index ec43cbe10b2..5e8611655a2 100644
--- a/mysql-test/r/innodb_cache.result
+++ b/mysql-test/r/innodb_cache.result
@@ -24,7 +24,7 @@ a
 3
 show status like "Qcache_queries_in_cache";
 Variable_name	Value
-Qcache_queries_in_cache	0
+Qcache_queries_in_cache	1
 drop table t1;
 commit;
 create table t1 (a int not null) engine=innodb;
diff --git a/mysql-test/r/rpl_ddl.result b/mysql-test/r/rpl_ddl.result
new file mode 100644
index 00000000000..9c3775d8917
--- /dev/null
+++ b/mysql-test/r/rpl_ddl.result
@@ -0,0 +1,1782 @@
+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;
diff --git a/mysql-test/r/sp_trans.result b/mysql-test/r/sp_trans.result
index 047711bb736..6077087ab87 100644
--- a/mysql-test/r/sp_trans.result
+++ b/mysql-test/r/sp_trans.result
@@ -8,17 +8,13 @@ end|
 set autocommit=0|
 insert t1 values (2)|
 call bug8850()|
-ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
 commit|
 select * from t1|
 a
-2
 call bug8850()|
-ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
 set autocommit=1|
 select * from t1|
 a
-2
 drop table t1|
 drop procedure bug8850|
 drop function if exists bug10015_1|