Debian Codegraph @

mysql-test/suite/binlog/r/binlog_create_drop_temporary_table.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 TEMPORARY TABLE tmp1 ENGINE=InnoDB SELECT * FROM t1;
11 DROP TEMPORARY TABLE tmp1;
12 CREATE TEMPORARY TABLE tmp5 (a INT) ENGINE=InnoDB;
13 DROP TEMPORARY TABLE tmp5;
14 CREATE TEMPORARY TABLE tmp7 LIKE t1;
15 DROP TEMPORARY TABLE tmp7;
16 include/assert.inc [CREATE/DROP TEMPORARY TABLE is not written into binlog when @@session.binlog_format= MIXED.]
17 SET @@session.binlog_format= ROW;
18 Warnings:
19 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
20 SELECT @@session.binlog_format;
21 @@session.binlog_format
22 ROW
23 Warnings:
24 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
25 CREATE TEMPORARY TABLE tmp1 ENGINE=InnoDB SELECT * FROM t1;
26 DROP TEMPORARY TABLE tmp1;
27 CREATE TEMPORARY TABLE tmp5 (a INT) ENGINE=InnoDB;
28 DROP TEMPORARY TABLE tmp5;
29 CREATE TEMPORARY TABLE tmp7 LIKE t1;
30 DROP TEMPORARY TABLE tmp7;
31 include/assert.inc [CREATE/DROP TEMPORARY TABLE is not written into binlog when @@session.binlog_format= ROW.]
32 DROP TABLE t1;