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 Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.36 OS:MacOS (Lion)
Assigned to: CPU Architecture:Any
Tags: removed corrupt column definitom error foreign key

[16 Dec 2011 12:15] Adrian Grund
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.