Debian Codegraph @

mysql-test/suite/innodb_fts/r/foreign_key_check.result

raw
1 CREATE TABLE t1 (
2 id INT NOT NULL,
3 title TEXT,
4 PRIMARY KEY (id),
5 FULLTEXT KEY (title),
6 FOREIGN KEY (id) REFERENCES t2 (id)
7 ) ENGINE=InnoDB;
8 ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed")
9 CREATE TABLE t1 (
10 id INT NOT NULL,
11 title TEXT,
12 PRIMARY KEY (id)
13 ) ENGINE=InnoDB;
14 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
15 ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed")
16 SET FOREIGN_KEY_CHECKS = 0;
17 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
18 DROP TABLE t1;
19 CREATE TABLE t1 (
20 id INT NOT NULL,
21 title TEXT,
22 PRIMARY KEY (id),
23 FULLTEXT KEY (title),
24 FOREIGN KEY (id) REFERENCES t2 (id)
25 ) ENGINE=InnoDB;
26 DROP TABLE t1;
27 SET FOREIGN_KEY_CHECKS = 1;