Debian Codegraph @

mysql-test/suite/rpl/r/rpl_binlog_dump_slave_gtid_state_info.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET @org_log_warnings=@@GLOBAL.LOG_WARNINGS;
5 SET GLOBAL LOG_WARNINGS=2;
6 connection slave;
7 include/stop_slave.inc
8 CHANGE MASTER TO MASTER_USE_GTID=slave_pos;
9 include/start_slave.inc
10 connection master;
11 "Test Case 1: Start binlog_dump to slave_server(#), pos(master-bin.000001, ###), using_gtid(1), gtid('')"
12 FOUND 1 /using_gtid\(1\), gtid\(\'\'\).*/ in mysqld.1.err
13 connection slave;
14 include/stop_slave.inc
15 CHANGE MASTER TO MASTER_USE_GTID=no;
16 include/start_slave.inc
17 connection master;
18 "Test Case 2: Start binlog_dump to slave_server(#), pos(master-bin.000001, ###), using_gtid(0), gtid('')"
19 FOUND 1 /using_gtid\(0\), gtid\(\'\'\).*/ in mysqld.1.err
20 CREATE TABLE t (f INT) ENGINE=INNODB;
21 INSERT INTO t VALUES(10);
22 connection slave;
23 connection slave;
24 include/stop_slave.inc
25 CHANGE MASTER TO MASTER_USE_GTID=slave_pos;
26 include/start_slave.inc
27 connection master;
28 "Test Case 3: Start binlog_dump to slave_server(#), pos(master-bin.000001, ###), using_gtid(1), gtid('0-1-2')"
29 FOUND 1 /using_gtid\(1\), gtid\(\'0-1-2\'\).*/ in mysqld.1.err
30 SET @@SESSION.gtid_domain_id=10;
31 INSERT INTO t VALUES(20);
32 connection slave;
33 connection slave;
34 include/stop_slave.inc
35 CHANGE MASTER TO MASTER_USE_GTID=slave_pos;
36 include/start_slave.inc
37 connection master;
38 "Test Case 4: Start binlog_dump to slave_server(#), pos(master-bin.000001, ###), using_gtid(1), gtid('0-1-2,10-1-1')"
39 FOUND 1 /using_gtid\(1\), gtid\(\'0-1-2,10-1-1\'\).*/ in mysqld.1.err
40 "===== Clean up ====="
41 SET GLOBAL LOG_WARNINGS=@org_log_warnings;
42 connection slave;
43 include/stop_slave.inc
44 CHANGE MASTER TO MASTER_USE_GTID=no;
45 include/start_slave.inc
46 connection master;
47 DROP TABLE t;
48 include/rpl_end.inc