1# Save the initial number of concurrent sessions
2# Establish connection con1 (user=root)
3# Establish connection con2 (user=root)
4# Switch to connection con1
5CREATE TABLE t1 (a INT) ENGINE=innodb;
6RESET MASTER;
7SET AUTOCOMMIT=0;
8SELECT 1;
91
101
11# Switch to connection con2
12FLUSH TABLES WITH READ LOCK;
13include/show_binlog_events.inc
14# Switch to connection con1
15INSERT INTO t1 VALUES (1);
16# Switch to connection con2
17include/show_binlog_events.inc
18UNLOCK TABLES;
19# Switch to connection con1
20DROP TABLE t1;
21SET AUTOCOMMIT=1;
22create table t1 (a int) engine=innodb;
23flush tables with read lock;
24begin;
25insert into t1 values (1);;
26unlock tables;
27commit;
28drop table t1;
29# Switch to connection default and close connections con1 and con2
30# Wait till all disconnects are completed
31