Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR) ENGINE=InnoDB;
5 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY, f2 CHAR) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (1, 'a'), (2, 'a'), (3, 'a');
7 INSERT INTO t2 VALUES (3, 'b');
8 SET SESSION wsrep_trx_fragment_size = 1;
9 INSERT INTO t2 SELECT * FROM t1;
10 ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
11 last_committed_diff
12 3
13 connection node_2;
14 connection node_1;
15 INSERT INTO t2 VALUES (1, 'c');
16 connection node_2;
17 INSERT INTO t2 VALUES (2, 'c');
18 connection node_1;
19 SELECT * FROM t2;
20 f1 f2
21 1 c
22 2 c
23 3 b
24 connection node_2;
25 SELECT * FROM t2;
26 f1 f2
27 1 c
28 2 c
29 3 b
30 connection node_1;
31 SET SESSION wsrep_trx_fragment_size = DEFAULT;
32 DROP TABLE t1;
33 DROP TABLE t2;