Bug #46405 | Incorrect behaviour of Auto Increment field after server restart. | ||
---|---|---|---|
Submitted: | 27 Jul 2009 13:53 | Modified: | 27 Aug 2009 14:07 |
Reporter: | Jon Swain | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.51b | OS: | Windows (XP) |
Assigned to: | CPU Architecture: | Any |
[27 Jul 2009 13:53]
Jon Swain
[27 Jul 2009 14:07]
MySQL Verification Team
Thank you for the bug report. Could you please try with latest release and comment the result. Thanks in advance.
[27 Jul 2009 15:03]
Valeriy Kravchuk
I can't repeat this with recent 5.1.38 for example: ... Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.38-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> DELETE FROM test WHERE AutoID=3; Query OK, 1 row affected (0.04 sec) mysql> INSERT INTO test SET Name='Four'; Query OK, 1 row affected (0.00 sec) mysql> select * from test; +--------+------+ | AutoID | Name | +--------+------+ | 1 | One | | 2 | Two | | 4 | Four | +--------+------+ 3 rows in set (0.00 sec)
[27 Aug 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".