1--source include/have_binlog_format_statement.inc
2--source include/master-slave.inc
3
4--echo #
5--echo # Ensure that read-only slave logs temporary table statements under statement based
6--echo # replication. This is related to MDEV-17863.
7--echo #
8
9connection slave;
10set global read_only=1;
11
12connection master;
13
14create table t1(a int) engine=MyISAM;
15create temporary table tmp1 (a int) engine=MyISAM;
16insert into t1 values(1);
17insert into tmp1 values (2);
18insert into t1 select * from tmp1;
19insert into t1 values(3);
20select * from t1;
21analyze table t1;
22drop table t1;
23drop temporary table tmp1;
24
25sync_slave_with_master;
26--source include/show_binlog_events.inc
27set global read_only=0;
28connection master;
29
30--source include/rpl_end.inc
31