Bug #12825 Reverse engineering hangs up when table contains many columns

• Submitted: 26 Aug 2005 9:49
• Modified: 30 Aug 2005 21:21
• Reporter: Sadao Hiratsuka (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Migration Toolkit
• Severity: S2 (Serious)
• Version: 1.0.14
• OS: Windows (WindowsXP)
• CPU Architecture: Any

[26 Aug 2005 9:49] Sadao Hiratsuka

Description:
During migration from Oracle to MySQL,
Reverse engineering hangs up when table contains many columns.

How to repeat:
I tested with Oracle 9.2.0.6 and MySQL 5.0.10.
I created this table contains 1,000 columns, and tried migration.

create table test014_manycolumn (
col1 varchar2(1),
col2 varchar2(1),
col3 varchar2(1),
col4 varchar2(1),
col5 varchar2(1),
...
col999 varchar2(1)
col1000 varchar2(1)
)
/

Suggested fix:
According to detailed log, problem happens after this method.
--> revEng.reverseEngineerUpdateFkReferences(catalog);

[30 Aug 2005 20:43] Jorge del Conde

Thanks for your bug report

I was able to reproduce this bug using 1000 table columns

[30 Aug 2005 21:21] 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