Bug #12181 Oracle float data conversion fails
Submitted: 26 Jul 2005 15:50 Modified: 2 Aug 2005 15:13
Reporter: Alexander Kanapin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.11 OS:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[26 Jul 2005 15:50] Alexander Kanapin
Description:
Hi,

I try to transfer my database from oracle (9.2.0.5.0) to MySQL beta (5.0.9). The column with the type FLOAT(126) is not transferred correct. It gives and error message when the migration toolkit creates the new mysql table and the datatype in the create statement is (nil). When I try to modify the statment and recreate the table again - nothing happens, the changes are not in. Tested on different tables with FLOAT type.

How to repeat:
Create a table in Oracle with column of FLOAT type. Run the migration toolkit and try to transfer the data.
[28 Jul 2005 18:55] Jorge del Conde
Thanks for your bug report.  I was able to reproduce this problem.
[2 Aug 2005 15:13] Michael G. Zinner
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html