diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_multi_delete2.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_multi_delete2.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_multi_delete2.result b/mysql-test/suite/rpl/r/rpl_multi_delete2.result index c693a43a550..0a316ec3452 100644 --- a/mysql-test/suite/rpl/r/rpl_multi_delete2.result +++ b/mysql-test/suite/rpl/r/rpl_multi_delete2.result @@ -1,9 +1,12 @@ 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); @@ -16,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); @@ -30,12 +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 |