Debian Codegraph @

mysql-test/suite/rpl/t/rpl_read_only2.test

raw
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
9 connection slave;
10 set global read_only=1;
11
12 connection master;
13
14 create table t1(a int) engine=MyISAM;
15 create temporary table tmp1 (a int) engine=MyISAM;
16 insert into t1 values(1);
17 insert into tmp1 values (2);
18 insert into t1 select * from tmp1;
19 insert into t1 values(3);
20 select * from t1;
21 analyze table t1;
22 drop table t1;
23 drop temporary table tmp1;
24
25 sync_slave_with_master;
26 --source include/show_binlog_events.inc
27 set global read_only=0;
28 connection master;
29
30 --source include/rpl_end.inc