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

unexpected replace behaviour when long unique index on system versioned table

Details

    Description

      Test case to repeat the failure:

      CREATE TABLE t1 (data VARCHAR(7961));
      		 
      INSERT INTO t1 VALUES ('f'), ('o'), ('o');
      		 
      ALTER IGNORE TABLE t1 ADD UNIQUE INDEX (data);
      		 
      ALTER IGNORE TABLE t1 ADD UNIQUE INDEX (data(1));
      		 
      SELECT * FROM t1;
      		 
      SHOW CREATE TABLE t1;
      		 
      ALTER TABLE t1 ADD SYSTEM VERSIONING ;
      		 
      SELECT * FROM t1;
      		 
      REPLACE INTO t1 VALUES ('f'), ('o'), ('o');

      mysqltest: At line 10: query 'REPLACE INTO t1 VALUES ('f'), ('o'), ('o')' failed: 1062: Duplicate entry 'o' for key 'data'

      This problem happens when versioning + long unique hash index involved.
      In write_record(), if the failed unique index is not last then we do
      delete the record and insert again. Since it is a versioning table,
      we do try to ha_update_row(). But it fails in check_duplicate_long_entries_update()
      and returns HA_ERR_FOUND_DUPP_KEY. Irrespective of engine, behaviour is same.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36208 dbug_print_table_row is broken: prints empty rows in debugger

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36507 fix dbug_print_row concurrent access

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15990 REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY)

          • Major - Major loss of function.
          • Stalled

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            		34d 10h 48m 1
            Aleksey Midenkov made transition -
            In Progress In Review
            		7d 17h 19m 1
            Nikita Malyavin made transition -
            In Review Stalled
            		21d 4h 22m 1
            Aleksey Midenkov made transition -
            Stalled Closed
            		7d 4h 5m 1

            People

              midenok Aleksey Midenkov
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.