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;