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