Bug #67743 | INSERT followed by SELECT on fields not null having a default value | ||
---|---|---|---|
Submitted: | 28 Nov 2012 14:42 | Modified: | 28 Nov 2012 16:45 |
Reporter: | BRUNO AUGIER | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.32 | OS: | Linux (Debian) |
Assigned to: | CPU Architecture: | Any | |
Tags: | auto_increment, count, insert, NOT NULL, SELECT |
[28 Nov 2012 14:42]
BRUNO AUGIER
[28 Nov 2012 15:30]
MySQL Verification Team
Perhaps you also hit a race condition bug if the timing is really important? e.g. http://bugs.mysql.com/bug.php?id=37521 So, please upgrade to 5.5.28 and check if your tests still fail.. 5.0.32 is truly too old for consideration, and full of bugs too.
[28 Nov 2012 15:58]
BRUNO AUGIER
Thanks for your fast answers! I think your first answer was right, it seems related to this strange feature "sql_auto_is_null", it should be considered as "not a bug" http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_sql_auto_is_nul...
[28 Nov 2012 16:45]
Sveta Smirnova
Thank you for the feedback. Closed as "Not a Bug".