mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
38 lines
954 B
Text
38 lines
954 B
Text
-- source include/have_binlog_format_row.inc
|
|
-- source include/master-slave.inc
|
|
|
|
# Bug#12415: DROP of temporary table on master stops slave
|
|
connection master;
|
|
CREATE TABLE t1 (a int);
|
|
CREATE TABLE t2 (a int);
|
|
CREATE TEMPORARY TABLE t2 (a int, b int);
|
|
SHOW TABLES;
|
|
sync_slave_with_master;
|
|
SHOW TABLES;
|
|
connection master;
|
|
DROP TABLE t2; # Dropping the temporary table
|
|
SHOW TABLES;
|
|
sync_slave_with_master;
|
|
SHOW TABLES; # There should be two tables on the slave
|
|
|
|
connection master;
|
|
CREATE TEMPORARY TABLE t2 (a int, b int);
|
|
SHOW TABLES;
|
|
sync_slave_with_master;
|
|
SHOW TABLES;
|
|
connection master;
|
|
# Should drop the non-temporary table t1 and the temporary table t2
|
|
DROP TABLE t1,t2;
|
|
source include/show_binlog_events.inc;
|
|
SHOW TABLES;
|
|
sync_slave_with_master;
|
|
SHOW TABLES;
|
|
|
|
--disable_query_log
|
|
--disable_warnings
|
|
connection master;
|
|
DROP TABLE IF EXISTS t2;
|
|
sync_slave_with_master;
|
|
--enable_warnings
|
|
--enable_query_log
|
|
--source include/rpl_end.inc
|