Debian Codegraph @

mysql-test/suite/rpl/r/rpl_binlog_transaction_dependency_tracking_with_indexes.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 #### INITIALIZE ####
7 [connection slave]
8 include/stop_slave.inc
9 SET @save_replica_parallel_workers= @@GLOBAL.replica_parallel_workers;
10 SET @@GLOBAL.replica_parallel_workers= 4;
11 include/start_slave.inc
12 [connection master]
13 SET @save_binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking;
14 Warnings:
15 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
16 SET GLOBAL binlog_transaction_dependency_tracking = COMMIT_ORDER;
17 Warnings:
18 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
19 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
20 Warnings:
21 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
22
23 #### 0.0.0.0: WITHOUT PK, NULLABLE, NOT UNIQUE, NO INDEX ####
24
25 CREATE TABLE t1 (a INT, b INT , c INT );
26 CREATE TABLE t2 (a INT PRIMARY KEY);
27 FLUSH LOGS;
28 include/save_binlog_position.inc
29 # TRX1: independent
30 INSERT INTO t1 VALUES (1, 1, 1);
31 # now t1 contains one row: (1, 1, 1)
32 include/include/assert_logical_timestamps.inc [0 1]
33 # TRX2: independent
34 BEGIN;
35 INSERT INTO t1 VALUES (2, 2, 2);
36 INSERT INTO t2 VALUES (1);
37 COMMIT;
38 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
39 include/include/assert_logical_timestamps.inc [1 2]
40 # TRX3: independent
41 INSERT INTO t2 VALUES (3);
42 # TRX4: depends on TRX2
43 DELETE FROM t1 WHERE a = 2;
44 # now t1 contains one row: (1, 1, 1)
45 include/include/assert_logical_timestamps.inc [1 3;3 4]
46 # TRX5: independent
47 INSERT INTO t2 VALUES (5);
48 # TRX6: conflict with TRX4 if unique, else with TRX1
49 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
50 # now t1 contains one row: (1, 2, 2)
51 include/include/assert_logical_timestamps.inc [1 5;5 6]
52 # TRX7: independent
53 INSERT INTO t1 VALUES (3, NULL, 2);
54 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
55 include/include/assert_logical_timestamps.inc [6 7]
56 # TRX8: independent
57 INSERT INTO t2 VALUES (8);
58 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
59 INSERT INTO t1 VALUES (4, NULL, 2);
60 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
61 include/include/assert_logical_timestamps.inc [1 8;8 9]
62 # TRX10: independent
63 INSERT INTO t2 VALUES (10);
64 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
65 DELETE FROM t1 WHERE a = 3;
66 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
67 include/include/assert_logical_timestamps.inc [1 10;10 11]
68 DROP TABLE t1;
69 DROP TABLE t2;
70
71 #### 0.0.0.1: WITHOUT PK, NULLABLE, NOT UNIQUE, 1-COLUMN INDEX ####
72
73 CREATE TABLE t1 (a INT, b INT , c INT , INDEX(b));
74 CREATE TABLE t2 (a INT PRIMARY KEY);
75 FLUSH LOGS;
76 include/save_binlog_position.inc
77 # TRX1: independent
78 INSERT INTO t1 VALUES (1, 1, 1);
79 # now t1 contains one row: (1, 1, 1)
80 include/include/assert_logical_timestamps.inc [0 1]
81 # TRX2: independent
82 BEGIN;
83 INSERT INTO t1 VALUES (2, 2, 2);
84 INSERT INTO t2 VALUES (1);
85 COMMIT;
86 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
87 include/include/assert_logical_timestamps.inc [1 2]
88 # TRX3: independent
89 INSERT INTO t2 VALUES (3);
90 # TRX4: depends on TRX2
91 DELETE FROM t1 WHERE a = 2;
92 # now t1 contains one row: (1, 1, 1)
93 include/include/assert_logical_timestamps.inc [1 3;3 4]
94 # TRX5: independent
95 INSERT INTO t2 VALUES (5);
96 # TRX6: conflict with TRX4 if unique, else with TRX1
97 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
98 # now t1 contains one row: (1, 2, 2)
99 include/include/assert_logical_timestamps.inc [1 5;5 6]
100 # TRX7: independent
101 INSERT INTO t1 VALUES (3, NULL, 2);
102 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
103 include/include/assert_logical_timestamps.inc [6 7]
104 # TRX8: independent
105 INSERT INTO t2 VALUES (8);
106 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
107 INSERT INTO t1 VALUES (4, NULL, 2);
108 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
109 include/include/assert_logical_timestamps.inc [1 8;8 9]
110 # TRX10: independent
111 INSERT INTO t2 VALUES (10);
112 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
113 DELETE FROM t1 WHERE a = 3;
114 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
115 include/include/assert_logical_timestamps.inc [1 10;10 11]
116 DROP TABLE t1;
117 DROP TABLE t2;
118
119 #### 0.0.0.2: WITHOUT PK, NULLABLE, NOT UNIQUE, 2-COLUMN INDEX ####
120
121 CREATE TABLE t1 (a INT, b INT , c INT , INDEX(b, c));
122 CREATE TABLE t2 (a INT PRIMARY KEY);
123 FLUSH LOGS;
124 include/save_binlog_position.inc
125 # TRX1: independent
126 INSERT INTO t1 VALUES (1, 1, 1);
127 # now t1 contains one row: (1, 1, 1)
128 include/include/assert_logical_timestamps.inc [0 1]
129 # TRX2: independent
130 BEGIN;
131 INSERT INTO t1 VALUES (2, 2, 2);
132 INSERT INTO t2 VALUES (1);
133 COMMIT;
134 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
135 include/include/assert_logical_timestamps.inc [1 2]
136 # TRX3: independent
137 INSERT INTO t2 VALUES (3);
138 # TRX4: depends on TRX2
139 DELETE FROM t1 WHERE a = 2;
140 # now t1 contains one row: (1, 1, 1)
141 include/include/assert_logical_timestamps.inc [1 3;3 4]
142 # TRX5: independent
143 INSERT INTO t2 VALUES (5);
144 # TRX6: conflict with TRX4 if unique, else with TRX1
145 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
146 # now t1 contains one row: (1, 2, 2)
147 include/include/assert_logical_timestamps.inc [1 5;5 6]
148 # TRX7: independent
149 INSERT INTO t1 VALUES (3, NULL, 2);
150 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
151 include/include/assert_logical_timestamps.inc [6 7]
152 # TRX8: independent
153 INSERT INTO t2 VALUES (8);
154 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
155 INSERT INTO t1 VALUES (4, NULL, 2);
156 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
157 include/include/assert_logical_timestamps.inc [1 8;8 9]
158 # TRX10: independent
159 INSERT INTO t2 VALUES (10);
160 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
161 DELETE FROM t1 WHERE a = 3;
162 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
163 include/include/assert_logical_timestamps.inc [1 10;10 11]
164 DROP TABLE t1;
165 DROP TABLE t2;
166
167 #### 0.0.1.1: WITHOUT PK, NULLABLE, UNIQUE, 1-COLUMN INDEX ####
168
169 CREATE TABLE t1 (a INT, b INT , c INT , UNIQUE INDEX(b));
170 CREATE TABLE t2 (a INT PRIMARY KEY);
171 FLUSH LOGS;
172 include/save_binlog_position.inc
173 # TRX1: independent
174 INSERT INTO t1 VALUES (1, 1, 1);
175 # now t1 contains one row: (1, 1, 1)
176 include/include/assert_logical_timestamps.inc [0 1]
177 # TRX2: independent
178 BEGIN;
179 INSERT INTO t1 VALUES (2, 2, 2);
180 INSERT INTO t2 VALUES (1);
181 COMMIT;
182 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
183 include/include/assert_logical_timestamps.inc [1 2]
184 # TRX3: independent
185 INSERT INTO t2 VALUES (3);
186 # TRX4: depends on TRX2
187 DELETE FROM t1 WHERE a = 2;
188 # now t1 contains one row: (1, 1, 1)
189 include/include/assert_logical_timestamps.inc [1 3;3 4]
190 # TRX5: independent
191 INSERT INTO t2 VALUES (5);
192 # TRX6: conflict with TRX4 if unique, else with TRX1
193 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
194 # now t1 contains one row: (1, 2, 2)
195 include/include/assert_logical_timestamps.inc [1 5;5 6]
196 # TRX7: independent
197 INSERT INTO t1 VALUES (3, NULL, 2);
198 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
199 include/include/assert_logical_timestamps.inc [6 7]
200 # TRX8: independent
201 INSERT INTO t2 VALUES (8);
202 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
203 INSERT INTO t1 VALUES (4, NULL, 2);
204 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
205 include/include/assert_logical_timestamps.inc [1 8;8 9]
206 # TRX10: independent
207 INSERT INTO t2 VALUES (10);
208 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
209 DELETE FROM t1 WHERE a = 3;
210 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
211 include/include/assert_logical_timestamps.inc [1 10;10 11]
212 DROP TABLE t1;
213 DROP TABLE t2;
214
215 #### 0.0.1.2: WITHOUT PK, NULLABLE, UNIQUE, 2-COLUMN INDEX ####
216
217 CREATE TABLE t1 (a INT, b INT , c INT , UNIQUE INDEX(b, c));
218 CREATE TABLE t2 (a INT PRIMARY KEY);
219 FLUSH LOGS;
220 include/save_binlog_position.inc
221 # TRX1: independent
222 INSERT INTO t1 VALUES (1, 1, 1);
223 # now t1 contains one row: (1, 1, 1)
224 include/include/assert_logical_timestamps.inc [0 1]
225 # TRX2: independent
226 BEGIN;
227 INSERT INTO t1 VALUES (2, 2, 2);
228 INSERT INTO t2 VALUES (1);
229 COMMIT;
230 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
231 include/include/assert_logical_timestamps.inc [1 2]
232 # TRX3: independent
233 INSERT INTO t2 VALUES (3);
234 # TRX4: depends on TRX2
235 DELETE FROM t1 WHERE a = 2;
236 # now t1 contains one row: (1, 1, 1)
237 include/include/assert_logical_timestamps.inc [1 3;3 4]
238 # TRX5: independent
239 INSERT INTO t2 VALUES (5);
240 # TRX6: conflict with TRX4 if unique, else with TRX1
241 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
242 # now t1 contains one row: (1, 2, 2)
243 include/include/assert_logical_timestamps.inc [1 5;5 6]
244 # TRX7: independent
245 INSERT INTO t1 VALUES (3, NULL, 2);
246 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
247 include/include/assert_logical_timestamps.inc [6 7]
248 # TRX8: independent
249 INSERT INTO t2 VALUES (8);
250 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
251 INSERT INTO t1 VALUES (4, NULL, 2);
252 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
253 include/include/assert_logical_timestamps.inc [1 8;8 9]
254 # TRX10: independent
255 INSERT INTO t2 VALUES (10);
256 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
257 DELETE FROM t1 WHERE a = 3;
258 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
259 include/include/assert_logical_timestamps.inc [1 10;10 11]
260 DROP TABLE t1;
261 DROP TABLE t2;
262
263 #### 0.1.0.0: WITHOUT PK, NOT NULL, NOT UNIQUE, NO INDEX ####
264
265 CREATE TABLE t1 (a INT, b INT NOT NULL, c INT NOT NULL );
266 CREATE TABLE t2 (a INT PRIMARY KEY);
267 FLUSH LOGS;
268 include/save_binlog_position.inc
269 # TRX1: independent
270 INSERT INTO t1 VALUES (1, 1, 1);
271 # now t1 contains one row: (1, 1, 1)
272 include/include/assert_logical_timestamps.inc [0 1]
273 # TRX2: independent
274 BEGIN;
275 INSERT INTO t1 VALUES (2, 2, 2);
276 INSERT INTO t2 VALUES (1);
277 COMMIT;
278 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
279 include/include/assert_logical_timestamps.inc [1 2]
280 # TRX3: independent
281 INSERT INTO t2 VALUES (3);
282 # TRX4: depends on TRX2
283 DELETE FROM t1 WHERE a = 2;
284 # now t1 contains one row: (1, 1, 1)
285 include/include/assert_logical_timestamps.inc [1 3;3 4]
286 # TRX5: independent
287 INSERT INTO t2 VALUES (5);
288 # TRX6: conflict with TRX4 if unique, else with TRX1
289 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
290 # now t1 contains one row: (1, 2, 2)
291 include/include/assert_logical_timestamps.inc [1 5;5 6]
292 DROP TABLE t1;
293 DROP TABLE t2;
294
295 #### 0.1.0.1: WITHOUT PK, NOT NULL, NOT UNIQUE, 1-COLUMN INDEX ####
296
297 CREATE TABLE t1 (a INT, b INT NOT NULL, c INT NOT NULL , INDEX(b));
298 CREATE TABLE t2 (a INT PRIMARY KEY);
299 FLUSH LOGS;
300 include/save_binlog_position.inc
301 # TRX1: independent
302 INSERT INTO t1 VALUES (1, 1, 1);
303 # now t1 contains one row: (1, 1, 1)
304 include/include/assert_logical_timestamps.inc [0 1]
305 # TRX2: independent
306 BEGIN;
307 INSERT INTO t1 VALUES (2, 2, 2);
308 INSERT INTO t2 VALUES (1);
309 COMMIT;
310 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
311 include/include/assert_logical_timestamps.inc [1 2]
312 # TRX3: independent
313 INSERT INTO t2 VALUES (3);
314 # TRX4: depends on TRX2
315 DELETE FROM t1 WHERE a = 2;
316 # now t1 contains one row: (1, 1, 1)
317 include/include/assert_logical_timestamps.inc [1 3;3 4]
318 # TRX5: independent
319 INSERT INTO t2 VALUES (5);
320 # TRX6: conflict with TRX4 if unique, else with TRX1
321 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
322 # now t1 contains one row: (1, 2, 2)
323 include/include/assert_logical_timestamps.inc [1 5;5 6]
324 DROP TABLE t1;
325 DROP TABLE t2;
326
327 #### 0.1.0.2: WITHOUT PK, NOT NULL, NOT UNIQUE, 2-COLUMN INDEX ####
328
329 CREATE TABLE t1 (a INT, b INT NOT NULL, c INT NOT NULL , INDEX(b, c));
330 CREATE TABLE t2 (a INT PRIMARY KEY);
331 FLUSH LOGS;
332 include/save_binlog_position.inc
333 # TRX1: independent
334 INSERT INTO t1 VALUES (1, 1, 1);
335 # now t1 contains one row: (1, 1, 1)
336 include/include/assert_logical_timestamps.inc [0 1]
337 # TRX2: independent
338 BEGIN;
339 INSERT INTO t1 VALUES (2, 2, 2);
340 INSERT INTO t2 VALUES (1);
341 COMMIT;
342 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
343 include/include/assert_logical_timestamps.inc [1 2]
344 # TRX3: independent
345 INSERT INTO t2 VALUES (3);
346 # TRX4: depends on TRX2
347 DELETE FROM t1 WHERE a = 2;
348 # now t1 contains one row: (1, 1, 1)
349 include/include/assert_logical_timestamps.inc [1 3;3 4]
350 # TRX5: independent
351 INSERT INTO t2 VALUES (5);
352 # TRX6: conflict with TRX4 if unique, else with TRX1
353 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
354 # now t1 contains one row: (1, 2, 2)
355 include/include/assert_logical_timestamps.inc [1 5;5 6]
356 DROP TABLE t1;
357 DROP TABLE t2;
358
359 #### 0.1.1.1: WITHOUT PK, NOT NULL, UNIQUE, 1-COLUMN INDEX ####
360
361 CREATE TABLE t1 (a INT, b INT NOT NULL, c INT NOT NULL , UNIQUE INDEX(b));
362 CREATE TABLE t2 (a INT PRIMARY KEY);
363 FLUSH LOGS;
364 include/save_binlog_position.inc
365 # TRX1: independent
366 INSERT INTO t1 VALUES (1, 1, 1);
367 # now t1 contains one row: (1, 1, 1)
368 include/include/assert_logical_timestamps.inc [0 1]
369 # TRX2: independent
370 BEGIN;
371 INSERT INTO t1 VALUES (2, 2, 2);
372 INSERT INTO t2 VALUES (1);
373 COMMIT;
374 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
375 include/include/assert_logical_timestamps.inc [1 2]
376 # TRX3: independent
377 INSERT INTO t2 VALUES (3);
378 # TRX4: depends on TRX2
379 DELETE FROM t1 WHERE a = 2;
380 # now t1 contains one row: (1, 1, 1)
381 include/include/assert_logical_timestamps.inc [1 3;2 4]
382 # TRX5: independent
383 INSERT INTO t2 VALUES (5);
384 # TRX6: conflict with TRX4 if unique, else with TRX1
385 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
386 # now t1 contains one row: (1, 2, 2)
387 include/include/assert_logical_timestamps.inc [1 5;4 6]
388 DROP TABLE t1;
389 DROP TABLE t2;
390
391 #### 0.1.1.2: WITHOUT PK, NOT NULL, UNIQUE, 2-COLUMN INDEX ####
392
393 CREATE TABLE t1 (a INT, b INT NOT NULL, c INT NOT NULL , UNIQUE INDEX(b, c));
394 CREATE TABLE t2 (a INT PRIMARY KEY);
395 FLUSH LOGS;
396 include/save_binlog_position.inc
397 # TRX1: independent
398 INSERT INTO t1 VALUES (1, 1, 1);
399 # now t1 contains one row: (1, 1, 1)
400 include/include/assert_logical_timestamps.inc [0 1]
401 # TRX2: independent
402 BEGIN;
403 INSERT INTO t1 VALUES (2, 2, 2);
404 INSERT INTO t2 VALUES (1);
405 COMMIT;
406 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
407 include/include/assert_logical_timestamps.inc [1 2]
408 # TRX3: independent
409 INSERT INTO t2 VALUES (3);
410 # TRX4: depends on TRX2
411 DELETE FROM t1 WHERE a = 2;
412 # now t1 contains one row: (1, 1, 1)
413 include/include/assert_logical_timestamps.inc [1 3;2 4]
414 # TRX5: independent
415 INSERT INTO t2 VALUES (5);
416 # TRX6: conflict with TRX4 if unique, else with TRX1
417 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
418 # now t1 contains one row: (1, 2, 2)
419 include/include/assert_logical_timestamps.inc [1 5;4 6]
420 DROP TABLE t1;
421 DROP TABLE t2;
422
423 #### 1.0.0.0: WITH PK, NULLABLE, NOT UNIQUE, NO INDEX ####
424
425 CREATE TABLE t1 (a INT PRIMARY KEY, b INT , c INT );
426 CREATE TABLE t2 (a INT PRIMARY KEY);
427 FLUSH LOGS;
428 include/save_binlog_position.inc
429 # TRX1: independent
430 INSERT INTO t1 VALUES (1, 1, 1);
431 # now t1 contains one row: (1, 1, 1)
432 include/include/assert_logical_timestamps.inc [0 1]
433 # TRX2: independent
434 BEGIN;
435 INSERT INTO t1 VALUES (2, 2, 2);
436 INSERT INTO t2 VALUES (1);
437 COMMIT;
438 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
439 include/include/assert_logical_timestamps.inc [1 2]
440 # TRX3: independent
441 INSERT INTO t2 VALUES (3);
442 # TRX4: depends on TRX2
443 DELETE FROM t1 WHERE a = 2;
444 # now t1 contains one row: (1, 1, 1)
445 include/include/assert_logical_timestamps.inc [1 3;2 4]
446 # TRX5: independent
447 INSERT INTO t2 VALUES (5);
448 # TRX6: conflict with TRX4 if unique, else with TRX1
449 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
450 # now t1 contains one row: (1, 2, 2)
451 include/include/assert_logical_timestamps.inc [1 5;1 6]
452 # TRX7: independent
453 INSERT INTO t1 VALUES (3, NULL, 2);
454 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
455 include/include/assert_logical_timestamps.inc [1 7]
456 # TRX8: independent
457 INSERT INTO t2 VALUES (8);
458 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
459 INSERT INTO t1 VALUES (4, NULL, 2);
460 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
461 include/include/assert_logical_timestamps.inc [1 8;1 9]
462 # TRX10: independent
463 INSERT INTO t2 VALUES (10);
464 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
465 DELETE FROM t1 WHERE a = 3;
466 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
467 include/include/assert_logical_timestamps.inc [1 10;7 11]
468 DROP TABLE t1;
469 DROP TABLE t2;
470
471 #### 1.0.0.1: WITH PK, NULLABLE, NOT UNIQUE, 1-COLUMN INDEX ####
472
473 CREATE TABLE t1 (a INT PRIMARY KEY, b INT , c INT , INDEX(b));
474 CREATE TABLE t2 (a INT PRIMARY KEY);
475 FLUSH LOGS;
476 include/save_binlog_position.inc
477 # TRX1: independent
478 INSERT INTO t1 VALUES (1, 1, 1);
479 # now t1 contains one row: (1, 1, 1)
480 include/include/assert_logical_timestamps.inc [0 1]
481 # TRX2: independent
482 BEGIN;
483 INSERT INTO t1 VALUES (2, 2, 2);
484 INSERT INTO t2 VALUES (1);
485 COMMIT;
486 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
487 include/include/assert_logical_timestamps.inc [1 2]
488 # TRX3: independent
489 INSERT INTO t2 VALUES (3);
490 # TRX4: depends on TRX2
491 DELETE FROM t1 WHERE a = 2;
492 # now t1 contains one row: (1, 1, 1)
493 include/include/assert_logical_timestamps.inc [1 3;2 4]
494 # TRX5: independent
495 INSERT INTO t2 VALUES (5);
496 # TRX6: conflict with TRX4 if unique, else with TRX1
497 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
498 # now t1 contains one row: (1, 2, 2)
499 include/include/assert_logical_timestamps.inc [1 5;1 6]
500 # TRX7: independent
501 INSERT INTO t1 VALUES (3, NULL, 2);
502 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
503 include/include/assert_logical_timestamps.inc [1 7]
504 # TRX8: independent
505 INSERT INTO t2 VALUES (8);
506 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
507 INSERT INTO t1 VALUES (4, NULL, 2);
508 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
509 include/include/assert_logical_timestamps.inc [1 8;1 9]
510 # TRX10: independent
511 INSERT INTO t2 VALUES (10);
512 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
513 DELETE FROM t1 WHERE a = 3;
514 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
515 include/include/assert_logical_timestamps.inc [1 10;7 11]
516 DROP TABLE t1;
517 DROP TABLE t2;
518
519 #### 1.0.0.2: WITH PK, NULLABLE, NOT UNIQUE, 2-COLUMN INDEX ####
520
521 CREATE TABLE t1 (a INT PRIMARY KEY, b INT , c INT , INDEX(b, c));
522 CREATE TABLE t2 (a INT PRIMARY KEY);
523 FLUSH LOGS;
524 include/save_binlog_position.inc
525 # TRX1: independent
526 INSERT INTO t1 VALUES (1, 1, 1);
527 # now t1 contains one row: (1, 1, 1)
528 include/include/assert_logical_timestamps.inc [0 1]
529 # TRX2: independent
530 BEGIN;
531 INSERT INTO t1 VALUES (2, 2, 2);
532 INSERT INTO t2 VALUES (1);
533 COMMIT;
534 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
535 include/include/assert_logical_timestamps.inc [1 2]
536 # TRX3: independent
537 INSERT INTO t2 VALUES (3);
538 # TRX4: depends on TRX2
539 DELETE FROM t1 WHERE a = 2;
540 # now t1 contains one row: (1, 1, 1)
541 include/include/assert_logical_timestamps.inc [1 3;2 4]
542 # TRX5: independent
543 INSERT INTO t2 VALUES (5);
544 # TRX6: conflict with TRX4 if unique, else with TRX1
545 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
546 # now t1 contains one row: (1, 2, 2)
547 include/include/assert_logical_timestamps.inc [1 5;1 6]
548 # TRX7: independent
549 INSERT INTO t1 VALUES (3, NULL, 2);
550 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
551 include/include/assert_logical_timestamps.inc [1 7]
552 # TRX8: independent
553 INSERT INTO t2 VALUES (8);
554 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
555 INSERT INTO t1 VALUES (4, NULL, 2);
556 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
557 include/include/assert_logical_timestamps.inc [1 8;1 9]
558 # TRX10: independent
559 INSERT INTO t2 VALUES (10);
560 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
561 DELETE FROM t1 WHERE a = 3;
562 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
563 include/include/assert_logical_timestamps.inc [1 10;7 11]
564 DROP TABLE t1;
565 DROP TABLE t2;
566
567 #### 1.0.1.1: WITH PK, NULLABLE, UNIQUE, 1-COLUMN INDEX ####
568
569 CREATE TABLE t1 (a INT PRIMARY KEY, b INT , c INT , UNIQUE INDEX(b));
570 CREATE TABLE t2 (a INT PRIMARY KEY);
571 FLUSH LOGS;
572 include/save_binlog_position.inc
573 # TRX1: independent
574 INSERT INTO t1 VALUES (1, 1, 1);
575 # now t1 contains one row: (1, 1, 1)
576 include/include/assert_logical_timestamps.inc [0 1]
577 # TRX2: independent
578 BEGIN;
579 INSERT INTO t1 VALUES (2, 2, 2);
580 INSERT INTO t2 VALUES (1);
581 COMMIT;
582 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
583 include/include/assert_logical_timestamps.inc [1 2]
584 # TRX3: independent
585 INSERT INTO t2 VALUES (3);
586 # TRX4: depends on TRX2
587 DELETE FROM t1 WHERE a = 2;
588 # now t1 contains one row: (1, 1, 1)
589 include/include/assert_logical_timestamps.inc [1 3;2 4]
590 # TRX5: independent
591 INSERT INTO t2 VALUES (5);
592 # TRX6: conflict with TRX4 if unique, else with TRX1
593 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
594 # now t1 contains one row: (1, 2, 2)
595 include/include/assert_logical_timestamps.inc [1 5;4 6]
596 # TRX7: independent
597 INSERT INTO t1 VALUES (3, NULL, 2);
598 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
599 include/include/assert_logical_timestamps.inc [1 7]
600 # TRX8: independent
601 INSERT INTO t2 VALUES (8);
602 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
603 INSERT INTO t1 VALUES (4, NULL, 2);
604 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
605 include/include/assert_logical_timestamps.inc [1 8;1 9]
606 # TRX10: independent
607 INSERT INTO t2 VALUES (10);
608 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
609 DELETE FROM t1 WHERE a = 3;
610 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
611 include/include/assert_logical_timestamps.inc [1 10;7 11]
612 DROP TABLE t1;
613 DROP TABLE t2;
614
615 #### 1.0.1.2: WITH PK, NULLABLE, UNIQUE, 2-COLUMN INDEX ####
616
617 CREATE TABLE t1 (a INT PRIMARY KEY, b INT , c INT , UNIQUE INDEX(b, c));
618 CREATE TABLE t2 (a INT PRIMARY KEY);
619 FLUSH LOGS;
620 include/save_binlog_position.inc
621 # TRX1: independent
622 INSERT INTO t1 VALUES (1, 1, 1);
623 # now t1 contains one row: (1, 1, 1)
624 include/include/assert_logical_timestamps.inc [0 1]
625 # TRX2: independent
626 BEGIN;
627 INSERT INTO t1 VALUES (2, 2, 2);
628 INSERT INTO t2 VALUES (1);
629 COMMIT;
630 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
631 include/include/assert_logical_timestamps.inc [1 2]
632 # TRX3: independent
633 INSERT INTO t2 VALUES (3);
634 # TRX4: depends on TRX2
635 DELETE FROM t1 WHERE a = 2;
636 # now t1 contains one row: (1, 1, 1)
637 include/include/assert_logical_timestamps.inc [1 3;2 4]
638 # TRX5: independent
639 INSERT INTO t2 VALUES (5);
640 # TRX6: conflict with TRX4 if unique, else with TRX1
641 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
642 # now t1 contains one row: (1, 2, 2)
643 include/include/assert_logical_timestamps.inc [1 5;4 6]
644 # TRX7: independent
645 INSERT INTO t1 VALUES (3, NULL, 2);
646 # now t1 contains two rows: (1, 2, 2), (3, NULL, 2)
647 include/include/assert_logical_timestamps.inc [1 7]
648 # TRX8: independent
649 INSERT INTO t2 VALUES (8);
650 # TRX9: independent (no conflict with TRX7 since multiple NULLs are allowed)
651 INSERT INTO t1 VALUES (4, NULL, 2);
652 # now t1 contains three rows: (1, 2, 2), (3, NULL, 2), (4, NULL, 2)
653 include/include/assert_logical_timestamps.inc [1 8;1 9]
654 # TRX10: independent
655 INSERT INTO t2 VALUES (10);
656 # TRX11: conflict with TRX7 (not with TRX9 since multiple NULLs are allowed)
657 DELETE FROM t1 WHERE a = 3;
658 # now t1 contains two rows: (1, 2, 2), (4, NULL, 2)
659 include/include/assert_logical_timestamps.inc [1 10;7 11]
660 DROP TABLE t1;
661 DROP TABLE t2;
662
663 #### 1.1.0.0: WITH PK, NOT NULL, NOT UNIQUE, NO INDEX ####
664
665 CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL, c INT NOT NULL );
666 CREATE TABLE t2 (a INT PRIMARY KEY);
667 FLUSH LOGS;
668 include/save_binlog_position.inc
669 # TRX1: independent
670 INSERT INTO t1 VALUES (1, 1, 1);
671 # now t1 contains one row: (1, 1, 1)
672 include/include/assert_logical_timestamps.inc [0 1]
673 # TRX2: independent
674 BEGIN;
675 INSERT INTO t1 VALUES (2, 2, 2);
676 INSERT INTO t2 VALUES (1);
677 COMMIT;
678 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
679 include/include/assert_logical_timestamps.inc [1 2]
680 # TRX3: independent
681 INSERT INTO t2 VALUES (3);
682 # TRX4: depends on TRX2
683 DELETE FROM t1 WHERE a = 2;
684 # now t1 contains one row: (1, 1, 1)
685 include/include/assert_logical_timestamps.inc [1 3;2 4]
686 # TRX5: independent
687 INSERT INTO t2 VALUES (5);
688 # TRX6: conflict with TRX4 if unique, else with TRX1
689 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
690 # now t1 contains one row: (1, 2, 2)
691 include/include/assert_logical_timestamps.inc [1 5;1 6]
692 DROP TABLE t1;
693 DROP TABLE t2;
694
695 #### 1.1.0.1: WITH PK, NOT NULL, NOT UNIQUE, 1-COLUMN INDEX ####
696
697 CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL, c INT NOT NULL , INDEX(b));
698 CREATE TABLE t2 (a INT PRIMARY KEY);
699 FLUSH LOGS;
700 include/save_binlog_position.inc
701 # TRX1: independent
702 INSERT INTO t1 VALUES (1, 1, 1);
703 # now t1 contains one row: (1, 1, 1)
704 include/include/assert_logical_timestamps.inc [0 1]
705 # TRX2: independent
706 BEGIN;
707 INSERT INTO t1 VALUES (2, 2, 2);
708 INSERT INTO t2 VALUES (1);
709 COMMIT;
710 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
711 include/include/assert_logical_timestamps.inc [1 2]
712 # TRX3: independent
713 INSERT INTO t2 VALUES (3);
714 # TRX4: depends on TRX2
715 DELETE FROM t1 WHERE a = 2;
716 # now t1 contains one row: (1, 1, 1)
717 include/include/assert_logical_timestamps.inc [1 3;2 4]
718 # TRX5: independent
719 INSERT INTO t2 VALUES (5);
720 # TRX6: conflict with TRX4 if unique, else with TRX1
721 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
722 # now t1 contains one row: (1, 2, 2)
723 include/include/assert_logical_timestamps.inc [1 5;1 6]
724 DROP TABLE t1;
725 DROP TABLE t2;
726
727 #### 1.1.0.2: WITH PK, NOT NULL, NOT UNIQUE, 2-COLUMN INDEX ####
728
729 CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL, c INT NOT NULL , INDEX(b, c));
730 CREATE TABLE t2 (a INT PRIMARY KEY);
731 FLUSH LOGS;
732 include/save_binlog_position.inc
733 # TRX1: independent
734 INSERT INTO t1 VALUES (1, 1, 1);
735 # now t1 contains one row: (1, 1, 1)
736 include/include/assert_logical_timestamps.inc [0 1]
737 # TRX2: independent
738 BEGIN;
739 INSERT INTO t1 VALUES (2, 2, 2);
740 INSERT INTO t2 VALUES (1);
741 COMMIT;
742 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
743 include/include/assert_logical_timestamps.inc [1 2]
744 # TRX3: independent
745 INSERT INTO t2 VALUES (3);
746 # TRX4: depends on TRX2
747 DELETE FROM t1 WHERE a = 2;
748 # now t1 contains one row: (1, 1, 1)
749 include/include/assert_logical_timestamps.inc [1 3;2 4]
750 # TRX5: independent
751 INSERT INTO t2 VALUES (5);
752 # TRX6: conflict with TRX4 if unique, else with TRX1
753 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
754 # now t1 contains one row: (1, 2, 2)
755 include/include/assert_logical_timestamps.inc [1 5;1 6]
756 DROP TABLE t1;
757 DROP TABLE t2;
758
759 #### 1.1.1.1: WITH PK, NOT NULL, UNIQUE, 1-COLUMN INDEX ####
760
761 CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL, c INT NOT NULL , UNIQUE INDEX(b));
762 CREATE TABLE t2 (a INT PRIMARY KEY);
763 FLUSH LOGS;
764 include/save_binlog_position.inc
765 # TRX1: independent
766 INSERT INTO t1 VALUES (1, 1, 1);
767 # now t1 contains one row: (1, 1, 1)
768 include/include/assert_logical_timestamps.inc [0 1]
769 # TRX2: independent
770 BEGIN;
771 INSERT INTO t1 VALUES (2, 2, 2);
772 INSERT INTO t2 VALUES (1);
773 COMMIT;
774 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
775 include/include/assert_logical_timestamps.inc [1 2]
776 # TRX3: independent
777 INSERT INTO t2 VALUES (3);
778 # TRX4: depends on TRX2
779 DELETE FROM t1 WHERE a = 2;
780 # now t1 contains one row: (1, 1, 1)
781 include/include/assert_logical_timestamps.inc [1 3;2 4]
782 # TRX5: independent
783 INSERT INTO t2 VALUES (5);
784 # TRX6: conflict with TRX4 if unique, else with TRX1
785 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
786 # now t1 contains one row: (1, 2, 2)
787 include/include/assert_logical_timestamps.inc [1 5;4 6]
788 DROP TABLE t1;
789 DROP TABLE t2;
790
791 #### 1.1.1.2: WITH PK, NOT NULL, UNIQUE, 2-COLUMN INDEX ####
792
793 CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL, c INT NOT NULL , UNIQUE INDEX(b, c));
794 CREATE TABLE t2 (a INT PRIMARY KEY);
795 FLUSH LOGS;
796 include/save_binlog_position.inc
797 # TRX1: independent
798 INSERT INTO t1 VALUES (1, 1, 1);
799 # now t1 contains one row: (1, 1, 1)
800 include/include/assert_logical_timestamps.inc [0 1]
801 # TRX2: independent
802 BEGIN;
803 INSERT INTO t1 VALUES (2, 2, 2);
804 INSERT INTO t2 VALUES (1);
805 COMMIT;
806 # now t1 contains two rows: (1, 1, 1), (2, 2, 2)
807 include/include/assert_logical_timestamps.inc [1 2]
808 # TRX3: independent
809 INSERT INTO t2 VALUES (3);
810 # TRX4: depends on TRX2
811 DELETE FROM t1 WHERE a = 2;
812 # now t1 contains one row: (1, 1, 1)
813 include/include/assert_logical_timestamps.inc [1 3;2 4]
814 # TRX5: independent
815 INSERT INTO t2 VALUES (5);
816 # TRX6: conflict with TRX4 if unique, else with TRX1
817 UPDATE t1 SET b = 2, c = 2 WHERE a = 1;
818 # now t1 contains one row: (1, 2, 2)
819 include/include/assert_logical_timestamps.inc [1 5;4 6]
820 DROP TABLE t1;
821 DROP TABLE t2;
822 #### CLEAN UP ####
823 SET @@GLOBAL.binlog_transaction_dependency_tracking= COMMIT_ORDER;
824 Warnings:
825 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
826 SET @@GLOBAL.binlog_transaction_dependency_tracking= @save_binlog_transaction_dependency_tracking;
827 Warnings:
828 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
829 include/sync_slave_sql_with_master.inc
830 SET @@GLOBAL.replica_parallel_workers= @save_replica_parallel_workers;
831 include/rpl_end.inc