INSERT is changing column value
Posted by: joe conery
Date: December 01, 2004 10:32AM

I recently upgraded MySql from mysql-standard-4.0.20-apple-darwin7.3.0-powerpc to

programming in Java using mysql-connector-java-3.0.15-ga-bin.jar
I'm on a couple of Macs 10.3.4 and 10.2.8.

I didn't have any problems with the old version of the database, but when using the upgraded version, after inserting about 1000 rows, one of my columns of type double (10,6) inserts a value of 9999.999999 instead of the correct value.

I have since created pointed the mysql symbolic link back to the old version of the database and have not had the problem since. The actual value that I'm attempting to insert does not approach the limits of the column's precision. This is very frustrating, since I would like to be able to use subqueries which the upgraded db provides for.

Options: ReplyQuote

Written By
INSERT is changing column value
December 01, 2004 10:32AM

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.