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