Bug #63772 Removed corrupt column defintion error for foreign key

• Submitted: 16 Dec 2011 12:15
• Modified: 23 Jul 2012 17:45
• Reporter: Adrian Grund
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S1 (Critical)
• Version: 5.2.36
• OS: MacOS (Lion)
• CPU Architecture: Any
• Tags: removed corrupt column definitom error foreign key

[16 Dec 2011 12:15] Adrian Grund

Description:
I have some Inno-DB datatables "connected" with foreign keys. All work fine in Navicat, no error at all.
When I try to alter any of the tables in ANY kind (e.g. just by altering any row that is NOT set with a foreign key), always the output window of mySQLWorkbench gives the following error code:
Removed corrupt column definition for Foreign key …..
Then the foreign key is not shown in the data table view….
When I reload the table again it is shown and everything is fine...

How to repeat:
Create a datatable with some foreign keys.
Try to alter anything in a table with foreign keys….

[16 Dec 2011 12:18] Adrian Grund

I changed the category of the bug.

[16 Dec 2011 13:28] Valeriy Kravchuk

Please, send .sql script og .mwb file to create the database that demonstrates the problem for you.

[17 Dec 2011 14:57] Valeriy Kravchuk

Verified just as described using .sql file uploaded and MySQL server 5.5.20 on Mac OS X 10.5.x.

[20 Dec 2011 7:25] Adrian Grund

Is there ane idea when a fix will be there approx., because due to this error I cannot work on my project…. thank you.

[23 Jul 2012 17:45] Philip Olson

This has been fixed as of the soon-to-be-released Workbench 5.2.41, and 
here's the changelog entry:

A "Removed corrupt column definition for Foreign key" error would
sometimes be emitted while editing a table with foreign keys.