| 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 |