INSERT is changing column value

[joe conery]

I recently upgraded MySql from mysql-standard-4.0.20-apple-darwin7.3.0-powerpc to
mysql-max-4.1.7-apple-darwin7.5.0-pwerpc.

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.