Debian Codegraph @

mysql-test/suite/innodb_fts/r/foreign_key_update.result

raw
1 CREATE TABLE t1 (
2 a varchar(40),
3 KEY a(a)
4 ) ENGINE=InnoDB;
5 CREATE TABLE t1_fk (
6 a varchar(40),
7 KEY a(a),
8 FULLTEXT KEY (a),
9 CONSTRAINT fk FOREIGN KEY (a) REFERENCES t1 (a) ON UPDATE CASCADE
10 ) ENGINE=InnoDB;
11 INSERT INTO t1 VALUES('mysql');
12 INSERT INTO t1_fk VALUES('mysql');
13 INSERT INTO t1_fk VALUES('mysql');
14 SELECT * FROM t1_fk;
15 a
16 mysql
17 mysql
18 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
19 a
20 mysql
21 mysql
22 UPDATE t1 SET a = 'database' WHERE a = 'mysql';
23 SELECT * FROM t1_fk;
24 a
25 database
26 database
27 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
28 a
29 SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('database');
30 a
31 database
32 database
33 DROP TABLE t1_fk;
34 DROP TABLE t1;
35 #
36 # MDEV-32346 Assertion failure sym_node->table != NULL
37 # in pars_retrieve_table_def on UPDATE
38 #
39 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
40 CREATE TABLE t2 (a INT, b TEXT, FOREIGN KEY(a) REFERENCES t1(a),
41 FULLTEXT (b))ENGINE=InnoDB;
42 INSERT INTO t1 SET a=1;
43 ALTER TABLE t2 DISCARD TABLESPACE;
44 UPDATE t1 SET a=2;
45 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `t2_ibfk_1` FOREIGN KEY (`a`) REFERENCES `t1` (`a`))
46 DROP TABLE t2,t1;