Debian Codegraph @

mysql-test/suite/galera/t/MDEV-22021.test

raw
1 #
2 # SAVEPOINT ROLLBACK can introduce inconsistency in cluster.
3 #
4
5 --source include/galera_cluster.inc
6
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
8
9 START TRANSACTION;
10 INSERT INTO t1 VALUES (1);
11 SAVEPOINT sp1;
12 INSERT INTO t1 VALUES (2);
13 ROLLBACK TO SAVEPOINT sp1;
14 COMMIT;
15
16 SELECT COUNT(*) = 1 FROM t1;
17
18 --connection node_2
19 SELECT COUNT(*) = 1 FROM t1;
20
21 --connection node_1
22 DELETE FROM t1;
23
24 START TRANSACTION;
25 SAVEPOINT sp1;
26 INSERT INTO t1 VALUES (1);
27 SAVEPOINT sp2;
28 INSERT INTO t1 VALUES (2);
29 ROLLBACK TO SAVEPOINT sp2;
30 ROLLBACK TO SAVEPOINT sp1;
31 COMMIT;
32
33 SELECT COUNT(*) = 0 FROM t1;
34 --connection node_2
35 SELECT COUNT(*) = 0 FROM t1;
36
37 --connection node_1
38 DELETE FROM t1;
39
40 START TRANSACTION;
41 SAVEPOINT sp1;
42 INSERT INTO t1 VALUES (1);
43 INSERT INTO t1 VALUES (2);
44 INSERT INTO t1 VALUES (3);
45 INSERT INTO t1 VALUES (4);
46 SAVEPOINT sp2;
47 INSERT INTO t1 VALUES (5);
48 ROLLBACK TO SAVEPOINT sp2;
49 INSERT INTO t1 VALUES (6);
50 INSERT INTO t1 VALUES (7);
51 ROLLBACK TO SAVEPOINT sp1;
52 INSERT INTO t1 VALUES (8);
53 COMMIT;
54
55 SELECT COUNT(*) = 1 FROM t1;
56
57 --connection node_2
58 SELECT COUNT(*) = 1 FROM t1;
59
60 DROP TABLE t1;