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 --source include/have_innodb.inc
6
7 --error ER_CANT_CREATE_TABLE
8 CREATE TABLE t1 (
9 id INT NOT NULL,
10 title TEXT,
11 PRIMARY KEY (id),
12 FULLTEXT KEY (title),
13 FOREIGN KEY (id) REFERENCES t2 (id)
14 ) ENGINE=InnoDB;
15
16 CREATE TABLE t1 (
17 id INT NOT NULL,
18 title TEXT,
19 PRIMARY KEY (id)
20 ) ENGINE=InnoDB;
21
22 --error ER_CANT_CREATE_TABLE
23 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
24
25 SET FOREIGN_KEY_CHECKS = 0;
26
27 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
28
29 DROP TABLE t1;
30
31 CREATE TABLE t1 (
32 id INT NOT NULL,
33 title TEXT,
34 PRIMARY KEY (id),
35 FULLTEXT KEY (title),
36 FOREIGN KEY (id) REFERENCES t2 (id)
37 ) ENGINE=InnoDB;
38
39 DROP TABLE t1;
40
41 SET FOREIGN_KEY_CHECKS = 1;