Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Multi-row INSERT with a PK
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
10 INSERT INTO t1 VALUES (1),(2);
11
12 --connection node_2
13 INSERT INTO t1 VALUES (3),(4);
14
15 --connection node_1
16 SELECT COUNT(*) = 4 FROM t1;
17
18 --connection node_2
19 SELECT COUNT(*) = 4 FROM t1;
20
21 DROP TABLE t1;
22
23 #
24 # Multi-row INSERT without a PK
25 #
26
27 --connection node_2
28 CREATE TABLE t1 (f1 INTEGER, KEY (f1)) ENGINE=InnoDB;
29 INSERT INTO t1 VALUES (1),(1);
30
31 --connection node_1
32 INSERT INTO t1 VALUES (2),(2);
33
34 --connection node_2
35 SELECT COUNT(*) = 4 FROM t1;
36
37 --connection node_1
38 SELECT COUNT(*) = 4 FROM t1;
39
40 DROP TABLE t1;
41
42 #
43 # Error in the middle of a multi-row INSERT
44 #
45
46 --connection node_1
47 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
48
49 --error ER_DUP_ENTRY
50 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (1);
51
52 SELECT COUNT(*) = 0 FROM t1;
53
54 --connection node_2
55 SELECT COUNT(*) = 0 FROM t1;
56
57 DROP TABLE t1;
58
59 #
60 # Deadlock
61 #
62
63 --connection node_1
64 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
65
66 SET AUTOCOMMIT = OFF;
67 START TRANSACTION;
68 INSERT INTO t1 VALUES (1), (2);
69
70 --connection node_2
71 SET AUTOCOMMIT = OFF;
72 START TRANSACTION;
73 INSERT INTO t1 VALUES (2), (1);
74
75 --connection node_1
76 COMMIT;
77
78 --connection node_2
79 --error ER_LOCK_DEADLOCK
80 COMMIT;
81
82 # Workaround for mysql-wsrep#39 Transaction receives deadlock error twice in row
83 --error 0,ER_LOCK_DEADLOCK
84 ROLLBACK;
85
86 --error ER_DUP_ENTRY
87 INSERT INTO t1 VALUES (1), (2);
88
89 DROP TABLE t1;
90
91 #
92 # Rollback
93 #
94
95 --connection node_1
96 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
97
98 START TRANSACTION;
99 INSERT INTO t1 VALUES (1), (2);
100
101 --connection node_2
102 START TRANSACTION;
103 INSERT INTO t1 VALUES (2), (1);
104
105 --connection node_1
106 ROLLBACK;
107
108 --connection node_2
109 COMMIT;
110 SELECT COUNT(*) = 2 FROM t1;
111
112 --connection node_1
113 SELECT COUNT(*) = 2 FROM t1;
114
115 DROP TABLE t1;