diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result b/mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result index 129b944d840..6f8f2cf89d1 100644 --- a/mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result +++ b/mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result @@ -1,7 +1,9 @@ include/master-slave.inc [connection master] CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); +connection slave; CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); +connection master; CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY); CREATE TABLE t2 (id INT AUTO_INCREMENT PRIMARY KEY); CREATE PROCEDURE p1() @@ -106,7 +108,7 @@ id 10 SELECT * FROM t2; id -# Result on slave +connection slave; SELECT * FROM t1; id 3 @@ -119,6 +121,7 @@ id 10 SELECT * FROM t2; id +connection master; DROP TRIGGER tr1; CALL p2(); Warnings: @@ -170,7 +173,7 @@ id 17 18 19 -# Result on slave +connection slave; SELECT * FROM t1; id 5 @@ -197,9 +200,11 @@ id 17 18 19 +connection master; DROP TABLE IF EXISTS t1, t2; DROP PROCEDURE IF EXISTS p1; DROP PROCEDURE IF EXISTS p2; DROP FUNCTION IF EXISTS f1; DROP TRIGGER IF EXISTS tr1; +connection slave; include/rpl_end.inc |