32 lines
704 B
Plaintext
32 lines
704 B
Plaintext
#
|
|
# BUG#21111301 INNODB FTS: ERROR DUPLICATE ENTRY IN FTS_DOC_ID_INDEX ON UPDATE CASCADE
|
|
#
|
|
CREATE TABLE t1 (
|
|
a varchar(40),
|
|
KEY a(a)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE t1_fk (
|
|
a varchar(40),
|
|
KEY a(a),
|
|
FULLTEXT KEY (a),
|
|
CONSTRAINT fk FOREIGN KEY (a) REFERENCES t1 (a) ON UPDATE CASCADE
|
|
) ENGINE=InnoDB;
|
|
|
|
INSERT INTO t1 VALUES('mysql');
|
|
|
|
INSERT INTO t1_fk VALUES('mysql');
|
|
INSERT INTO t1_fk VALUES('mysql');
|
|
|
|
SELECT * FROM t1_fk;
|
|
SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
|
|
|
|
UPDATE t1 SET a = 'database' WHERE a = 'mysql';
|
|
|
|
SELECT * FROM t1_fk;
|
|
SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
|
|
SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('database');
|
|
|
|
DROP TABLE t1_fk;
|
|
DROP TABLE t1;
|