Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 SET GLOBAL read_only=1;
5 connection master;
6 CREATE PROCEDURE testproc()
7 BEGIN
8 DROP TEMPORARY TABLE IF EXISTS t1_tmp;
9 DROP TEMPORARY TABLE IF EXISTS t2_tmp;
10 CREATE TEMPORARY TABLE IF NOT EXISTS t1_tmp ( t1 varchar(400) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11 CREATE TEMPORARY TABLE IF NOT EXISTS t2_tmp ( t2 varchar(16) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12 END|
13 SET GLOBAL read_only=1;
14 CALL testproc();
15 ******** None of the above DROP TEMPORARY TABLE statement should be found in binary log ********
16 include/show_binlog_events.inc
17 Log_name Pos Event_type Server_id End_log_pos Info
18 master-bin.000001 # Gtid # # GTID #-#-#
19 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `testproc`()
20 BEGIN
21 DROP TEMPORARY TABLE IF EXISTS t1_tmp;
22 DROP TEMPORARY TABLE IF EXISTS t2_tmp;
23 CREATE TEMPORARY TABLE IF NOT EXISTS t1_tmp ( t1 varchar(400) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
24 CREATE TEMPORARY TABLE IF NOT EXISTS t2_tmp ( t2 varchar(16) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25 END
26 connection slave;
27 SELECT @@read_only;
28 @@read_only
29 1
30 ======== CLEAN UP =========
31 connection master;
32 DROP TEMPORARY TABLE t1_tmp;
33 DROP TEMPORARY TABLE t2_tmp;
34 DROP PROCEDURE testproc;
35 SET GLOBAL read_only=0;
36 connection slave;
37 SET GLOBAL read_only=0;
38 include/rpl_end.inc