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: Failed to open the referenced table 't2'
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: Failed to open the referenced table 't2'
16 SET FOREIGN_KEY_CHECKS = 0;
17 ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
18 Warnings:
19 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
20 DROP TABLE t1;
21 CREATE TABLE t1 (
22 id INT NOT NULL,
23 title TEXT,
24 PRIMARY KEY (id),
25 FULLTEXT KEY (title),
26 FOREIGN KEY (id) REFERENCES t2 (id)
27 ) ENGINE=InnoDB;
28 DROP TABLE t1;
29 SET FOREIGN_KEY_CHECKS = 1;