Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (1),(2);
6 connection node_2;
7 INSERT INTO t1 VALUES (3),(4);
8 connection node_1;
9 SELECT COUNT(*) = 4 FROM t1;
10 COUNT(*) = 4
11 1
12 connection node_2;
13 SELECT COUNT(*) = 4 FROM t1;
14 COUNT(*) = 4
15 1
16 DROP TABLE t1;
17 connection node_2;
18 CREATE TABLE t1 (f1 INTEGER, KEY (f1)) ENGINE=InnoDB;
19 INSERT INTO t1 VALUES (1),(1);
20 connection node_1;
21 INSERT INTO t1 VALUES (2),(2);
22 connection node_2;
23 SELECT COUNT(*) = 4 FROM t1;
24 COUNT(*) = 4
25 1
26 connection node_1;
27 SELECT COUNT(*) = 4 FROM t1;
28 COUNT(*) = 4
29 1
30 DROP TABLE t1;
31 connection node_1;
32 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
33 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (1);
34 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
35 SELECT COUNT(*) = 0 FROM t1;
36 COUNT(*) = 0
37 1
38 connection node_2;
39 SELECT COUNT(*) = 0 FROM t1;
40 COUNT(*) = 0
41 1
42 DROP TABLE t1;
43 connection node_1;
44 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
45 SET AUTOCOMMIT = OFF;
46 START TRANSACTION;
47 INSERT INTO t1 VALUES (1), (2);
48 connection node_2;
49 SET AUTOCOMMIT = OFF;
50 START TRANSACTION;
51 INSERT INTO t1 VALUES (2), (1);
52 connection node_1;
53 COMMIT;
54 connection node_2;
55 COMMIT;
56 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
57 ROLLBACK;
58 INSERT INTO t1 VALUES (1), (2);
59 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
60 DROP TABLE t1;
61 connection node_1;
62 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
63 START TRANSACTION;
64 INSERT INTO t1 VALUES (1), (2);
65 connection node_2;
66 START TRANSACTION;
67 INSERT INTO t1 VALUES (2), (1);
68 connection node_1;
69 ROLLBACK;
70 connection node_2;
71 COMMIT;
72 SELECT COUNT(*) = 2 FROM t1;
73 COUNT(*) = 2
74 1
75 connection node_1;
76 SELECT COUNT(*) = 2 FROM t1;
77 COUNT(*) = 2
78 1
79 DROP TABLE t1;