auto_increment in NDB tables

An auto_increment column in a NDB table starts its generated values from
zero instead of 1.

Test done using MySQL-max 4.1.3, binaries compiled by MySQL AB
(mysql-max-4.1.3-beta-pc-linux-i686.tar.gz)

Cheers

gmax


--------------------------------------------------------
How to reproduce the bug:

mysql> create table ndbtest (i int not null auto_increment primary key)
engine=ndb;

mysql> create table myisamtest (i int not null auto_increment primary
key) engine=myisam;

mysql> create table innodbtest (i int not null auto_increment primary
key) engine=innodb;

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| innodbtest |
| myisamtest |
| ndbtest |
+----------------+

mysql> insert into innodbtest values (NULL);
mysql> insert into myisamtest values (NULL);
mysql> insert into ndbtest values (NULL);

mysql> select * from myisamtest;
+---+
| i |
+---+
| 1 |
+---+

mysql> select * from innodbtest;
+---+
| i |
+---+
| 1 |
+---+

mysql> select * from ndbtest;
+---+
| i |
+---+
| 0 |
+---+



--
Giuseppe Maxia
CTO
http://www.StarData.it
__ __ __
___ / /____ ________/ /__ _/ /____ _
(_- /___/\__/\_,_/_/ \_,_/\_,_/\__/\_,_/
Database is our business


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org