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