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

Set AUTO_INCREMENT below max value of column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.7
    • Fix Version/s: 10.0.8
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      Setting AUTO_INCREMENT is prohibited to value that smaller than the max value of the AUTO_INCREMENT column, but MariaDB 10.0.7 doing this:

      mysql> select version();
      +-------------------------+
      | version()               |
      +-------------------------+
      | 10.0.7-MariaDB-1~wheezy |
      +-------------------------+
      1 row in set (0.00 sec)
       
      mysql>
      mysql> CREATE TABLE test(
          -> id int(10)unsigned NOT NULL AUTO_INCREMENT,
          -> duma varchar(255)NOT NULL,
          -> PRIMARY KEY(id)
          -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
      Query OK, 0 rows affected (0.01 sec)
       
      mysql>
      mysql> INSERT INTO test(id,duma)VALUES(1,'aaa'),(2,'bbb');
      Query OK, 2 rows affected (0.00 sec)
      Records: 2  Duplicates: 0  Warnings: 0
       
      mysql>
      mysql> ALTER TABLE test AUTO_INCREMENT=1;
      Query OK, 0 rows affected (0.01 sec)
      Records: 0  Duplicates: 0  Warnings: 0
       
      mysql>
      mysql> INSERT INTO test(duma)VALUES('ccc');
      ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
      mysql>
       

      The AUTO_INCREMENT must be set to 3, not 1.

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              LaySoft Lay András
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: