diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_idempotency.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_idempotency.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_idempotency.result b/mysql-test/suite/rpl/r/rpl_idempotency.result index 38b955d7697..a31657d3ea1 100644 --- a/mysql-test/suite/rpl/r/rpl_idempotency.result +++ b/mysql-test/suite/rpl/r/rpl_idempotency.result @@ -4,14 +4,18 @@ call mtr.add_suppression("Slave SQL.*Can.t find record in .t[12].* error.* 1032" call mtr.add_suppression("Slave SQL.*Cannot delete or update a parent row: a foreign key constraint fails .* error.* 1451"); call mtr.add_suppression("Slave SQL.*Cannot add or update a child row: a foreign key constraint fails .* error.* 1452"); call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.* Duplicate entry .1. for key .PRIMARY.* error.* 1062"); +connection master; CREATE TABLE t1 (a INT PRIMARY KEY); CREATE TABLE t2 (a INT); INSERT INTO t1 VALUES (-1),(-2),(-3); INSERT INTO t2 VALUES (-1),(-2),(-3); +connection slave; SET @old_slave_exec_mode= @@global.slave_exec_mode; SET @@global.slave_exec_mode= IDEMPOTENT; +connection slave; DELETE FROM t1 WHERE a = -2; DELETE FROM t2 WHERE a = -2; +connection master; DELETE FROM t1 WHERE a = -2; DELETE FROM t2 WHERE a = -2; SELECT * FROM t1 ORDER BY a; @@ -22,6 +26,7 @@ SELECT * FROM t2 ORDER BY a; a -3 -1 +connection slave; SELECT * FROM t1 ORDER BY a; a -3 @@ -32,20 +37,24 @@ a -1 include/check_slave_no_error.inc INSERT IGNORE INTO t1 VALUES (-2); +connection master; INSERT IGNORE INTO t1 VALUES (-2); SELECT * FROM t1 ORDER BY a; a -3 -2 -1 +connection slave; SELECT * FROM t1 ORDER BY a; a -3 -2 -1 include/check_slave_no_error.inc +connection slave; UPDATE t1 SET a = 1 WHERE a = -1; UPDATE t2 SET a = 1 WHERE a = -1; +connection master; UPDATE t1 SET a = 1 WHERE a = -1; UPDATE t2 SET a = 1 WHERE a = -1; SELECT * FROM t1 ORDER BY a; @@ -57,6 +66,7 @@ SELECT * FROM t2 ORDER BY a; a -3 1 +connection slave; SELECT * FROM t1 ORDER BY a; a -3 @@ -67,6 +77,8 @@ a -3 1 include/check_slave_no_error.inc +connection master; DROP TABLE t1, t2; +connection slave; SET @@global.slave_exec_mode= @old_slave_exec_mode; include/rpl_end.inc |