diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_multi_update2.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_multi_update2.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_multi_update2.result b/mysql-test/suite/rpl/r/rpl_multi_update2.result index 03ed5de473d..74e8622d574 100644 --- a/mysql-test/suite/rpl/r/rpl_multi_update2.result +++ b/mysql-test/suite/rpl/r/rpl_multi_update2.result @@ -30,6 +30,7 @@ SELECT * FROM t2 ORDER BY a; a b 1 0 2 1 +connection slave; SELECT * FROM t1 ORDER BY a; a b 1 4 @@ -38,16 +39,23 @@ SELECT * FROM t2 ORDER BY a; a b 1 0 2 1 +connection master; drop table t1,t2; +connection slave; reset master; +connection master; CREATE TABLE t1 ( a INT ); INSERT INTO t1 VALUES (0); UPDATE t1, (SELECT 3 as b) AS x SET t1.a = x.b; select * from t1; a 3 +connection slave; +connection slave; select * from t1; a 3 +connection master; drop table t1; +connection slave; include/rpl_end.inc |