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