Re: bug in auto_increment on 3.23-12c on linux-alpha - Ian Ragsdale - com.mysql.lists.mysql

8 messages in com.mysql.lists.mysqlRe: bug in auto_increment on 3.23-12c...

From	Sent On	Attachments
Ian Ragsdale	10 Mar 2000 20:39
Ian Ragsdale	10 Mar 2000 20:39
Andrey Kotrekhov	13 Mar 2000 00:06
sin...@mysql.com	13 Mar 2000 04:50
Andrey Kotrekhov	13 Mar 2000 04:58
Peter TANUSKA	13 Mar 2000 05:56
sin...@mysql.com	13 Mar 2000 06:48
Nem W Schlecht	13 Mar 2000 15:44

Subject:	Re: bug in auto_increment on 3.23-12c on linux-alpha
From:	Ian Ragsdale (ia...@SKYLIST.net)
Date:	03/10/2000 08:39:23 PM
List:	com.mysql.lists.mysql

Hello again - looks like I'm giving the linux-alpha version of 3.23 a workout. Here's my new bug. When inserting a new record into a MyISAM table using NULL or 0 in an auto_increment field, the field actually gets set to 0 instead of the next value. I did this a number of times, it happens every time, and I'm the only person accessing the table.

When I revert the table to the old ISAM style, the problem goes away. Fortunately, I don't have any pressing reason to use the new style tables, so its not a problem, I just thought you guys would want to know.

If you want more info, feel free to email me.

Ian