EVOLUTION-MANAGER

Edit File: rpl_reopen_temp_table.result

include/master-slave.inc [connection master] connection slave; reset master; # # MDEV-5535: Cannot reopen temporary table # connection master; DROP TABLE IF EXISTS t1, t2, t3; CREATE TEMPORARY TABLE t1(c1 INT) ENGINE=INNODB; INSERT INTO t1 VALUES (1), (2), (3), (4), (5); CREATE TEMPORARY TABLE t2 SELECT A.c1 a, B.c1 b FROM t1 AS A, t1 AS B; CREATE TABLE t3 SELECT * FROM t2; SELECT COUNT(*) = 5 FROM t1; COUNT(*) = 5 1 SELECT COUNT(*) = 25 FROM t2; COUNT(*) = 25 1 SELECT COUNT(*) = 25 FROM t3; COUNT(*) = 25 1 connection slave; SELECT COUNT(*) = 25 FROM t3; COUNT(*) = 25 1 connection master; DROP TABLE t1, t2, t3; connection slave; include/rpl_end.inc