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

Bad auto_increment value in innodb-autoinc.test

    XMLWordPrintable

Details

    Description

      I add this code to the very end of suite/innodb/t/innodb-autoinc.test

      CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE=INNODB;
      INSERT INTO t1 VALUES (1);
      INSERT INTO t1 VALUES ();
      SELECT * FROM t1;
      DROP TABLE t1;
      

      and run ./mtr innodb-autoinc.

      It adds the following outout:

      --- /home/bar/maria-git/server.10.3/mysql-test/suite/innodb/r/innodb-autoinc.result	2018-03-07 06:02:06.118300708 +0400
      +++ /home/bar/maria-git/server.10.3/mysql-test/suite/innodb/r/innodb-autoinc.reject	2018-06-14 10:36:04.750613391 +0400
      @@ -1369,3 +1369,11 @@
       a
       -1
       DROP TABLE t1;
      +CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE=INNODB;
      +INSERT INTO t1 VALUES (1);
      +INSERT INTO t1 VALUES ();
      +SELECT * FROM t1;
      +a
      +1
      +51
      +DROP TABLE t1;
      

      51 looks wrong. The expected value is 2.

      Attachments

        Activity

          People

            Unassigned Unassigned
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.