Debian Codegraph @

mysql-test/suite/binlog/r/binlog_drop_temp_table_on_disconnect_stmt_myisam.result

raw
1 RESET MASTER;
2 CREATE TABLE t1(a INT) ENGINE=InnoDB;
3 CREATE TABLE t2(a INT) ENGINE=MyISAM;
4 CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2;
5 CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1;
6 CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2;
7 CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM;
8 CREATE TEMPORARY TABLE tmp8 LIKE t2;
9 include/show_binlog_events.inc
10 Log_name Pos Event_type Server_id End_log_pos Info
11 binlog.000001 # Query # # use `test`; CREATE TABLE t1(a INT) ENGINE=InnoDB
12 binlog.000001 # Query # # use `test`; CREATE TABLE t2(a INT) ENGINE=MyISAM
13 binlog.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2
14 binlog.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1
15 binlog.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2
16 binlog.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM
17 binlog.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp8 LIKE t2
18 binlog.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp4`
19 binlog.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp8`,`tmp6`,`tmp3`,`tmp2`
20 DROP TABLE t1, t2;