Debian Codegraph @

mysql-test/suite/rpl/include/sql_out_of_order_gtid.inc

raw
1 # SQL file with out of order GTIDs coming from various domains and servers
2
3 --disable_query_log
4
5 # Save old state
6 let $ORIG_GTID_DOMAIN_ID = `select @@session.gtid_domain_id`;
7 let $ORIG_SERVER_ID = `select @@session.server_id`;
8
9 SET @@session.gtid_domain_id= 0;
10 SET @@session.server_id= 1;
11 CREATE TABLE t1 (a int);
12 INSERT INTO t1 values (1);
13
14 SET @@session.server_id= 3;
15 CREATE TABLE t2 (a int);
16 SET @@session.gtid_seq_no= 6;
17 INSERT INTO t2 values (2);
18 SET @@session.gtid_seq_no= 5;
19 INSERT INTO t2 values (1);
20 SET @@session.gtid_seq_no= 7;
21 INSERT INTO t2 values (3);
22
23 SET @@session.gtid_domain_id= 1;
24 SET @@session.server_id= 1;
25 CREATE TABLE t3 (a int);
26 INSERT INTO t3 values (1);
27 SET @@session.gtid_seq_no= 4;
28 INSERT INTO t3 values (3);
29 SET @@session.gtid_seq_no= 3;
30 INSERT INTO t3 values (2);
31 SET @@session.gtid_seq_no= 5;
32 INSERT INTO t3 values (4);
33
34 SET @@session.gtid_domain_id= 0;
35 SET @@session.server_id= 1;
36 INSERT INTO t1 values (2);
37
38 FLUSH LOGS;
39
40 --eval SET @@session.gtid_domain_id= $ORIG_GTID_DOMAIN_ID
41 --eval SET @@session.server_id= $ORIG_SERVER_ID
42
43 --enable_query_log