mirror of
https://github.com/MariaDB/server.git
synced 2025-09-11 05:52:26 +03:00
738da4918d
- During update operation, InnoDB should avoid the initializing the FTS_DOC_ID of foreign table if the foreign table is discarded
47 lines
1.1 KiB
Plaintext
47 lines
1.1 KiB
Plaintext
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;
|
|
a
|
|
mysql
|
|
mysql
|
|
SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
|
|
a
|
|
mysql
|
|
mysql
|
|
UPDATE t1 SET a = 'database' WHERE a = 'mysql';
|
|
SELECT * FROM t1_fk;
|
|
a
|
|
database
|
|
database
|
|
SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('mysql');
|
|
a
|
|
SELECT * FROM t1_fk WHERE MATCH(a) AGAINST('database');
|
|
a
|
|
database
|
|
database
|
|
DROP TABLE t1_fk;
|
|
DROP TABLE t1;
|
|
#
|
|
# MDEV-32346 Assertion failure sym_node->table != NULL
|
|
# in pars_retrieve_table_def on UPDATE
|
|
#
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
|
|
CREATE TABLE t2 (a INT, b TEXT, FOREIGN KEY(a) REFERENCES t1(a),
|
|
FULLTEXT (b))ENGINE=InnoDB;
|
|
INSERT INTO t1 SET a=1;
|
|
ALTER TABLE t2 DISCARD TABLESPACE;
|
|
UPDATE t1 SET a=2;
|
|
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`))
|
|
DROP TABLE t2,t1;
|