diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result b/mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result index 8e6a6a3d4d0..0a316ec3452 100644 --- a/mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result +++ b/mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result @@ -1,13 +1,12 @@ -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; +include/master-slave.inc +[connection master] +connection master; set sql_log_bin=0; create database mysqltest_from; set sql_log_bin=1; +connection slave; create database mysqltest_to; +connection master; use mysqltest_from; drop table if exists a; CREATE TABLE a (i INT); @@ -20,10 +19,12 @@ delete alias FROM a alias where alias.i=2; select * from a; i 3 +connection slave; use mysqltest_to; select * from a; i 3 +connection master; create table t1 (a int primary key); create table t2 (a int); insert into t1 values (1); @@ -34,11 +35,15 @@ a select * from t2; a 1 +connection slave; select * from t1; ERROR 42S02: Table 'mysqltest_to.t1' doesn't exist select * from t2; ERROR 42S02: Table 'mysqltest_to.t2' doesn't exist +connection master; set sql_log_bin=0; drop database mysqltest_from; set sql_log_bin=1; +connection slave; drop database mysqltest_to; +include/rpl_end.inc |