Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
5 CREATE TABLE parent (
6 id INT PRIMARY KEY AUTO_INCREMENT,
7 f2 INTEGER
8 ) ENGINE=InnoDB;
9 CREATE TABLE child (
10 id INT PRIMARY KEY AUTO_INCREMENT,
11 parent_id INT
12 ) ENGINE=InnoDB;
13 INSERT INTO parent VALUES (1, 0);
14 connection node_2;
15 INSERT INTO child (parent_id) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;;
16 connection node_1a;
17 INSERT INTO parent (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;;
18 connection node_2a;
19 INSERT INTO parent (f2) SELECT 2 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;;
20 connection node_1b;
21 ALTER TABLE child ADD FOREIGN KEY (parent_id) REFERENCES parent(id);;
22 connection node_1a;
23 connection node_1b;
24 connection node_2;
25 connection node_2a;
26 connection node_1;
27 SET SESSION wsrep_sync_wait=15;
28 SELECT COUNT(*) FROM parent;
29 COUNT(*)
30 20001
31 SELECT COUNT(*) FROM child;
32 COUNT(*)
33 10000
34 connection node_2;
35 SET SESSION wsrep_sync_wait=15;
36 SELECT COUNT(*) FROM parent;
37 COUNT(*)
38 20001
39 SELECT COUNT(*) FROM child;
40 COUNT(*)
41 10000
42 DROP TABLE child;
43 DROP TABLE parent;
44 DROP TABLE ten;