Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --let $wsrep_sync_wait_orig = (SELECT @@wsrep_sync_wait)
5 SET GLOBAL wsrep_sync_wait = 15;
6
7 --connection node_2
8 SET GLOBAL wsrep_sync_wait = 15;
9
10
11 #
12 # INSERT IGNORE with PRIMARY KEY
13 #
14
15 --connection node_1
16 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
17 INSERT INTO t1 VALUES (1);
18
19 INSERT IGNORE INTO t1 VALUES (1), (2);
20 SELECT * FROM t1;
21
22 --connection node_2
23 SELECT * FROM t1;
24
25 #
26 # INSERT IGNORE ... SELECT
27 #
28
29 --connection node_2
30 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
31 INSERT INTO t2 VALUES (0), (2), (3);
32 INSERT IGNORE INTO t1 SELECT f1 FROM t2;
33
34 SELECT * FROM t1;
35 --connection node_1
36 SELECT * FROM t1;
37
38 #
39 # INSERT IGNORE with UNIQUE + NULLs
40 #
41
42 --connection node_2
43 CREATE TABLE t3 (f1 INTEGER UNIQUE) Engine=InnoDB;
44 INSERT INTO t3 VALUES (NULL);
45
46 --connection node_1
47 INSERT IGNORE INTO t3 VALUES (1), (NULL), (2);
48 SELECT * FROM t3;
49
50 --connection node_2
51 SELECT * FROM t3;
52
53 --eval SET GLOBAL wsrep_sync_wait = $wsrep_sync_wait_orig
54
55 --connection node_1
56 DROP TABLE t1;
57 DROP TABLE t2;
58 DROP TABLE t3;
59 --eval SET GLOBAL wsrep_sync_wait = $wsrep_sync_wait_orig