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