Debian Codegraph @

mysql-test/suite/galera/r/galera_multirow_rollback.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
4 connection node_1;
5 START TRANSACTION;
6 INSERT INTO t1 (f2) VALUES ('a'), ('b');
7 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
8 COMMIT;
9 SELECT COUNT(*) AS expect_0 FROM t1;
10 expect_0
11 0
12 connection node_2;
13 SELECT COUNT(*) AS expect_0 FROM t1;
14 expect_0
15 0
16 DROP TABLE t1;
17 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
18 connection node_1;
19 START TRANSACTION;
20 INSERT INTO t1 VALUES (1, 'a');
21 INSERT INTO t1 VALUES (2, 'b');
22 INSERT INTO t1 (f2) VALUES ('c'), ('d');
23 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
24 COMMIT;
25 expect (1,'a'), (2, 'b')
26 SELECT * FROM t1;
27 f1 f2
28 1 a
29 2 b
30 connection node_2;
31 expect (1,'a'), (2, 'b')
32 SELECT * FROM t1;
33 f1 f2
34 1 a
35 2 b
36 DROP TABLE t1;
37 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
38 connection node_1;
39 INSERT INTO t1 (f2) VALUES ('a'),('b');
40 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
41 SELECT COUNT(*) AS expect_0 FROM t1;
42 expect_0
43 0
44 connection node_2;
45 SELECT COUNT(*) AS expect_0 FROM t1;
46 expect_0
47 0
48 DROP TABLE t1;
49 connection node_1;
50 CREATE TABLE p(id int primary key, j int) ENGINE=InnoDB;
51 CREATE TABLE c(id int primary key, fk1 int) ENGINE=InnoDB;
52 ALTER TABLE c ADD FOREIGN KEY (fk1) references p(id);
53 INSERT INTO p VALUES(1, 0);
54 START TRANSACTION;
55 INSERT INTO c VALUES (3,1);
56 INSERT INTO c VALUES (1,1), (2,2);
57 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`c`, CONSTRAINT `c_ibfk_1` FOREIGN KEY (`fk1`) REFERENCES `p` (`id`))
58 COMMIT;
59 SELECT * FROM p;
60 id j
61 1 0
62 SELECT * FROM c;
63 id fk1
64 3 1
65 connection node_2;
66 SELECT * FROM p;
67 id j
68 1 0
69 SELECT * FROM c;
70 id fk1
71 3 1
72 DROP TABLE c;
73 DROP TABLE p;