Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 set session default_storage_engine=innodb;
4 #########################################################################
5 # CONFIGURATION
6 #########################################################################
7 connection master;
8 CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb;
9 CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb;
10 CREATE TABLE nt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = MyIsam;
11 INSERT INTO tt_1(ddl_case) VALUES(0);
12 INSERT INTO tt_2(ddl_case) VALUES(0);
13 #########################################################################
14 # CHECK IMPLICT COMMIT
15 #########################################################################
16 SET AUTOCOMMIT= 0;
17 INSERT INTO tt_1(ddl_case) VALUES (43);
18 CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "UDF_EXAMPLE_LIB";
19 INSERT INTO tt_1(ddl_case) VALUES (42);
20 DROP FUNCTION myfunc_int;
21 INSERT INTO tt_1(ddl_case) VALUES (41);
22 LOAD INDEX INTO CACHE nt_1 IGNORE LEAVES;
23 Table Op Msg_type Msg_text
24 test.nt_1 preload_keys status OK
25 INSERT INTO tt_1(ddl_case) VALUES (40);
26 LOAD INDEX INTO CACHE tt_1, tt_2 IGNORE LEAVES;
27 Table Op Msg_type Msg_text
28 test.tt_1 preload_keys note The storage engine for the table doesn't support preload_keys
29 test.tt_2 preload_keys note The storage engine for the table doesn't support preload_keys
30 INSERT INTO tt_1(ddl_case) VALUES (39);
31 ANALYZE TABLE nt_1;
32 Table Op Msg_type Msg_text
33 test.nt_1 analyze status Engine-independent statistics collected
34 test.nt_1 analyze status Table is already up to date
35 INSERT INTO tt_1(ddl_case) VALUES (38);
36 CHECK TABLE nt_1;
37 Table Op Msg_type Msg_text
38 test.nt_1 check status OK
39 INSERT INTO tt_1(ddl_case) VALUES (37);
40 OPTIMIZE TABLE nt_1;
41 Table Op Msg_type Msg_text
42 test.nt_1 optimize status Table is already up to date
43 INSERT INTO tt_1(ddl_case) VALUES (36);
44 REPAIR TABLE nt_1;
45 Table Op Msg_type Msg_text
46 test.nt_1 repair status OK
47 INSERT INTO tt_1(ddl_case) VALUES (35);
48 LOCK TABLES tt_1 WRITE;
49 INSERT INTO tt_1(ddl_case) VALUES (34);
50 UNLOCK TABLES;
51 INSERT INTO tt_1(ddl_case) VALUES (33);
52 CREATE USER 'user'@'localhost';
53 INSERT INTO tt_1(ddl_case) VALUES (32);
54 GRANT ALL ON *.* TO 'user'@'localhost';
55 INSERT INTO tt_1(ddl_case) VALUES (31);
56 SET PASSWORD FOR 'user'@'localhost' = PASSWORD('newpass');
57 INSERT INTO tt_1(ddl_case) VALUES (30);
58 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost';
59 INSERT INTO tt_1(ddl_case) VALUES (29);
60 RENAME USER 'user'@'localhost' TO 'user_new'@'localhost';
61 INSERT INTO tt_1(ddl_case) VALUES (28);
62 DROP USER 'user_new'@'localhost';
63 INSERT INTO tt_1(ddl_case) VALUES (27);
64 CREATE EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1;
65 Warnings:
66 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
67 INSERT INTO tt_1(ddl_case) VALUES (26);
68 ALTER EVENT evt COMMENT 'evt';
69 INSERT INTO tt_1(ddl_case) VALUES (25);
70 DROP EVENT evt;
71 INSERT INTO tt_1(ddl_case) VALUES (24);
72 CREATE TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
73 INSERT INTO tt_1(ddl_case) VALUES (23);
74 DROP TRIGGER tr;
75 INSERT INTO tt_1(ddl_case) VALUES (22);
76 CREATE FUNCTION fc () RETURNS VARCHAR(64) RETURN "fc";
77 INSERT INTO tt_1(ddl_case) VALUES (21);
78 ALTER FUNCTION fc COMMENT 'fc';
79 INSERT INTO tt_1(ddl_case) VALUES (20);
80 DROP FUNCTION fc;
81 INSERT INTO tt_1(ddl_case) VALUES (19);
82 CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
83 INSERT INTO tt_1(ddl_case) VALUES (18);
84 ALTER PROCEDURE pc COMMENT 'pc';
85 INSERT INTO tt_1(ddl_case) VALUES (17);
86 DROP PROCEDURE pc;
87 INSERT INTO tt_1(ddl_case) VALUES (16);
88 CREATE VIEW v AS SELECT * FROM tt_1;
89 INSERT INTO tt_1(ddl_case) VALUES (15);
90 ALTER VIEW v AS SELECT * FROM tt_1;
91 INSERT INTO tt_1(ddl_case) VALUES (14);
92 DROP VIEW v;
93 INSERT INTO tt_1(ddl_case) VALUES (13);
94 CREATE INDEX ix ON tt_1(ddl_case);
95 INSERT INTO tt_1(ddl_case) VALUES (12);
96 DROP INDEX ix ON tt_1;
97 INSERT INTO tt_1(ddl_case) VALUES (11);
98 CREATE TEMPORARY TABLE tt_xx (a int);
99 INSERT INTO tt_1(ddl_case) VALUES (10);
100 ALTER TABLE tt_xx ADD COLUMN (b int);
101 INSERT INTO tt_1(ddl_case) VALUES (9);
102 ALTER TABLE tt_xx RENAME new_tt_xx;
103 INSERT INTO tt_1(ddl_case) VALUES (8);
104 DROP TEMPORARY TABLE IF EXISTS new_tt_xx;
105 INSERT INTO tt_1(ddl_case) VALUES (7);
106 CREATE TABLE tt_xx (a int);
107 INSERT INTO tt_1(ddl_case) VALUES (6);
108 ALTER TABLE tt_xx ADD COLUMN (b int);
109 INSERT INTO tt_1(ddl_case) VALUES (5);
110 RENAME TABLE tt_xx TO new_tt_xx;
111 INSERT INTO tt_1(ddl_case) VALUES (4);
112 TRUNCATE TABLE new_tt_xx;
113 INSERT INTO tt_1(ddl_case) VALUES (3);
114 DROP TABLE IF EXISTS tt_xx, new_tt_xx;
115 Warnings:
116 Note 1051 Unknown table 'test.tt_xx'
117 INSERT INTO tt_1(ddl_case) VALUES (2);
118 CREATE DATABASE db;
119 INSERT INTO tt_1(ddl_case) VALUES (1);
120 DROP DATABASE IF EXISTS db;
121 include/show_binlog_events.inc
122 Log_name Pos Event_type Server_id End_log_pos Info
123 master-bin.000001 # Gtid # # GTID #-#-#
124 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb
125 master-bin.000001 # Gtid # # GTID #-#-#
126 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb
127 master-bin.000001 # Gtid # # GTID #-#-#
128 master-bin.000001 # Query # # use `test`; CREATE TABLE nt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = MyIsam
129 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
130 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES(0)
131 master-bin.000001 # Xid # # COMMIT /* XID */
132 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
133 master-bin.000001 # Query # # use `test`; INSERT INTO tt_2(ddl_case) VALUES(0)
134 master-bin.000001 # Xid # # COMMIT /* XID */
135 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
136 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (43)
137 master-bin.000001 # Xid # # COMMIT /* XID */
138 master-bin.000001 # Gtid # # GTID #-#-#
139 master-bin.000001 # Query # # use `test`; CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "LIB"
140 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
141 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (42)
142 master-bin.000001 # Xid # # COMMIT /* XID */
143 master-bin.000001 # Gtid # # GTID #-#-#
144 master-bin.000001 # Query # # use `test`; DROP FUNCTION myfunc_int
145 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
146 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (41)
147 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (40)
148 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (39)
149 master-bin.000001 # Xid # # COMMIT /* XID */
150 master-bin.000001 # Gtid # # GTID #-#-#
151 master-bin.000001 # Query # # use `test`; ANALYZE TABLE nt_1
152 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
153 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (38)
154 master-bin.000001 # Xid # # COMMIT /* XID */
155 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
156 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (37)
157 master-bin.000001 # Xid # # COMMIT /* XID */
158 master-bin.000001 # Gtid # # GTID #-#-#
159 master-bin.000001 # Query # # use `test`; OPTIMIZE TABLE nt_1
160 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
161 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (36)
162 master-bin.000001 # Xid # # COMMIT /* XID */
163 master-bin.000001 # Gtid # # GTID #-#-#
164 master-bin.000001 # Query # # use `test`; REPAIR TABLE nt_1
165 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
166 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (35)
167 master-bin.000001 # Xid # # COMMIT /* XID */
168 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
169 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (34)
170 master-bin.000001 # Xid # # COMMIT /* XID */
171 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
172 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (33)
173 master-bin.000001 # Xid # # COMMIT /* XID */
174 master-bin.000001 # Gtid # # GTID #-#-#
175 master-bin.000001 # Query # # use `test`; CREATE USER 'user'@'localhost'
176 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
177 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (32)
178 master-bin.000001 # Xid # # COMMIT /* XID */
179 master-bin.000001 # Gtid # # GTID #-#-#
180 master-bin.000001 # Query # # use `test`; GRANT ALL ON *.* TO 'user'@'localhost'
181 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
182 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (31)
183 master-bin.000001 # Xid # # COMMIT /* XID */
184 master-bin.000001 # Gtid # # GTID #-#-#
185 master-bin.000001 # Query # # use `test`; SET PASSWORD FOR 'user'@'localhost'='*D8DECEC305209EEFEC43008E1D420E1AA06B19E0'
186 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
187 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (30)
188 master-bin.000001 # Xid # # COMMIT /* XID */
189 master-bin.000001 # Gtid # # GTID #-#-#
190 master-bin.000001 # Query # # use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost'
191 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
192 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (29)
193 master-bin.000001 # Xid # # COMMIT /* XID */
194 master-bin.000001 # Gtid # # GTID #-#-#
195 master-bin.000001 # Query # # use `test`; RENAME USER 'user'@'localhost' TO 'user_new'@'localhost'
196 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
197 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (28)
198 master-bin.000001 # Xid # # COMMIT /* XID */
199 master-bin.000001 # Gtid # # GTID #-#-#
200 master-bin.000001 # Query # # use `test`; DROP USER 'user_new'@'localhost'
201 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
202 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (27)
203 master-bin.000001 # Xid # # COMMIT /* XID */
204 master-bin.000001 # Gtid # # GTID #-#-#
205 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1
206 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
207 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (26)
208 master-bin.000001 # Xid # # COMMIT /* XID */
209 master-bin.000001 # Gtid # # GTID #-#-#
210 master-bin.000001 # Query # # use `test`; ALTER EVENT evt COMMENT 'evt'
211 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
212 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (25)
213 master-bin.000001 # Xid # # COMMIT /* XID */
214 master-bin.000001 # Gtid # # GTID #-#-#
215 master-bin.000001 # Query # # use `test`; DROP EVENT evt
216 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
217 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (24)
218 master-bin.000001 # Xid # # COMMIT /* XID */
219 master-bin.000001 # Gtid # # GTID #-#-#
220 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
221 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
222 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (23)
223 master-bin.000001 # Xid # # COMMIT /* XID */
224 master-bin.000001 # Gtid # # GTID #-#-#
225 master-bin.000001 # Query # # use `test`; DROP TRIGGER tr
226 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
227 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (22)
228 master-bin.000001 # Xid # # COMMIT /* XID */
229 master-bin.000001 # Gtid # # GTID #-#-#
230 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `fc`() RETURNS varchar(64) CHARSET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci
231 RETURN "fc"
232 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
233 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (21)
234 master-bin.000001 # Xid # # COMMIT /* XID */
235 master-bin.000001 # Gtid # # GTID #-#-#
236 master-bin.000001 # Query # # use `test`; ALTER FUNCTION fc COMMENT 'fc'
237 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
238 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (20)
239 master-bin.000001 # Xid # # COMMIT /* XID */
240 master-bin.000001 # Gtid # # GTID #-#-#
241 master-bin.000001 # Query # # use `test`; DROP FUNCTION fc
242 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
243 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (19)
244 master-bin.000001 # Xid # # COMMIT /* XID */
245 master-bin.000001 # Gtid # # GTID #-#-#
246 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `pc`()
247 UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
248 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
249 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (18)
250 master-bin.000001 # Xid # # COMMIT /* XID */
251 master-bin.000001 # Gtid # # GTID #-#-#
252 master-bin.000001 # Query # # use `test`; ALTER PROCEDURE pc COMMENT 'pc'
253 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
254 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (17)
255 master-bin.000001 # Xid # # COMMIT /* XID */
256 master-bin.000001 # Gtid # # GTID #-#-#
257 master-bin.000001 # Query # # use `test`; DROP PROCEDURE pc
258 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
259 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (16)
260 master-bin.000001 # Xid # # COMMIT /* XID */
261 master-bin.000001 # Gtid # # GTID #-#-#
262 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
263 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
264 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (15)
265 master-bin.000001 # Xid # # COMMIT /* XID */
266 master-bin.000001 # Gtid # # GTID #-#-#
267 master-bin.000001 # Query # # use `test`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
268 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
269 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (14)
270 master-bin.000001 # Xid # # COMMIT /* XID */
271 master-bin.000001 # Gtid # # GTID #-#-#
272 master-bin.000001 # Query # # use `test`; DROP VIEW v
273 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
274 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (13)
275 master-bin.000001 # Xid # # COMMIT /* XID */
276 master-bin.000001 # Gtid # # GTID #-#-#
277 master-bin.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
278 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
279 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (12)
280 master-bin.000001 # Xid # # COMMIT /* XID */
281 master-bin.000001 # Gtid # # GTID #-#-#
282 master-bin.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
283 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
284 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (11)
285 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_xx (a int)
286 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (10)
287 master-bin.000001 # Xid # # COMMIT /* XID */
288 master-bin.000001 # Gtid # # GTID #-#-#
289 master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx ADD COLUMN (b int)
290 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
291 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (9)
292 master-bin.000001 # Xid # # COMMIT /* XID */
293 master-bin.000001 # Gtid # # GTID #-#-#
294 master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx RENAME new_tt_xx
295 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
296 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (8)
297 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`new_tt_xx` /* generated by server */
298 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (7)
299 master-bin.000001 # Xid # # COMMIT /* XID */
300 master-bin.000001 # Gtid # # GTID #-#-#
301 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_xx (a int)
302 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
303 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (6)
304 master-bin.000001 # Xid # # COMMIT /* XID */
305 master-bin.000001 # Gtid # # GTID #-#-#
306 master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx ADD COLUMN (b int)
307 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
308 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (5)
309 master-bin.000001 # Xid # # COMMIT /* XID */
310 master-bin.000001 # Gtid # # GTID #-#-#
311 master-bin.000001 # Query # # use `test`; RENAME TABLE tt_xx TO new_tt_xx
312 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
313 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (4)
314 master-bin.000001 # Xid # # COMMIT /* XID */
315 master-bin.000001 # Gtid # # GTID #-#-#
316 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE new_tt_xx
317 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
318 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (3)
319 master-bin.000001 # Xid # # COMMIT /* XID */
320 master-bin.000001 # Gtid # # GTID #-#-#
321 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_xx`,`new_tt_xx` /* generated by server */
322 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
323 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (2)
324 master-bin.000001 # Xid # # COMMIT /* XID */
325 master-bin.000001 # Gtid # # GTID #-#-#
326 master-bin.000001 # Query # # CREATE DATABASE db
327 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
328 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (1)
329 master-bin.000001 # Xid # # COMMIT /* XID */
330 master-bin.000001 # Gtid # # GTID #-#-#
331 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db
332 SET AUTOCOMMIT= 1;
333 ###################################################################################
334 # CHECK CONSISTENCY
335 ###################################################################################
336 connection slave;
337 include/diff_tables.inc [master:tt_1,slave:tt_1]
338 ###################################################################################
339 # CLEAN
340 ###################################################################################
341 connection master;
342 DROP TABLE tt_1;
343 DROP TABLE tt_2;
344 DROP TABLE nt_1;
345 connection slave;
346 include/rpl_end.inc