Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.8.5, 12.0.2, 12.2.1
-
Not for Release Notes
Description
Adding system versioning to an InnoDB table with a Full-Text Search key and then performing a REPLACE operation triggers an assertion failure.
Reproduction Steps
CREATE DATABASE IF NOT EXISTS HuangHe;
USE HuangHe;
CREATE TABLE t1 (
col_primary_key INTEGER AUTO_INCREMENT,
col_fulltext_key CHAR(255),
PRIMARY KEY (col_primary_key),
FULLTEXT KEY (col_fulltext_key)
) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'on');
ALTER TABLE t1 ADD SYSTEM VERSIONING;
BEGIN;
REPLACE INTO t1 VALUES(1, 'on');
REPLACE INTO t1 VALUES(1, 'on');
SELECT * FROM t1;
DROP TABLE t1;
Attachments
Issue Links
- duplicates
-
MDEV-30455 Assertion result != FTS_INVALID in fts_trx_row_get_new_state()
-
- Confirmed
-