Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 create database if not exists mysqltest;
4 connect con_temp,127.0.0.1,root,,test,$MASTER_MYPORT,;
5 connection con_temp;
6 use mysqltest;
7 create temporary table mysqltest.t1 (n int)ENGINE=MyISAM;
8 create temporary table mysqltest.t2 (n int)ENGINE=MyISAM;
9 disconnect con_temp;
10 connection master;
11 connection slave;
12 connection slave;
13 show status like 'Slave_open_temp_tables';
14 Variable_name Value
15 Slave_open_temp_tables 0
16 connection master;
17 drop database mysqltest;
18 connection slave;
19 connection master;
20 DROP TEMPORARY TABLE IF EXISTS tmp1;
21 Warnings:
22 Note 1051 Unknown table 'test.tmp1'
23 CREATE TEMPORARY TABLE t1 ( a int );
24 DROP TEMPORARY TABLE t1, t2;
25 ERROR 42S02: Unknown table 'test.t2'
26 DROP TEMPORARY TABLE tmp2;
27 ERROR 42S02: Unknown table 'test.tmp2'
28 connection slave;
29 connection slave;
30 stop slave;
31 connection master;
32 CREATE TEMPORARY TABLE tmp3 (a int);
33 DROP TEMPORARY TABLE tmp3;
34 connection slave;
35 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
36 START SLAVE;
37 connection master;
38 connection slave;
39 include/rpl_reset.inc
40 connection master;
41 CREATE TABLE t1 ( i INT );
42 connection slave;
43 SHOW STATUS LIKE 'Slave_open_temp_tables';
44 Variable_name Value
45 Slave_open_temp_tables 0
46 connect con1,localhost,root,,;
47 CREATE TEMPORARY TABLE ttmp1 ( i INT );
48 SET SESSION binlog_format=ROW;
49 disconnect con1;
50 connection master;
51 connection slave;
52 SHOW STATUS LIKE 'Slave_open_temp_tables';
53 Variable_name Value
54 Slave_open_temp_tables 0
55 connection master;
56 include/show_binlog_events.inc
57 Log_name Pos Event_type Server_id End_log_pos Info
58 master-bin.000001 # Gtid # # GTID #-#-#
59 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 ( i INT )
60 master-bin.000001 # Gtid # # GTID #-#-#
61 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE ttmp1 ( i INT )
62 master-bin.000001 # Gtid # # GTID #-#-#
63 master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `ttmp1`
64 DROP TABLE t1;
65 include/rpl_end.inc