Debian Codegraph @

mysql-test/suite/galera/t/galera_multirow_rollback.test

raw
1 #
2 # Test multirow insert rollback
3 #
4
5 --source include/galera_cluster.inc
6
7 #
8 # Case 1: error on multirow insert results in empty transaction
9 #
10 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
11
12 --connection node_1
13 START TRANSACTION;
14 --error ER_DUP_ENTRY
15 INSERT INTO t1 (f2) VALUES ('a'), ('b');
16 COMMIT;
17
18 SELECT COUNT(*) AS expect_0 FROM t1;
19
20 --connection node_2
21 SELECT COUNT(*) AS expect_0 FROM t1;
22
23 DROP TABLE t1;
24
25
26 #
27 # Case 2: error on multirow insert does not affect previous statements
28 #
29 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
30
31 --connection node_1
32 START TRANSACTION;
33 INSERT INTO t1 VALUES (1, 'a');
34 INSERT INTO t1 VALUES (2, 'b');
35 --error ER_DUP_ENTRY
36 INSERT INTO t1 (f2) VALUES ('c'), ('d');
37 COMMIT;
38
39 --echo expect (1,'a'), (2, 'b')
40 SELECT * FROM t1;
41
42 --connection node_2
43 --echo expect (1,'a'), (2, 'b')
44 SELECT * FROM t1;
45
46 DROP TABLE t1;
47
48
49 #
50 # Case 3: error on autocommit multirow insert
51 #
52 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
53
54 --connection node_1
55 --error ER_DUP_ENTRY
56 INSERT INTO t1 (f2) VALUES ('a'),('b');
57
58 SELECT COUNT(*) AS expect_0 FROM t1;
59
60 --connection node_2
61 SELECT COUNT(*) AS expect_0 FROM t1;
62
63 DROP TABLE t1;
64
65
66 #
67 # Case 4: FK constraint violation on multirow insert
68 #
69 --connection node_1
70 CREATE TABLE p(id int primary key, j int) ENGINE=InnoDB;
71 CREATE TABLE c(id int primary key, fk1 int) ENGINE=InnoDB;
72 ALTER TABLE c ADD FOREIGN KEY (fk1) references p(id);
73 INSERT INTO p VALUES(1, 0);
74
75 START TRANSACTION;
76 INSERT INTO c VALUES (3,1);
77 --error ER_NO_REFERENCED_ROW_2
78 INSERT INTO c VALUES (1,1), (2,2);
79 COMMIT;
80
81 SELECT * FROM p;
82 SELECT * FROM c;
83
84 --connection node_2
85 SELECT * FROM p;
86 SELECT * FROM c;
87
88 DROP TABLE c;
89 DROP TABLE p;