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)

    XMLWordPrintable

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.5, 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

          Activity

            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.