Debian Codegraph @

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

raw
1 SET @@session.binlog_format= MIXED;
2 Warnings:
3 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
4 SELECT @@session.binlog_format;
5 @@session.binlog_format
6 MIXED
7 Warnings:
8 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
9 CREATE TABLE t1(a INT) ENGINE=InnoDB;
10 CREATE TABLE t2(a INT) ENGINE=MyISAM;
11 CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2;
12 DROP TEMPORARY TABLE tmp2;
13 CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1;
14 DROP TEMPORARY TABLE tmp3;
15 CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2;
16 DROP TEMPORARY TABLE tmp4;
17 CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM;
18 DROP TEMPORARY TABLE tmp6;
19 CREATE TEMPORARY TABLE tmp8 LIKE t2;
20 DROP TEMPORARY TABLE tmp8;
21 include/assert.inc [CREATE/DROP TEMPORARY TABLE is not written into binlog when @@session.binlog_format= MIXED.]
22 SET @@session.binlog_format= ROW;
23 Warnings:
24 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
25 SELECT @@session.binlog_format;
26 @@session.binlog_format
27 ROW
28 Warnings:
29 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
30 CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2;
31 DROP TEMPORARY TABLE tmp2;
32 CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1;
33 DROP TEMPORARY TABLE tmp3;
34 CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2;
35 DROP TEMPORARY TABLE tmp4;
36 CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM;
37 DROP TEMPORARY TABLE tmp6;
38 CREATE TEMPORARY TABLE tmp8 LIKE t2;
39 DROP TEMPORARY TABLE tmp8;
40 include/assert.inc [CREATE/DROP TEMPORARY TABLE is not written into binlog when @@session.binlog_format= ROW.]
41 DROP TABLE t1,t2;