MySQL Bugs: #45325: Workbench crashes when checking AI box

Bug #45325	Workbench crashes when checking AI box
Submitted:	4 Jun 2009 9:26	Modified:	16 Jul 2009 14:27
Reporter:	Markus Eggart	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.2.1 alpha	OS:	Linux (KUbuntu 9.04 (x86_64) - KDE 4.2)
Assigned to:		CPU Architecture:	Any
Tags:	ai, auto_increment, checkbox, CHECKED, crash

Description:
MySQL Workbench crashes when marking a column as "auto_increment". 

How to repeat:
1. Create a table
2. Insert one column and mark it as pk (could be unnecessary)
3. Create another table
4. Right click on the first table and select "Edit table ..." (in EER Diagram mode)
5. Mark the column as auto_increment

At this step workbench crashes more often then not.

If it won't crash try steps 4 and 5 at the secondary created table.

Suggested fix:
No one.
Just save before marking columns as auto_increment to avoid data loss.

I can't repeat it on  Ubuntu 9.04 (x86_64). May be KUbuntu-related.

I was able to repeat on Ubuntu 9.04 running on VirtualBox:

Segmentation fault
*** Segmentation fault
Register dump:

 EAX: bf851c01   EBX: b7eace24   ECX: 00000002   EDX: 0b02dd00
 ESI: 0b163d04   EDI: bf851cc8   EBP: bf851c88   ESP: 0b16380
<cut>

On Ubuntu 8.10 WB 5.1.12 same problem. I have found a pattern that might be a clue: New db, create three tables, no names or columns. Save and close. Reopen. Set a pk to AI on one table. Save and close. Reopen. Set a pk to AI on another table. Save and close.

Try the whole exercise again, but this time try to set two AI checkboxes in a session. Crash immediately on second checkbox, or on next save after the second checkbox.

For me, the first method avoids crashes, whereas trying to set AI a second time (ie on a another table) without close causes immediate crash or crash on next save.

This seems to imply that I am allowed once to set an AI flag in a session. Something gets choked up after that one click, though other operations continue fine.

Workaround: Before setting AI, save, and immediately after, save-close-reopen.

Uncheck AI seems to count as a AI-checkbox-interaction that causes crash. In place of checking the AI box in the above examples, uncheck. You are allowed only one per session. In sum, you are allowed only one toggle of the AI checkbox per session.

However, check and uncheck on any particular table is permitted (except as noted in the next scenario).

Another scenario to make it crash:
I happen to have an mwb that does not permit any visible toggling of the AI checkbox on several of the tables (bug filed separately). For these table, clicking on the checkbox twice will cause the next save to crash, even though no visual change occured in the box (ie the little checkmark does not appear or disappear).

Can't repeat.
This is duplicate of bug #45075. Please check with next alpha

Marked as duplicate of #45075