Debian Codegraph @

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

raw
1 # Populate the active connection server with events that come from varying
2 # domain and server ids
3
4 --disable_query_log
5
6 # Save old state
7 let $ORIG_GTID_DOMAIN_ID = `select @@session.gtid_domain_id`;
8 let $ORIG_SERVER_ID = `select @@session.server_id`;
9
10 SET @@session.gtid_domain_id= 0;
11 SET @@session.server_id= 1;
12 CREATE TABLE t1 (a int);
13
14 SET @@session.server_id= 3;
15 CREATE TABLE t2 (a int);
16 INSERT INTO t2 values (3);
17
18 SET @@session.gtid_domain_id= 1;
19 SET @@session.server_id= 1;
20 CREATE TABLE t3 (a int);
21 INSERT INTO t3 values (4);
22
23 SET @@session.server_id= 4;
24 CREATE TABLE t4 (a int);
25 INSERT INTO t4 values (5);
26
27 SET @@session.gtid_domain_id= 0;
28 SET @@session.server_id= 1;
29 INSERT INTO t1 values (1);
30
31 SET @@session.gtid_domain_id= 2;
32 SET @@session.server_id= 1;
33 CREATE TABLE t5 (a int);
34 INSERT INTO t5 values (6);
35
36 SET @@session.gtid_domain_id= 0;
37 SET @@session.server_id= 1;
38 INSERT INTO t1 values (2);
39
40 FLUSH LOGS;
41
42 --eval SET @@session.gtid_domain_id= $ORIG_GTID_DOMAIN_ID
43 --eval SET @@session.server_id= $ORIG_SERVER_ID
44
45 --enable_query_log