Debian Codegraph @

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

raw
1
2 --echo #
3 --echo # Bug #27453180 FOREIGN KEYS CONSTRAINTS IGNORED AFTER RENAME TABLE
4 --echo #
5
6 SET FOREIGN_KEY_CHECKS=0;
7 CREATE TABLE child (fk INT, FOREIGN KEY (fk) REFERENCES parent(pk));
8 show create table child;
9
10 SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN;
11 SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS;
12 INSERT INTO child VALUES (1);
13 CREATE TABLE parent0 (pk INT PRIMARY KEY);
14 INSERT INTO parent0 VALUES (1);
15 RENAME TABLE parent0 TO parent;
16 SET FOREIGN_KEY_CHECKS=1;
17
18 --error ER_ROW_IS_REFERENCED_2
19 DELETE FROM parent;
20
21 DROP TABLE child;
22 DROP TABLE parent;
23
24 SET FOREIGN_KEY_CHECKS=0;
25 CREATE TABLE child (fk INT, FOREIGN KEY (fk) REFERENCES parent(pk));
26 show create table child;
27
28 SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN;
29 SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS;
30 INSERT INTO child VALUES (1);
31 CREATE TABLE parent0 (pk INT PRIMARY KEY);
32 INSERT INTO parent0 VALUES (1);
33 ALTER TABLE parent0 RENAME parent;
34 SET FOREIGN_KEY_CHECKS=1;
35
36 --error ER_ROW_IS_REFERENCED_2
37 DELETE FROM parent;
38
39 DROP TABLE child;
40 DROP TABLE parent;