Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER, f2 VARCHAR(10)) ENGINE=InnoDB;
5 SET SESSION wsrep_trx_fragment_size = 1;
6 SET AUTOCOMMIT=OFF;
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (1, 'a');
9 INSERT INTO t1 VALUES (2, 'a');
10 INSERT INTO t1 VALUES (3, 'a');
11 INSERT INTO t1 VALUES (4, 'a');
12 INSERT INTO t1 VALUES (5, 'a');
13 connection node_2;
14 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15 connection node_1;
16 INSERT INTO t1 VALUES (11, 'b');
17 INSERT INTO t1 VALUES (12, 'b');
18 INSERT INTO t1 VALUES (13, 'b');
19 INSERT INTO t1 VALUES (14, 'b');
20 INSERT INTO t1 VALUES (15, 'b');
21 connection node_2;
22 connection node_1;
23 ROLLBACK;
24 connection node_2;
25 connection node_1;
26 START TRANSACTION;
27 INSERT INTO t1 VALUES (1, 'a');
28 INSERT INTO t1 VALUES (2, 'a');
29 INSERT INTO t1 VALUES (3, 'a');
30 INSERT INTO t1 VALUES (4, 'a');
31 INSERT INTO t1 VALUES (5, 'a');
32 INSERT INTO t1 VALUES (11, 'b');
33 INSERT INTO t1 VALUES (12, 'b');
34 INSERT INTO t1 VALUES (13, 'b');
35 INSERT INTO t1 VALUES (14, 'b');
36 INSERT INTO t1 VALUES (15, 'b');
37 connection node_2;
38 connection node_1;
39 COMMIT;
40 connection node_2;
41 connection node_1;
42 DROP TABLE t1;