Debian Codegraph @

mysql-test/suite/rpl/r/rpl_reopen_temp_table.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 reset master;
5 #
6 # MDEV-5535: Cannot reopen temporary table
7 #
8 connection master;
9 DROP TABLE IF EXISTS t1, t2, t3;
10 CREATE TEMPORARY TABLE t1(c1 INT) ENGINE=INNODB;
11 INSERT INTO t1 VALUES (1), (2), (3), (4), (5);
12 CREATE TEMPORARY TABLE t2 SELECT A.c1 a, B.c1 b FROM t1 AS A, t1 AS B;
13 CREATE TABLE t3 SELECT * FROM t2;
14 SELECT COUNT(*) = 5 FROM t1;
15 COUNT(*) = 5
16 1
17 SELECT COUNT(*) = 25 FROM t2;
18 COUNT(*) = 25
19 1
20 SELECT COUNT(*) = 25 FROM t3;
21 COUNT(*) = 25
22 1
23 connection slave;
24 SELECT COUNT(*) = 25 FROM t3;
25 COUNT(*) = 25
26 1
27 connection master;
28 DROP TABLE t1, t2, t3;
29 connection slave;
30 include/rpl_end.inc