Bug #4180 auto_increment=x does not work with InnoDB
Submitted: 17 Jun 2004 6:16 Modified: 24 Jan 2005 8:39
Reporter: Jeremy Cole (Basic Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: Heikki Tuuri CPU Architecture:Any

[17 Jun 2004 6:16] Jeremy Cole 
Description:
The auto_increment table option does not work with InnoDB tables and seems to be ignored.

How to repeat:
mysql> create table aitest (i int not null auto_increment primary key, c char(20) not null) auto_increment=1000 type=innodb;
Query OK, 0 rows affected, 1 warning (0.35 sec)

mysql> insert into aitest (c) values ("test");
Query OK, 1 row affected (0.10 sec)

mysql> select * from aitest;
+---+------+
| i | c    |
+---+------+
| 1 | test |
+---+------+
1 row in set (0.00 sec)
[14 Jul 2004 9:06] MySQL Verification Team 
Verified against latest 4.1 source tree server.
[24 Jan 2005 8:39] Jan Lindström 
Fixed in 5.0.3.