Debian Codegraph @

mysql-test/suite/innodb_fts/t/foreign_key_check.test

raw
1 #
2 # BUG#22094601 CREATE TABLE WITH FULLTEXT AND CONSTRAINT FAILS WHEN FOREIGN_KEY_CHECKS IS 0
3 #
4
5
6 --error ER_FK_CANNOT_OPEN_PARENT
7 CREATE TABLE t1 (
8 id INT NOT NULL,
9 title TEXT,
10 PRIMARY KEY (id),
11 FULLTEXT KEY (title),
12 FOREIGN KEY (id) REFERENCES t2 (id)
13 ) ENGINE=InnoDB;
14
15 CREATE TABLE t1 (
16 id INT NOT NULL,
17 title TEXT,
18 PRIMARY KEY (id)
19 ) ENGINE=InnoDB;
20
21 --error ER_FK_CANNOT_OPEN_PARENT
22 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
23
24 SET FOREIGN_KEY_CHECKS = 0;
25
26 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
27
28 DROP TABLE t1;
29
30 CREATE TABLE t1 (
31 id INT NOT NULL,
32 title TEXT,
33 PRIMARY KEY (id),
34 FULLTEXT KEY (title),
35 FOREIGN KEY (id) REFERENCES t2 (id)
36 ) ENGINE=InnoDB;
37
38 DROP TABLE t1;
39
40 SET FOREIGN_KEY_CHECKS = 1;