MySQL Bugs: #62042: Alter Table's dialog box freezes unexpectedly.

Bug #62042	Alter Table's dialog box freezes unexpectedly.
Submitted:	1 Aug 2011 7:58	Modified:	7 Feb 2012 21:08
Reporter:	Michel Gokan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.34	OS:	MacOS (10.6.6)
Assigned to:		CPU Architecture:	Any

Description:
I just try to alter my previous project's tables name and my "alter table"'s dialog box freezes unexpectedly as i described in "How to repeat" section!

How to repeat:
What I did : 
1- Right click on my desired table and select "Alter Table".
2- Go to foriegn key tab.
3- Change a foreign key's name( and nothing else). For example: FK_arist_art to FK_provider_category.
4- Apply it!
5- New tab appears with name "Output" and shown an warning with text "Removed corrupt column definition for Foriegn Key FK_provider_category
6- Just close the dialog box.
7- Go to step 1 and do every step until reach step 4 and apply it!
8- Dialog box freezes and it can't be closed.

What exact Mac OS X version, 10.x.y, do you use? Can you send .mwb file that demonstrates the problem?

My Mac OS X version: 10.6.6

.mwb file that demonstrates the problem.

Attachment: bug.mwb (application/octet-stream, text), 6.28 KiB.

On Mac OS X 10.5.x (while working with local MySQL server 5.1.59) I do not see any freezing, but these 

"Warning:	Time: 17:23:08	Message: Removed corrupt column definition for Foreign Key FK_test1ededdd_hello2aaa	Details: n/a" 

messages are still strange and look like a bug.

I'm going to correct steps of this problem. ( "How to repeat" part! )

1- Right click on my desired table and select "Alter Table".
2- Go to foriegn key tab.
3- Change a foreign key's name( and nothing else). For example: FK_arist_art to
FK_provider_category.
4- Apply it!
5- New tab appears with name "Output" and shown an warning with text "Removed corrupt column definition for Foriegn Key FK_provider_category
6- First of all close that "Output" tab !
7- After closing output tab then Close the "Alter table"'s dialog box.
8- Dialog box freezes and it doesn't close!

I'm also getting the same error and behavior. In addition, before I was getting the error my tables were using 'MyISAM' engine and I was playing with adding foreign keys. I then removed my foreign keys (I believe) and altered my tables to use 'InnoDB'. With my tables altered to use 'InnoDB', I created my foreign keys and got the error described in this bug. What's the deal?

I was running version 5.2.34 and decided to update to 5.2.35 ... and now-- the entire workbench app crashes on an easily reproducible step:
Open Alter Table dialog (on table that has a simple foreign key constraint) click 'Apply' (without doing any changes) and Bam! my app crashes.

Here's part of the Problem Details:
Process:         MySQLWorkbench [68373]
Identifier:      com.sun.MySQLWorkbench
Version:         ??? (5.2.35)
Code Type:       X86 (Native)
OS Version:      Mac OS X 10.6.8 (10K549)
Exception Type:  EXC_CRASH (SIGABRT)

Please try version 5.2.37

Fixed as of 5.2.37:

On Mac OS X, clicking "Apply" within the 
"Alter Table" dialogue on a table with foreign 
constraints would crash Workbench.