Debian Codegraph @

mysql-test/suite/galera_sr/r/mysql-wsrep-features#22.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 AUTOCOMMIT=OFF;
6 SET SESSION wsrep_trx_fragment_size=1;
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 SAVEPOINT s1;
17 INSERT INTO t1 VALUES (11, 'b');
18 INSERT INTO t1 VALUES (12, 'b');
19 INSERT INTO t1 VALUES (13, 'b');
20 INSERT INTO t1 VALUES (14, 'b');
21 INSERT INTO t1 VALUES (15, 'b');
22 connection node_2;
23 connection node_1;
24 ROLLBACK TO SAVEPOINT s1;
25 INSERT INTO t1 VALUES (21, 'c');
26 COMMIT;
27 connection node_1;
28 SELECT COUNT(*) = 6 FROM t1;
29 COUNT(*) = 6
30 1
31 connection node_2;
32 SELECT COUNT(*) = 6 FROM t1;
33 COUNT(*) = 6
34 1
35 DROP TABLE t1;