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

        1. DB.sql
          0.7 kB
          Dominik Shaim

        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.