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

            Transition Time In Source Status Execution Times
            Nikita Malyavin made transition -
            Open In Progress
            		77d 19h 45m 1
            Nikita Malyavin made transition -
            In Progress Stalled
            		5d 22h 17m 1
            Nikita Malyavin made transition -
            In Progress In Testing
            		1d 24m 1
            Nikita Malyavin made transition -
            In Testing Stalled
            		10s 1
            Nikita Malyavin made transition -
            Stalled In Review
            		2m 41s 1
            Nikita Malyavin made transition -
            Stalled In Progress
            		832d 9h 29m 5
            Nikita Malyavin made transition -
            In Progress In Review
            		8d 7h 39m 4
            Aleksey Midenkov made transition -
            In Review Stalled
            		1533d 5h 35m 5

            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.