Debian Codegraph @

mysql-test/suite/innodb_fts/t/foreign_key_update.test

raw
1 #
2 # BUG#21111301 INNODB FTS: ERROR DUPLICATE ENTRY IN FTS_DOC_ID_INDEX ON UPDATE CASCADE
3 #
4 CREATE TABLE t1 (
5 a varchar(40),
6 KEY a(a)
7 ) ENGINE=InnoDB;
8
9 CREATE TABLE t1_fk (
10 a varchar(40),
11 KEY a(a),
12 FULLTEXT KEY (a),
13 CONSTRAINT fk FOREIGN KEY (a) REFERENCES t1 (a) ON UPDATE CASCADE
14 ) ENGINE=InnoDB;
15
16 INSERT INTO t1 VALUES('mysql');
17
18 INSERT INTO t1_fk VALUES('mysql');
19 INSERT INTO t1_fk VALUES('mysql');
20
21 SELECT * FROM t1_fk;
22 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
23
24 UPDATE t1 SET a = 'database' WHERE a = 'mysql';
25
26 SELECT * FROM t1_fk;
27 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
28 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('database');
29
30 DROP TABLE t1_fk;
31 DROP TABLE t1;