41 lines
841 B
Plaintext
41 lines
841 B
Plaintext
#
|
|
# BUG#22094601 CREATE TABLE WITH FULLTEXT AND CONSTRAINT FAILS WHEN FOREIGN_KEY_CHECKS IS 0
|
|
#
|
|
|
|
|
|
--error ER_FK_CANNOT_OPEN_PARENT
|
|
CREATE TABLE t1 (
|
|
id INT NOT NULL,
|
|
title TEXT,
|
|
PRIMARY KEY (id),
|
|
FULLTEXT KEY (title),
|
|
FOREIGN KEY (id) REFERENCES t2 (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE t1 (
|
|
id INT NOT NULL,
|
|
title TEXT,
|
|
PRIMARY KEY (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
--error ER_FK_CANNOT_OPEN_PARENT
|
|
ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
ALTER TABLE t1 ADD FULLTEXT KEY (title), ADD FOREIGN KEY (id) REFERENCES t2 (id);
|
|
|
|
DROP TABLE t1;
|
|
|
|
CREATE TABLE t1 (
|
|
id INT NOT NULL,
|
|
title TEXT,
|
|
PRIMARY KEY (id),
|
|
FULLTEXT KEY (title),
|
|
FOREIGN KEY (id) REFERENCES t2 (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
DROP TABLE t1;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|