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

Auto Increment is increasing while using INSERT IGNORE INTO and UNIQUE index

    XMLWordPrintable

Details

    Description

      I am attaching test DB with simulated problem:
      DB.sql

      How to simulate properly:
      A) import DB
      B) run 5 times this query:
      INSERT IGNORE INTO `aaa` SET `c` = 'cz', `b` = 1, `a` = 8;
      C) auto increment will be increased for 5 (unwanted behaviour - there is no reason to increase auto increment)

      We have now tens of millions unwanted auto increment increased.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            shaim Dominik Shaim
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.