Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_rollback_retry.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
5 SET SESSION wsrep_trx_fragment_size = 1;
6 SET AUTOCOMMIT=OFF;
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (1);
9 INSERT INTO t1 VALUES (2);
10 INSERT INTO t1 VALUES (3);
11 INSERT INTO t1 VALUES (4);
12 INSERT INTO t1 VALUES (5);
13 connection node_2;
14 connection node_1;
15 ROLLBACK;
16 connection node_2;
17 SELECT * FROM t1;
18 f1
19 SET AUTOCOMMIT=OFF;
20 START TRANSACTION;
21 INSERT INTO t1 VALUES (1);
22 INSERT INTO t1 VALUES (2);
23 INSERT INTO t1 VALUES (3);
24 INSERT INTO t1 VALUES (4);
25 INSERT INTO t1 VALUES (5);
26 COMMIT;
27 SELECT COUNT(*) AS EXPECT_5 FROM t1;
28 EXPECT_5
29 5
30 connection node_1;
31 SELECT COUNT(*) AS EXPECT_5 FROM t1;
32 EXPECT_5
33 5
34 DROP TABLE t1;