[MDEV-16486] Bad auto_increment value in innodb-autoinc.test Created: 2018-06-14  Updated: 2018-06-14  Resolved: 2018-06-14

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 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.

 Comments   
Comment by Alexander Barkov [ 2018-06-14 ]

Oops. The problem was caused by this line:

SET auto_increment_increment = 50;

earlier in the test file.

Generated at Thu Feb 08 08:29:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.