Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/big_test.inc
4
5 #
6 # This test creates a new FK constraint while concurrent INSERTS are running
7 #
8
9 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
10 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
11
12 CREATE TABLE parent (
13 id INT PRIMARY KEY AUTO_INCREMENT,
14 f2 INTEGER
15 ) ENGINE=InnoDB;
16
17 CREATE TABLE child (
18 id INT PRIMARY KEY AUTO_INCREMENT,
19 parent_id INT
20 ) ENGINE=InnoDB;
21
22 INSERT INTO parent VALUES (1, 0);
23
24 --connection node_2
25 --send INSERT INTO child (parent_id) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
26
27 --let $galera_connection_name = node_1a
28 --let $galera_server_number = 1
29 --source include/galera_connect.inc
30 --connection node_1a
31 --send INSERT INTO parent (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
32
33 --let $galera_connection_name = node_2a
34 --let $galera_server_number = 2
35 --source include/galera_connect.inc
36 --connection node_2a
37 --send INSERT INTO parent (f2) SELECT 2 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
38
39 --let $galera_connection_name = node_1b
40 --let $galera_server_number = 1
41 --source include/galera_connect.inc
42 --connection node_1b
43 --send ALTER TABLE child ADD FOREIGN KEY (parent_id) REFERENCES parent(id);
44
45 --connection node_1a
46 --reap
47
48 --connection node_1b
49 --reap
50
51 --connection node_2
52 --reap
53
54 --connection node_2a
55 --reap
56
57 --connection node_1
58 SET SESSION wsrep_sync_wait=15;
59 SELECT COUNT(*) FROM parent;
60 SELECT COUNT(*) FROM child;
61
62 --connection node_2
63 SET SESSION wsrep_sync_wait=15;
64 SELECT COUNT(*) FROM parent;
65 SELECT COUNT(*) FROM child;
66
67 DROP TABLE child;
68 DROP TABLE parent;
69 DROP TABLE ten;