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, where we neither need
6 # nor do this automatic binlogging. And if we run this test
7 # in row-based, it hangs waiting for an offset which is never
8 # reached (the "sync_with_master 1"), logically.
10 --source include/have_binlog_format_mixed_or_statement.inc
11 source include/master-slave.inc;
12 --sync_slave_with_master
15 create table t2(n int);
16 create temporary table t1 (n int);
17 insert into t1 values(1),(2),(3);
18 insert into t2 select * from t1;
20 create temporary table t1 (n int);
21 insert into t1 values (4),(5);
22 insert into t2 select * from t1 as t10;
26 #add 1 to catch drop table
29 insert into t2 values(6);
33 # same trick to go one more event
36 show status like 'Slave_open_temp_tables';
40 connect (master2,localhost,root,,);
43 # We will get a warning for t1 as this is a temporary table that doesn't
44 # exist in this connection.
46 drop table if exists t1,t2;
47 --sync_slave_with_master
50 --source include/rpl_end.inc