Debian Codegraph @

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

raw
1 --source include/big_test.inc
2 --source include/galera_cluster.inc
3 --source include/have_innodb.inc
4
5 #
6 # This test creates a new FK constraint while an UPDATE is running
7 #
8
9 CREATE TABLE ten (f1 INTEGER) 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,
14 KEY (id)
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);
23
24 INSERT INTO child (parent_id) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
25
26 --connection node_1
27 --sleep 1
28 --send ALTER TABLE child ADD FOREIGN KEY (parent_id) REFERENCES parent(id) ON UPDATE CASCADE;
29
30 --connection node_2
31 --sleep 1
32 --send UPDATE parent SET id = 2 WHERE id = 1;
33
34 --connection node_1
35 --reap
36
37 --connection node_2
38 --reap
39
40 --connection node_2
41 SELECT COUNT(*) = 10000 FROM child WHERE parent_id = 2;
42
43 --connection node_1
44 SELECT COUNT(*) = 10000 FROM child WHERE parent_id = 2;
45
46 DROP TABLE child;
47 DROP TABLE parent;
48
49 DROP TABLE ten;