Debian Codegraph @

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

raw
1 # This test is to verify that DROP TEMPORARY TABLE
2 # is automatically binlogged and sent to slave
3 # when a temp table is dropped by disconnection
4 # of a master's conection.
5 # So it does not apply to row-based and mix-based, where we neither need
6 # nor do this automatic binlogging. And if we run this test
7 # in row-based or mix-based, it hangs waiting for an offset which is never
8 # reached (the "sync_with_master 1"), logically.
9
10 --source include/have_binlog_format_statement.inc
11 source include/master-slave.inc;
12
13 --disable_query_log
14 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
15 --enable_query_log
16
17 create table t2(n int);
18 create temporary table t1 (n int);
19 insert into t1 values(1),(2),(3);
20 --disable_warnings
21 insert into t2 select * from t1;
22 --enable_warnings
23 connection master1;
24 create temporary table t1 (n int);
25 insert into t1 values (4),(5);
26 --disable_warnings
27 insert into t2 select * from t1 as t10;
28 --enable_warnings
29 save_master_pos;
30 disconnect master;
31 connection slave;
32 #add 1 to catch drop table
33 sync_with_master 1;
34 connection master1;
35 insert into t2 values(6);
36 save_master_pos;
37 disconnect master1;
38 connection slave;
39 # same trick to go one more event
40 sync_with_master 1;
41 select * from t2;
42 show status like 'Replica_open_temp_tables';
43 #
44 # Clean up
45 #
46 connect (master2,localhost,root,,);
47 connection master2;
48
49 # We will get a warning for t1 as this is a temporary table that doesn't
50 # exist in this connection.
51
52 drop table if exists t1,t2;
53
54 --source include/rpl_end.inc
55 # End of 4.1 tests