Debian Codegraph @

mysql-test/suite/innodb/t/add_foreign_key.test

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # Bug #19471516 SERVER CRASHES WHEN EXECUTING ALTER TABLE ADD
5 --echo # FOREIGN KEY
6 --echo #
7
8 CREATE TABLE `parent` (`parent_id` INT, PRIMARY KEY (`parent_id`));
9 CREATE TABLE `child1` (`id` INT ,`child1_fk1` INT, `child1_fk2` INT,
10 PRIMARY KEY (`id`));
11 CREATE TABLE `child2` (`id` INT, `child2_fk1` INT, `child2_fk2` INT,
12 PRIMARY KEY (`id`));
13 CREATE TABLE `child3` (`id` INT , `child3_fk1` INT, PRIMARY KEY (`id`));
14 ALTER TABLE `child1` ADD FOREIGN KEY (`child1_fk1`) REFERENCES `parent`
15 (`parent_id`);
16 ALTER TABLE `child1` ADD FOREIGN KEY (`child1_fk1`) REFERENCES
17 `parent` (`parent_id`);
18 ALTER TABLE `child1` ADD FOREIGN KEY (`child1_fk2`) REFERENCES `parent`
19 (`parent_id`);
20
21 ALTER TABLE `child2` ADD FOREIGN KEY (`child2_fk1`) REFERENCES `parent`
22 (`parent_id`);
23
24 ALTER TABLE `child2` ADD FOREIGN KEY (`child2_fk2`) REFERENCES `parent`
25 (`parent_id`);
26
27 ALTER TABLE `child3` ADD FOREIGN KEY (`child3_fk1`) REFERENCES `parent`
28 (`parent_id`);
29 ALTER TABLE `child1` ADD FOREIGN KEY (`child1_fk2`) REFERENCES
30 `parent` (`parent_id`);
31 ALTER TABLE `child2` ADD FOREIGN KEY (`child2_fk1`) REFERENCES
32 `parent` (`parent_id`);
33 ALTER TABLE `child2` ADD FOREIGN KEY (`child2_fk2`) REFERENCES
34 `parent` (`parent_id`);
35 ALTER TABLE `child3` ADD FOREIGN KEY (`child3_fk1`) REFERENCES
36 `parent` (`parent_id`);
37
38 drop table child3, child2, child1, parent;