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

REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY)

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
    • 10.6, 10.11, 11.4
    • Versioned Tables
    • None

    Description

      Test case from the description of MDEV-14794 works now for timestamps, but still causes troubles with transaction IDs:

      create or replace table t1 (pk int primary key,  i int, 
        s bigint unsigned as row start,
      		 
        e bigint unsigned as row end, period for system_time(s,e))
      		 
        engine=InnoDB with system versioning;
      		 
      replace into t1 (pk,i) values (1,10),(1,100),(1,1000);

      10.3 c39f8a80c9fe

      		 
      MariaDB [test]> replace into t1 (pk,i) values (1,10),(1,100),(1,1000);
      		 
      ERROR 1062 (23000): Duplicate entry '1-18446744073709551615' for key 'PRIMARY'

      Same for stored functions and probably for triggers.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30238 LOAD DATA REPLACE into ucs2-encoded FK field fails

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35343 unexpected replace behaviour when long unique index on system versioned table

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 10 older comments
            nikitamalyavin Nikita Malyavin added a comment -

            For 10.5, we'll have a local solution from MDEV-35343

            nikitamalyavin Nikita Malyavin added a comment - For 10.5, we'll have a local solution from MDEV-35343
            nikitamalyavin Nikita Malyavin added a comment -

            midenok I've reflected the changes that you've requested, please take a look at an updated PR https://github.com/MariaDB/server/pull/3229

            nikitamalyavin Nikita Malyavin added a comment - midenok I've reflected the changes that you've requested, please take a look at an updated PR https://github.com/MariaDB/server/pull/3229
            midenok Aleksey Midenkov added a comment -

            I think the changes are incomplete. All needless changes of is_max() calls should be reverted.

            midenok Aleksey Midenkov added a comment - I think the changes are incomplete. All needless changes of is_max() calls should be reverted.
            midenok Aleksey Midenkov added a comment -

            Ok to push after merge from 10.5.

            midenok Aleksey Midenkov added a comment - Ok to push after merge from 10.5.
            nikitamalyavin Nikita Malyavin added a comment -

            It needs to be rebased, I encounter a number of conflicts, and since my change is big, it needs some time

            nikitamalyavin Nikita Malyavin added a comment - It needs to be rebased, I encounter a number of conflicts, and since my change is big, it needs some time

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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