Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_do_server_ids.result

raw
1 ###############################
2 # Test Setup
3 ###############################
4 set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22");
5 SET timestamp=@a;
6 RESET MASTER;
7 SET @@session.gtid_domain_id= 0;
8 SET @@session.server_id= 1;
9 CREATE TABLE t1 (a int);
10 SET @@session.server_id= 2;
11 CREATE TABLE t2 (a int);
12 INSERT INTO t2 values (3);
13 SET @@session.gtid_domain_id= 1;
14 SET @@session.server_id= 1;
15 CREATE TABLE t3 (a int);
16 INSERT INTO t3 values (4);
17 SET @@session.server_id= 3;
18 SET timestamp=@a+1;
19 CREATE TABLE t4 (a int);
20 SET timestamp=@a+2;
21 INSERT INTO t4 values (5);
22 SET @@session.gtid_domain_id= 0;
23 SET @@session.server_id= 1;
24 INSERT INTO t1 values (1);
25 SET @@session.gtid_domain_id= 2;
26 SET @@session.server_id= 1;
27 CREATE TABLE t5 (a int);
28 INSERT INTO t5 values (6);
29 SET @@session.gtid_domain_id= 0;
30 SET @@session.server_id= 1;
31 INSERT INTO t1 values (2);
32 FLUSH LOGS;
33 SET @@session.gtid_domain_id= 0;
34 SET @@session.server_id= 2;
35 CREATE TABLE t6 (a int);
36 INSERT INTO t6 values (1);
37 FLUSH LOGS;
38 DROP TABLE t1;
39 DROP TABLE t2;
40 DROP TABLE t3;
41 DROP TABLE t4;
42 DROP TABLE t5;
43 DROP TABLE t6;
44 RESET MASTER;
45 ###############################
46 # Test Cases
47 ###############################
48 #
49 # Test Case 1) --do-server-ids with a single server id limits output
50 # to that single server
51 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=2 | MYSQL
52 DROP TABLE t2;
53 #
54 # Test Case 2) --do-server-ids with multiple server ids limits output
55 # to the provided servers
56 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=2,3 | MYSQL
57 DROP TABLE t2;
58 DROP TABLE t4;
59 #
60 # Test Case 3) --do-server-ids when combined with --do-domain-ids should
61 # intersect the results
62 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --do-domain-ids=0 | MYSQL
63 DROP TABLE t1;
64 #
65 # Test Case 4) --do-server-ids when combined with --ignore-domain-ids should
66 # intersect the results
67 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --ignore-domain-ids=0 | MYSQL
68 DROP TABLE t3;
69 DROP TABLE t5;
70 #
71 # Test Case 5) --do-server-ids when combined with a GTID range should
72 # intersect the results
73 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --stop-position=0-1-4 | MYSQL
74 DROP TABLE t1;
75 #
76 # Test Case 6) --do-server-ids when combined with both --ignore-domain-ids
77 # and a GTID range should intersect all results
78 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --ignore-domain-ids=0 --start-position=1-1-0 | MYSQL
79 DROP TABLE t3;
80 DROP TABLE t5;
81 #
82 # Test Case 7) --do-server-ids when combined with both --do-domain-ids and
83 # a GTID range should intersect all results
84 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=2 --do-domain-ids=0 --start-position=0-1-0 | MYSQL
85 DROP TABLE t2;
86 #
87 # Test Case 8) --do-server-ids and --offset=<n> skips n events after the
88 # first GTID is found
89 CREATE TABLE t4 (a int);
90 # MYSQL_BINLOG BINLOG_FILE_PARAM --offset=5 --do-server-ids=3 --do-domain-ids=1 | MYSQL
91 DROP TABLE t4;
92 #
93 # Test Case 9) --do-server-ids with --start-datetime=<T> where T occurs
94 # after the first GTID is found results in no events before T
95 CREATE TABLE t4 (a int);
96 # MYSQL_BINLOG BINLOG_FILE_PARAM --start-datetime="1970-01-21 15:32:24" --do-server-ids=3 --do-domain-ids=1 | MYSQL
97 DROP TABLE t4;
98 #
99 # Test Case 10) --do-server-ids works with --read-from-remote-server
100 # Setup test specific data
101 RESET MASTER;
102 SET @@session.gtid_domain_id= 0;
103 SET @@session.server_id= 1;
104 CREATE TABLE t1 (a int);
105 INSERT INTO t1 VALUES (1);
106 SET @@session.server_id= 2;
107 CREATE TABLE t2 (a int);
108 INSERT INTO t2 VALUES (1);
109 SET @@session.server_id= 1;
110 DROP TABLE t1;
111 DROP TABLE t2;
112 # MYSQL_BINLOG BINLOG_FILENAME --read-from-remote-server --do-server-ids=2 | MYSQL
113 DROP TABLE t2;
114 #
115 # Test Case 11) --do-server-ids works over multiple binary log input
116 # files
117 # MYSQL_BINLOG BINLOG_FILE_PARAM BINLOG_FILE_PARAM2 --do-server-ids=2 | MYSQL
118 DROP TABLE t2;
119 DROP TABLE t6;
120 #
121 # Test Case 12) --do-server-ids re-specifications should override
122 # previous ones
123 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --do-server-ids=2 | MYSQL
124 DROP TABLE t2;
125 #
126 # Test Case 13) --do-server-ids and --server-id should be aliases and
127 # a re-specification of one should override the former
128 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --server-id=2 | MYSQL
129 DROP TABLE t2;
130 #
131 # Test Case 14) --ignore-server-ids re-specifications should override
132 # previous ones
133 # MYSQL_BINLOG BINLOG_FILE_PARAM --ignore-server-ids=2 --ignore-server-ids=1,3 | MYSQL
134 DROP TABLE t2;
135 #
136 # Test Case 15) --do-domain-ids re-specifications should override
137 # previous ones
138 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-domain-ids=1 --do-domain-ids=0 | MYSQL
139 DROP TABLE t1,t2;
140 #
141 # Test Case 16) --ignore-domain-ids re-specifications should override
142 # previous ones
143 # MYSQL_BINLOG BINLOG_FILE_PARAM --ignore-domain-ids=0 --ignore-domain-ids=1,2 | MYSQL
144 DROP TABLE t1,t2;
145 ##############################
146 # Error Cases
147 ##############################
148 #
149 # Error Case 1:
150 # --ignore-server-ids and --do-server-ids both specified
151 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=1 --ignore-server-ids=2
152 #
153 # Error Case 2:
154 # Invalid server ID number provided
155 # MYSQL_BINLOG BINLOG_FILE_PARAM --do-server-ids=-1
156 ##############################
157 # Cleanup
158 ##############################
159 SET @@global.gtid_domain_id= 0;
160 SET @@global.server_id= 1;
161 # End of tests