Debian Codegraph @

mysql-test/suite/galera/r/MDEV-22021.result

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