Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38156

Assertion result != FTS_INVALID in fts_trx_row_get_new_state()

    XMLWordPrintable

Details

    • 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

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              maohaogang maohaogang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.