--source include/have_innodb.inc --let $rpl_topology=1->2 --source include/rpl_init.inc --echo *** Test connecting with empty GTID state to start from very beginning of binlog *** --connection server_2 --source include/stop_slave.inc RESET MASTER; RESET SLAVE; SHOW VARIABLES LIKE 'gtid_binlog_pos'; SHOW VARIABLES LIKE 'gtid_current_pos'; SHOW VARIABLES LIKE 'gtid_slave_pos'; SHOW VARIABLES LIKE 'gtid_binlog_state'; --connection server_1 RESET MASTER; FLUSH LOGS; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB; SET @@SESSION.gtid_domain_id=1; INSERT INTO t1 VALUES(1); SET @@SESSION.gtid_domain_id=99999; INSERT INTO t1 VALUES(3); SET @@SESSION.gtid_domain_id=10; INSERT INTO t1 VALUES(4); SET @@SESSION.gtid_domain_id=100; INSERT INTO t1 VALUES(5); SET @@SESSION.gtid_domain_id=2147483648; # 0x80000000 INSERT INTO t1 VALUES(6); SET @@SESSION.gtid_domain_id=4294967295; # 0xFFFFFFFF INSERT INTO t1 VALUES(7); SHOW VARIABLES LIKE 'gtid_binlog_pos'; SHOW VARIABLES LIKE 'gtid_current_pos'; SHOW VARIABLES LIKE 'gtid_slave_pos'; SHOW VARIABLES LIKE 'gtid_binlog_state'; --save_master_pos --connection server_2 SHOW VARIABLES LIKE 'gtid_binlog_pos'; SHOW VARIABLES LIKE 'gtid_current_pos'; SHOW VARIABLES LIKE 'gtid_slave_pos'; SHOW VARIABLES LIKE 'gtid_binlog_state'; --replace_result $MASTER_MYPORT MASTER_PORT eval CHANGE MASTER TO master_host = '127.0.0.1', master_port = $MASTER_MYPORT, MASTER_USE_GTID=SLAVE_POS; --source include/start_slave.inc --sync_with_master SHOW VARIABLES LIKE 'gtid_binlog_pos'; SHOW VARIABLES LIKE 'gtid_current_pos'; SHOW VARIABLES LIKE 'gtid_slave_pos'; SHOW VARIABLES LIKE 'gtid_binlog_state'; SELECT * FROM t1; SET @@SESSION.gtid_domain_id=1000; INSERT INTO t1 VALUES(8); SET @@SESSION.gtid_domain_id=89; INSERT INTO t1 VALUES(9); SET @@SESSION.gtid_domain_id=10100000; INSERT INTO t1 VALUES(10); SHOW VARIABLES LIKE 'gtid_binlog_pos'; SHOW VARIABLES LIKE 'gtid_current_pos'; SHOW VARIABLES LIKE 'gtid_slave_pos'; SHOW VARIABLES LIKE 'gtid_binlog_state'; # Clean up. --connection server_1 DROP TABLE t1; --source include/rpl_end.inc