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
5 -- source include/have_innodb.inc
6
7 CREATE TABLE t1 (
8 a varchar(40),
9 KEY a(a)
10 ) ENGINE=InnoDB;
11
12 CREATE TABLE t1_fk (
13 a varchar(40),
14 KEY a(a),
15 FULLTEXT KEY (a),
16 CONSTRAINT fk FOREIGN KEY (a) REFERENCES t1 (a) ON UPDATE CASCADE
17 ) ENGINE=InnoDB;
18
19 INSERT INTO t1 VALUES('mysql');
20
21 INSERT INTO t1_fk VALUES('mysql');
22 INSERT INTO t1_fk VALUES('mysql');
23
24 SELECT * FROM t1_fk;
25 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
26
27 UPDATE t1 SET a = 'database' WHERE a = 'mysql';
28
29 SELECT * FROM t1_fk;
30 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
31 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('database');
32
33 DROP TABLE t1_fk;
34 DROP TABLE t1;
35
36 --echo #
37 --echo # MDEV-32346 Assertion failure sym_node->table != NULL
38 --echo # in pars_retrieve_table_def on UPDATE
39 --echo #
40 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
41 CREATE TABLE t2 (a INT, b TEXT, FOREIGN KEY(a) REFERENCES t1(a),
42 FULLTEXT (b))ENGINE=InnoDB;
43 INSERT INTO t1 SET a=1;
44 ALTER TABLE t2 DISCARD TABLESPACE;
45 --error ER_ROW_IS_REFERENCED_2
46 UPDATE t1 SET a=2;
47 DROP TABLE t2,t1;