Debian Codegraph @

mysql-test/suite/rpl/t/rpl_reopen_temp_table.test

raw
1 --source include/have_innodb.inc
2 --source include/master-slave.inc
3
4 # Clean up old slave's binlogs (see rpl_temporary.test for explanation).
5 save_master_pos;
6 connection slave;
7 sync_with_master;
8 reset master;
9
10 --echo #
11 --echo # MDEV-5535: Cannot reopen temporary table
12 --echo #
13
14 connection master;
15 --disable_query_log
16 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
17 --enable_query_log
18
19 disable_warnings;
20 DROP TABLE IF EXISTS t1, t2, t3;
21 enable_warnings;
22
23 CREATE TEMPORARY TABLE t1(c1 INT) ENGINE=INNODB;
24 INSERT INTO t1 VALUES (1), (2), (3), (4), (5);
25
26 CREATE TEMPORARY TABLE t2 SELECT A.c1 a, B.c1 b FROM t1 AS A, t1 AS B;
27
28 CREATE TABLE t3 SELECT * FROM t2;
29
30 SELECT COUNT(*) = 5 FROM t1;
31 SELECT COUNT(*) = 25 FROM t2;
32 SELECT COUNT(*) = 25 FROM t3;
33
34 sync_slave_with_master;
35
36 SELECT COUNT(*) = 25 FROM t3;
37
38 connection master;
39 DROP TABLE t1, t2, t3;
40
41 sync_slave_with_master;
42
43 --source include/rpl_end.inc