Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET @save_binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking;
7 Warnings:
8 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
9
10 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
11 Warnings:
12 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
13 ######## 1. Test referential action RESTRICT with WRITESET. ########
14 SELECT @@binlog_transaction_dependency_tracking;
15 @@binlog_transaction_dependency_tracking
16 WRITESET
17 Warnings:
18 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
19 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
20 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
21 CREATE TABLE t1 (a INT PRIMARY KEY);
22 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE RESTRICT);
23 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE RESTRICT);
24 INSERT INTO parent1 VALUES (1, 1), (2, 2);
25 INSERT INTO parent2 VALUES (1, 1), (2, 2);
26 FLUSH LOGS;
27 # Case 2.1, 2.2, 2.3
28 INSERT INTO child1 VALUES (1, 1);
29 INSERT INTO child2 VALUES (1, 1);
30 UPDATE child1 SET a = 2;
31 UPDATE child2 SET a = 2;
32 DELETE FROM child1;
33 DELETE FROM child2;
34 # Case 1.1, 1.2, 1.3
35 INSERT INTO t1 VALUES (1);
36 INSERT INTO parent1 VALUES (3, 3);
37 INSERT INTO t1 VALUES (2);
38 # Case 1.4, 1.5
39 BEGIN;
40 INSERT INTO t1 VALUES (3);
41 INSERT INTO child1 VALUES (1, 1);
42 BEGIN;
43 INSERT INTO parent1 VALUEs (4, 4);
44 INSERT INTO child2 VALUES (1, 1);
45 BEGIN;
46 INSERT INTO t1 VALUES (4);
47 COMMIT;
48 COMMIT;
49 COMMIT;
50 INSERT INTO t1 VALUES (5);
51 UPDATE parent1 SET a=5 WHERE a=1;
52 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child1`, CONSTRAINT `child1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent1` (`a`) ON UPDATE RESTRICT)
53 DELETE FROM parent2 WHERE a=1;
54 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child2`, CONSTRAINT `child2_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent2` (`a`) ON DELETE RESTRICT)
55 # Drop table and flush logs to force binlog to rotate
56 DROP TABLE child2, parent2, child1, parent1, t1;
57 FLUSH LOGS;
58 # Processing binlog...
59 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14]
60 # Verify that replication is correct
61 include/sync_slave_sql_with_master.inc
62
63 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET_SESSION;
64 Warnings:
65 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
66 ######## 2. Test referential action RESTRICT with WRITESET_SESSION. ########
67 SELECT @@binlog_transaction_dependency_tracking;
68 @@binlog_transaction_dependency_tracking
69 WRITESET_SESSION
70 Warnings:
71 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
72 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
73 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
74 CREATE TABLE t1 (a INT PRIMARY KEY);
75 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE RESTRICT);
76 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE RESTRICT);
77 INSERT INTO parent1 VALUES (1, 1), (2, 2);
78 INSERT INTO parent2 VALUES (1, 1), (2, 2);
79 FLUSH LOGS;
80 # Case 2.1, 2.2, 2.3
81 INSERT INTO child1 VALUES (1, 1);
82 INSERT INTO child2 VALUES (1, 1);
83 UPDATE child1 SET a = 2;
84 UPDATE child2 SET a = 2;
85 DELETE FROM child1;
86 DELETE FROM child2;
87 # Case 1.1, 1.2, 1.3
88 INSERT INTO t1 VALUES (1);
89 INSERT INTO parent1 VALUES (3, 3);
90 INSERT INTO t1 VALUES (2);
91 # Case 1.4, 1.5
92 BEGIN;
93 INSERT INTO t1 VALUES (3);
94 INSERT INTO child1 VALUES (1, 1);
95 BEGIN;
96 INSERT INTO parent1 VALUEs (4, 4);
97 INSERT INTO child2 VALUES (1, 1);
98 BEGIN;
99 INSERT INTO t1 VALUES (4);
100 COMMIT;
101 COMMIT;
102 COMMIT;
103 INSERT INTO t1 VALUES (5);
104 UPDATE parent1 SET a=5 WHERE a=1;
105 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child1`, CONSTRAINT `child1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent1` (`a`) ON UPDATE RESTRICT)
106 DELETE FROM parent2 WHERE a=1;
107 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child2`, CONSTRAINT `child2_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent2` (`a`) ON DELETE RESTRICT)
108 # Drop table and flush logs to force binlog to rotate
109 DROP TABLE child2, parent2, child1, parent1, t1;
110 FLUSH LOGS;
111 # Processing binlog...
112 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14]
113 # Verify that replication is correct
114 include/sync_slave_sql_with_master.inc
115
116 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
117 Warnings:
118 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
119 ######## 3. Test referential action NO ACTION with WRITESET. ########
120 SELECT @@binlog_transaction_dependency_tracking;
121 @@binlog_transaction_dependency_tracking
122 WRITESET
123 Warnings:
124 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
125 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
126 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
127 CREATE TABLE t1 (a INT PRIMARY KEY);
128 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE NO ACTION);
129 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE NO ACTION);
130 INSERT INTO parent1 VALUES (1, 1), (2, 2);
131 INSERT INTO parent2 VALUES (1, 1), (2, 2);
132 FLUSH LOGS;
133 # Case 2.1, 2.2, 2.3
134 INSERT INTO child1 VALUES (1, 1);
135 INSERT INTO child2 VALUES (1, 1);
136 UPDATE child1 SET a = 2;
137 UPDATE child2 SET a = 2;
138 DELETE FROM child1;
139 DELETE FROM child2;
140 # Case 1.1, 1.2, 1.3
141 INSERT INTO t1 VALUES (1);
142 INSERT INTO parent1 VALUES (3, 3);
143 INSERT INTO t1 VALUES (2);
144 # Case 1.4, 1.5
145 BEGIN;
146 INSERT INTO t1 VALUES (3);
147 INSERT INTO child1 VALUES (1, 1);
148 BEGIN;
149 INSERT INTO parent1 VALUEs (4, 4);
150 INSERT INTO child2 VALUES (1, 1);
151 BEGIN;
152 INSERT INTO t1 VALUES (4);
153 COMMIT;
154 COMMIT;
155 COMMIT;
156 INSERT INTO t1 VALUES (5);
157 UPDATE parent1 SET a=5 WHERE a=1;
158 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child1`, CONSTRAINT `child1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent1` (`a`))
159 DELETE FROM parent2 WHERE a=1;
160 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child2`, CONSTRAINT `child2_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent2` (`a`))
161 # Drop table and flush logs to force binlog to rotate
162 DROP TABLE child2, parent2, child1, parent1, t1;
163 FLUSH LOGS;
164 # Processing binlog...
165 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14]
166 # Verify that replication is correct
167 include/sync_slave_sql_with_master.inc
168
169 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET_SESSION;
170 Warnings:
171 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
172 ######## 4. Test referential action NO ACTION with WRITESET_SESSION. ########
173 SELECT @@binlog_transaction_dependency_tracking;
174 @@binlog_transaction_dependency_tracking
175 WRITESET_SESSION
176 Warnings:
177 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
178 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
179 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
180 CREATE TABLE t1 (a INT PRIMARY KEY);
181 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE NO ACTION);
182 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE NO ACTION);
183 INSERT INTO parent1 VALUES (1, 1), (2, 2);
184 INSERT INTO parent2 VALUES (1, 1), (2, 2);
185 FLUSH LOGS;
186 # Case 2.1, 2.2, 2.3
187 INSERT INTO child1 VALUES (1, 1);
188 INSERT INTO child2 VALUES (1, 1);
189 UPDATE child1 SET a = 2;
190 UPDATE child2 SET a = 2;
191 DELETE FROM child1;
192 DELETE FROM child2;
193 # Case 1.1, 1.2, 1.3
194 INSERT INTO t1 VALUES (1);
195 INSERT INTO parent1 VALUES (3, 3);
196 INSERT INTO t1 VALUES (2);
197 # Case 1.4, 1.5
198 BEGIN;
199 INSERT INTO t1 VALUES (3);
200 INSERT INTO child1 VALUES (1, 1);
201 BEGIN;
202 INSERT INTO parent1 VALUEs (4, 4);
203 INSERT INTO child2 VALUES (1, 1);
204 BEGIN;
205 INSERT INTO t1 VALUES (4);
206 COMMIT;
207 COMMIT;
208 COMMIT;
209 INSERT INTO t1 VALUES (5);
210 UPDATE parent1 SET a=5 WHERE a=1;
211 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child1`, CONSTRAINT `child1_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent1` (`a`))
212 DELETE FROM parent2 WHERE a=1;
213 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child2`, CONSTRAINT `child2_ibfk_1` FOREIGN KEY (`b`) REFERENCES `parent2` (`a`))
214 # Drop table and flush logs to force binlog to rotate
215 DROP TABLE child2, parent2, child1, parent1, t1;
216 FLUSH LOGS;
217 # Processing binlog...
218 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14]
219 # Verify that replication is correct
220 include/sync_slave_sql_with_master.inc
221
222 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
223 Warnings:
224 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
225 ######## 5. Test referential action CASCADE with WRITESET. ########
226 SELECT @@binlog_transaction_dependency_tracking;
227 @@binlog_transaction_dependency_tracking
228 WRITESET
229 Warnings:
230 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
231 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
232 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
233 CREATE TABLE t1 (a INT PRIMARY KEY);
234 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE CASCADE);
235 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE CASCADE);
236 INSERT INTO parent1 VALUES (1, 1), (2, 2);
237 INSERT INTO parent2 VALUES (1, 1), (2, 2);
238 FLUSH LOGS;
239 # Case 2.1, 2.2, 2.3
240 INSERT INTO child1 VALUES (1, 1);
241 INSERT INTO child2 VALUES (1, 1);
242 UPDATE child1 SET a = 2;
243 UPDATE child2 SET a = 2;
244 DELETE FROM child1;
245 DELETE FROM child2;
246 # Case 1.1, 1.2, 1.3
247 INSERT INTO t1 VALUES (1);
248 INSERT INTO parent1 VALUES (3, 3);
249 INSERT INTO t1 VALUES (2);
250 # Case 1.4, 1.5
251 BEGIN;
252 INSERT INTO t1 VALUES (3);
253 INSERT INTO child1 VALUES (1, 1);
254 BEGIN;
255 INSERT INTO parent1 VALUEs (4, 4);
256 INSERT INTO child2 VALUES (1, 1);
257 BEGIN;
258 INSERT INTO t1 VALUES (4);
259 COMMIT;
260 COMMIT;
261 COMMIT;
262 INSERT INTO t1 VALUES (5);
263 UPDATE parent1 SET a=5 WHERE a=1;
264 DELETE FROM parent2 WHERE a=1;
265 # Drop table and flush logs to force binlog to rotate
266 DROP TABLE child2, parent2, child1, parent1, t1;
267 FLUSH LOGS;
268 # Processing binlog...
269 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14;14 15;15 16]
270 # Verify that replication is correct
271 include/sync_slave_sql_with_master.inc
272
273 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET_SESSION;
274 Warnings:
275 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
276 ######## 6. Test referential action CASCADE with WRITESET_SESSION. ########
277 SELECT @@binlog_transaction_dependency_tracking;
278 @@binlog_transaction_dependency_tracking
279 WRITESET_SESSION
280 Warnings:
281 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
282 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
283 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
284 CREATE TABLE t1 (a INT PRIMARY KEY);
285 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE CASCADE);
286 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE CASCADE);
287 INSERT INTO parent1 VALUES (1, 1), (2, 2);
288 INSERT INTO parent2 VALUES (1, 1), (2, 2);
289 FLUSH LOGS;
290 # Case 2.1, 2.2, 2.3
291 INSERT INTO child1 VALUES (1, 1);
292 INSERT INTO child2 VALUES (1, 1);
293 UPDATE child1 SET a = 2;
294 UPDATE child2 SET a = 2;
295 DELETE FROM child1;
296 DELETE FROM child2;
297 # Case 1.1, 1.2, 1.3
298 INSERT INTO t1 VALUES (1);
299 INSERT INTO parent1 VALUES (3, 3);
300 INSERT INTO t1 VALUES (2);
301 # Case 1.4, 1.5
302 BEGIN;
303 INSERT INTO t1 VALUES (3);
304 INSERT INTO child1 VALUES (1, 1);
305 BEGIN;
306 INSERT INTO parent1 VALUEs (4, 4);
307 INSERT INTO child2 VALUES (1, 1);
308 BEGIN;
309 INSERT INTO t1 VALUES (4);
310 COMMIT;
311 COMMIT;
312 COMMIT;
313 INSERT INTO t1 VALUES (5);
314 UPDATE parent1 SET a=5 WHERE a=1;
315 DELETE FROM parent2 WHERE a=1;
316 # Drop table and flush logs to force binlog to rotate
317 DROP TABLE child2, parent2, child1, parent1, t1;
318 FLUSH LOGS;
319 # Processing binlog...
320 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14;14 15;15 16]
321 # Verify that replication is correct
322 include/sync_slave_sql_with_master.inc
323
324 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
325 Warnings:
326 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
327 ######## 7. Test referential action SET NULL with WRITESET. ########
328 SELECT @@binlog_transaction_dependency_tracking;
329 @@binlog_transaction_dependency_tracking
330 WRITESET
331 Warnings:
332 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
333 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
334 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
335 CREATE TABLE t1 (a INT PRIMARY KEY);
336 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE SET NULL);
337 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE SET NULL);
338 INSERT INTO parent1 VALUES (1, 1), (2, 2);
339 INSERT INTO parent2 VALUES (1, 1), (2, 2);
340 FLUSH LOGS;
341 # Case 2.1, 2.2, 2.3
342 INSERT INTO child1 VALUES (1, 1);
343 INSERT INTO child2 VALUES (1, 1);
344 UPDATE child1 SET a = 2;
345 UPDATE child2 SET a = 2;
346 DELETE FROM child1;
347 DELETE FROM child2;
348 # Case 1.1, 1.2, 1.3
349 INSERT INTO t1 VALUES (1);
350 INSERT INTO parent1 VALUES (3, 3);
351 INSERT INTO t1 VALUES (2);
352 # Case 1.4, 1.5
353 BEGIN;
354 INSERT INTO t1 VALUES (3);
355 INSERT INTO child1 VALUES (1, 1);
356 BEGIN;
357 INSERT INTO parent1 VALUEs (4, 4);
358 INSERT INTO child2 VALUES (1, 1);
359 BEGIN;
360 INSERT INTO t1 VALUES (4);
361 COMMIT;
362 COMMIT;
363 COMMIT;
364 INSERT INTO t1 VALUES (5);
365 UPDATE parent1 SET a=5 WHERE a=1;
366 DELETE FROM parent2 WHERE a=1;
367 # Drop table and flush logs to force binlog to rotate
368 DROP TABLE child2, parent2, child1, parent1, t1;
369 FLUSH LOGS;
370 # Processing binlog...
371 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14;14 15;15 16]
372 # Verify that replication is correct
373 include/sync_slave_sql_with_master.inc
374
375 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET_SESSION;
376 Warnings:
377 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
378 ######## 8. Test referential action SET NULL with WRITESET_SESSION. ########
379 SELECT @@binlog_transaction_dependency_tracking;
380 @@binlog_transaction_dependency_tracking
381 WRITESET_SESSION
382 Warnings:
383 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
384 CREATE TABLE parent1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
385 CREATE TABLE parent2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(50));
386 CREATE TABLE t1 (a INT PRIMARY KEY);
387 CREATE TABLE child1 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent1 (a) ON UPDATE SET NULL);
388 CREATE TABLE child2 (a INT PRIMARY KEY, b INT, FOREIGN KEY(b) REFERENCES parent2 (a) ON DELETE SET NULL);
389 INSERT INTO parent1 VALUES (1, 1), (2, 2);
390 INSERT INTO parent2 VALUES (1, 1), (2, 2);
391 FLUSH LOGS;
392 # Case 2.1, 2.2, 2.3
393 INSERT INTO child1 VALUES (1, 1);
394 INSERT INTO child2 VALUES (1, 1);
395 UPDATE child1 SET a = 2;
396 UPDATE child2 SET a = 2;
397 DELETE FROM child1;
398 DELETE FROM child2;
399 # Case 1.1, 1.2, 1.3
400 INSERT INTO t1 VALUES (1);
401 INSERT INTO parent1 VALUES (3, 3);
402 INSERT INTO t1 VALUES (2);
403 # Case 1.4, 1.5
404 BEGIN;
405 INSERT INTO t1 VALUES (3);
406 INSERT INTO child1 VALUES (1, 1);
407 BEGIN;
408 INSERT INTO parent1 VALUEs (4, 4);
409 INSERT INTO child2 VALUES (1, 1);
410 BEGIN;
411 INSERT INTO t1 VALUES (4);
412 COMMIT;
413 COMMIT;
414 COMMIT;
415 INSERT INTO t1 VALUES (5);
416 UPDATE parent1 SET a=5 WHERE a=1;
417 DELETE FROM parent2 WHERE a=1;
418 # Drop table and flush logs to force binlog to rotate
419 DROP TABLE child2, parent2, child1, parent1, t1;
420 FLUSH LOGS;
421 # Processing binlog...
422 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;4 6;1 7;7 8;8 9;8 10;9 11;9 12;11 13;13 14;14 15;15 16]
423 # Verify that replication is correct
424 include/sync_slave_sql_with_master.inc
425
426 # Clean up
427 SET @@GLOBAL.binlog_transaction_dependency_tracking= @save_binlog_transaction_dependency_tracking;
428 Warnings:
429 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
430 include/rpl_end.inc