MySQL Forums
Forum List  »  Quality Assurance

Advanced Search
New Topic

Re: INSERT INTO ... ON DUPLICATE KEY UPDATE
Posted by: Matthias Philipp
Date: June 23, 2010 03:33AM

This is bug #29180 and has been fixed in later versions than 5.0.41. An MySQL upgrade on this server did the trick.

http://bugs.mysql.com/bug.php?id=29180

Strange: I still get different results when I compare the output of MySQL version 5.0.45 (production server) and the new installed 5.1.48 on the development mashine. Both give correct results, but the autoincrement ID of the newly inserted line is "7" with 5.0.45 and "6" with 5.1.48.

KR,
Matschek

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
INSERT INTO ... ON DUPLICATE KEY UPDATE [SOLVED]
4209
Matthias Philipp
June 18, 2010 05:53AM
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE
2745
Matthias Philipp
June 23, 2010 03:33AM
Re: INSERT INTO ... ON DUPLICATE KEY UPDATE [SOLVED]
1574
avid hoster
July 04, 2010 11:59PM


Sorry, you can't reply to this topic. It has been closed.

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.