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