rpl_drop_temp.test 551 Bytes
Newer Older
1 2 3 4 5
source include/master-slave.inc;
--disable_warnings
create database if not exists mysqltest;
--enable_warnings

6 7 8 9
connect (con_temp,127.0.0.1,root,,test,$MASTER_MYPORT,);

connection con_temp;
use mysqltest;
10 11
create temporary table mysqltest.t1 (n int);
create temporary table mysqltest.t2 (n int);
12 13
select get_lock("con_temp",10);

14
connection master;
15 16 17 18
disconnect con_temp;
select get_lock("con_temp",10);
sync_slave_with_master;

19 20
connection slave;
show status like 'Slave_open_temp_tables';
21
connection master;
unknown's avatar
unknown committed
22 23
drop database mysqltest;

24
# End of 4.1 tests