Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 int primary key, f2 int);
5 INSERT INTO t1 VALUES (1,0);
6 BEGIN;
7 INSERT INTO t1 VALUES (2,4),(1,1);
8 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
9 COMMIT;
10 Writesets replicated (expect 0)
11 0
12 connection node_1;
13 SELECT * FROM t1;
14 f1 f2
15 1 0
16 connection node_2;
17 SELECT * FROM t1;
18 f1 f2
19 1 0
20 DROP TABLE t1;
21 connection node_1;
22 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER);
23 INSERT INTO t1 VALUES (1,0);
24 INSERT INTO t1 VALUES (2,4), (1,1);
25 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
26 Writesets replicated (expect 0)
27 0
28 connection node_1;
29 SELECT * FROM t1;
30 f1 f2
31 1 0
32 connection node_2;
33 SELECT * FROM t1;
34 f1 f2
35 1 0
36 DROP TABLE t1;