diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_nobinlog.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_gtid_nobinlog.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_gtid_nobinlog.result b/mysql-test/suite/rpl/r/rpl_gtid_nobinlog.result index 9aee74d0b46..c42348d40ee 100644 --- a/mysql-test/suite/rpl/r/rpl_gtid_nobinlog.result +++ b/mysql-test/suite/rpl/r/rpl_gtid_nobinlog.result @@ -1,4 +1,5 @@ include/rpl_init.inc [topology=1->2] +connection server_1; SET @old_strict= @@GLOBAL.gtid_strict_mode; SET GLOBAL gtid_strict_mode= 1; select @@global.log_slave_updates; @@ -7,6 +8,7 @@ select @@global.log_slave_updates; CREATE TABLE t1 (a INT PRIMARY KEY, b INT); INSERT INTO t1 VALUES (1, 1); INSERT INTO t1 VALUES (2, 1); +connection server_2; SET @old_strict= @@GLOBAL.gtid_strict_mode; SET GLOBAL gtid_strict_mode= 1; select @@global.log_slave_updates; @@ -17,10 +19,12 @@ a b 1 1 2 1 include/stop_slave.inc +connection server_1; CHANGE MASTER TO master_host = '127.0.0.1', master_port = SLAVE_PORT, master_user = 'root', master_use_gtid = current_pos; START SLAVE; include/wait_for_slave_to_start.inc +connection server_2; INSERT INTO t1 VALUES (3, 2); INSERT INTO t1 VALUES (4, 2); include/save_master_gtid.inc @@ -32,6 +36,7 @@ slave-bin.000001 # Query # # COMMIT slave-bin.000001 # Gtid # # BEGIN GTID #-#-# slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4, 2) slave-bin.000001 # Query # # COMMIT +connection server_1; include/sync_with_master_gtid.inc SELECT * FROM t1 ORDER BY a; a b @@ -44,6 +49,7 @@ RESET SLAVE; INSERT INTO t1 VALUES (5, 1); INSERT INTO t1 VALUES (6, 1); include/save_master_gtid.inc +connection server_2; CHANGE MASTER TO master_host = '127.0.0.1', master_port = MASTER_PORT, master_use_gtid = current_pos; START SLAVE; @@ -57,6 +63,7 @@ a b 5 1 6 1 SET GLOBAL gtid_strict_mode= @old_strict; +connection server_1; SET GLOBAL gtid_strict_mode= @old_strict; DROP TABLE t1; include/rpl_end.inc |