Bug #29859 SELECT where IS NULL after INSERT on auto-inc column returns the inserted row
| Submitted: | 17 Jul 2007 23:56 | Modified: | 18 Jul 2007 0:28 |
|---|---|---|---|
| Reporter: | mike eldridge | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S2 (Serious) |
| Version: | 5.0.32 | OS: | Linux (debian etch) |
| Assigned to: | CPU Architecture: | Any |
[17 Jul 2007 23:56]
mike eldridge
[17 Jul 2007 23:58]
mike eldridge
one more thing that may be pertinent -- i'm running the AMD64 debian distribution
[17 Jul 2007 23:58]
Jim Winstead
This is intentional behavior. See the SQL_AUTO_IS_NULL variable: http://dev.mysql.com/doc/refman/5.0/en/set-option.html
[18 Jul 2007 0:28]
mike eldridge
wow. that's odd behavior. i'm unable to find a method to disable it on a global scale. if it is truly a session-only variable, then it appears that the only way to turn this function off is to send SET SQL_AUTO_IS_NULL=0 every time that my application connects or reconnects to the database. please tell me i don't have to do this. thanks for the quick response! sorry for the spurious bug report!
[6 Dec 2008 22:12]
MySQL Verification Team
Bug: http://bugs.mysql.com/bug.php?id=41282 marked as duplicate of this one.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.