Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 SET GLOBAL wsrep_sync_wait = 15;
4 connection node_2;
5 SET GLOBAL wsrep_sync_wait = 15;
6 connection node_1;
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
8 INSERT INTO t1 VALUES (1);
9 INSERT IGNORE INTO t1 VALUES (1), (2);
10 Warnings:
11 Warning 1062 Duplicate entry '1' for key 'PRIMARY'
12 SELECT * FROM t1;
13 f1
14 1
15 2
16 connection node_2;
17 SELECT * FROM t1;
18 f1
19 1
20 2
21 connection node_2;
22 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
23 INSERT INTO t2 VALUES (0), (2), (3);
24 INSERT IGNORE INTO t1 SELECT f1 FROM t2;
25 Warnings:
26 Warning 1062 Duplicate entry '2' for key 'PRIMARY'
27 SELECT * FROM t1;
28 f1
29 0
30 1
31 2
32 3
33 connection node_1;
34 SELECT * FROM t1;
35 f1
36 0
37 1
38 2
39 3
40 connection node_2;
41 CREATE TABLE t3 (f1 INTEGER UNIQUE) Engine=InnoDB;
42 INSERT INTO t3 VALUES (NULL);
43 connection node_1;
44 INSERT IGNORE INTO t3 VALUES (1), (NULL), (2);
45 SELECT * FROM t3;
46 f1
47 NULL
48 NULL
49 1
50 2
51 connection node_2;
52 SELECT * FROM t3;
53 f1
54 NULL
55 NULL
56 1
57 2
58 SET GLOBAL wsrep_sync_wait = (SELECT @@wsrep_sync_wait);
59 connection node_1;
60 DROP TABLE t1;
61 DROP TABLE t2;
62 DROP TABLE t3;
63 SET GLOBAL wsrep_sync_wait = (SELECT @@wsrep_sync_wait);