> -----Original Message----- > From: Richard Davidson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 1:31 PM > To: MySql List; [EMAIL PROTECTED] > Subject: FYI: @@IDENTITY > > > > I don't know if this is just weirdness on my system but I > thought I would > pass this on in case anyone runs into this problem. I'm > converting some > Java/JDBC code from a commercial DBMS to MySQL. The existing > code executed > the SQL statement "Select @@identity" after an INSERT to retrieve the > autoincrement value. But, MySQL would never return from this > query -- just > hang until I stopped and restarted the service. > > After some trial-and-error-and-error, I found that > "@@IDENTITY" worked as > expected but "@@identity" would cause this "hang" symptom. > > Moral of the story: don't use lower case letters in "SELECT > @@IDENTITY". >
This is fixed from MySQL 3.23.50 and 4.0.2 versions, so you can give a try with the 3.23.50 from: http://www.mysql.com/downloads/mysql-3.23-pre.html Make a note that, the Windows binaries are not pre-releases, and they are official and can be used in production. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
