Re: mysql_insert_id Bug
Hans Zaunere <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Boyd Lynn Gerber wrote: > On Tue, 11 Aug 2003, Hans Zaunere wrote: > >>http://lists.mysql.com/list.php?9:mss:14894:200308:pgbmapllcppekmkmgbak >> >>I may have stumbled on some either incorrect, or incorrectly documented, >>behavior with >>mysql_insert_id() and I'd like to hear some feedback. >> >>>From http://www.mysql.com/doc/en/mysql_insert_id.html: >> >>"Note that mysql_insert_id() returns 0 if the previous query does not >>generate an AUTO_INCREMENT >>value." >> >>However, when inserting a non-unique value into a table with a UNIQUE >>index, thus making >>the INSERT fail and no AUTO_INCREMENT value being generated, >>mysql_insert_id() returns >>the value of the last successful INSERT statement. I understand that this >>is the correct >>behavior for the SQL function LAST_INSERT_ID() (which is not reset between >>queries), >>however not for the C API function mysql_insert_id(). >> >>Please see below for a C program that illustrates this, as well as my >>current environment. >> >> Any insight would be helpful. Thanks, > > > The documentation is wrong. We will get it updated Thanks for looking into this. I'll report this to the PHPdoc team so they can update as well. Hans Zaunere President, New York PHP http://nyphp.org [email protected] -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]