Debian Codegraph @

mysql-test/suite/rpl/r/rpl_read_only2.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # Ensure that read-only slave logs temporary table statements under statement based
5 # replication. This is related to MDEV-17863.
6 #
7 connection slave;
8 set global read_only=1;
9 connection master;
10 create table t1(a int) engine=MyISAM;
11 create temporary table tmp1 (a int) engine=MyISAM;
12 insert into t1 values(1);
13 insert into tmp1 values (2);
14 insert into t1 select * from tmp1;
15 insert into t1 values(3);
16 select * from t1;
17 a
18 1
19 2
20 3
21 analyze table t1;
22 Table Op Msg_type Msg_text
23 test.t1 analyze status Engine-independent statistics collected
24 test.t1 analyze status OK
25 drop table t1;
26 drop temporary table tmp1;
27 connection slave;
28 include/show_binlog_events.inc
29 Log_name Pos Event_type Server_id End_log_pos Info
30 slave-bin.000001 # Gtid # # GTID #-#-#
31 slave-bin.000001 # Query # # use `test`; create table t1(a int) engine=MyISAM
32 slave-bin.000001 # Gtid # # GTID #-#-#
33 slave-bin.000001 # Query # # use `test`; create temporary table tmp1 (a int) engine=MyISAM
34 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
35 slave-bin.000001 # Query # # use `test`; insert into t1 values(1)
36 slave-bin.000001 # Query # # COMMIT
37 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
38 slave-bin.000001 # Query # # use `test`; insert into tmp1 values (2)
39 slave-bin.000001 # Query # # COMMIT
40 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
41 slave-bin.000001 # Query # # use `test`; insert into t1 select * from tmp1
42 slave-bin.000001 # Query # # COMMIT
43 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
44 slave-bin.000001 # Query # # use `test`; insert into t1 values(3)
45 slave-bin.000001 # Query # # COMMIT
46 slave-bin.000001 # Gtid # # GTID #-#-#
47 slave-bin.000001 # Query # # use `test`; analyze table t1
48 slave-bin.000001 # Gtid # # GTID #-#-#
49 slave-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
50 slave-bin.000001 # Gtid # # GTID #-#-#
51 slave-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tmp1` /* generated by server */
52 set global read_only=0;
53 connection master;
54 include/rpl_end.inc