|
1
by brian
clean slate |
1 |
-- source include/have_binlog_format_row.inc
|
2 |
-- source include/master-slave.inc
|
|
3 |
||
4 |
# Bug#12415: DROP of temporary table on master stops slave |
|
5 |
connection master; |
|
6 |
--echo **** On Master ****
|
|
7 |
CREATE TABLE t1 (a int); |
|
8 |
CREATE TABLE t2 (a int); |
|
9 |
CREATE TEMPORARY TABLE t2 (a int, b int); |
|
10 |
SHOW TABLES; |
|
11 |
sync_slave_with_master; |
|
12 |
--echo **** On Slave ****
|
|
13 |
SHOW TABLES; |
|
14 |
connection master; |
|
15 |
--echo **** On Master ****
|
|
16 |
DROP TABLE t2; # Dropping the temporary table |
|
17 |
SHOW TABLES; |
|
18 |
sync_slave_with_master; |
|
19 |
--echo **** On Slave ****
|
|
20 |
SHOW TABLES; # There should be two tables on the slave |
|
21 |
||
22 |
connection master; |
|
23 |
--echo **** On Master ****
|
|
24 |
CREATE TEMPORARY TABLE t2 (a int, b int); |
|
25 |
SHOW TABLES; |
|
26 |
sync_slave_with_master; |
|
27 |
--echo **** On Slave ****
|
|
28 |
SHOW TABLES; |
|
29 |
connection master; |
|
30 |
--echo **** On Master ****
|
|
31 |
# Should drop the non-temporary table t1 and the temporary table t2 |
|
32 |
DROP TABLE t1,t2; |
|
33 |
let $VERSION=`select version()`; |
|
34 |
--replace_result $VERSION VERSION
|
|
35 |
--replace_regex /table_id: [0-9]+/table_id: #/
|
|
36 |
SHOW BINLOG EVENTS; |
|
37 |
SHOW TABLES; |
|
38 |
sync_slave_with_master; |
|
39 |
--echo **** On Slave ****
|
|
40 |
SHOW TABLES; |
|
41 |
||
42 |
--disable_query_log
|
|
43 |
--disable_warnings
|
|
44 |
connection master; |
|
45 |
DROP TABLE IF EXISTS t2; |
|
46 |
sync_slave_with_master; |
|
47 |
--enable_warnings
|
|
48 |
--enable_query_log
|