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

      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

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.