MySQL Bugs: #34168: MySQL Workbench crashes when deleting columns

Bug #34168	MySQL Workbench crashes when deleting columns
Submitted:	30 Jan 2008 15:26	Modified:	29 Feb 2008 8:33
Reporter:	Daniel Haas	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.12 SE	OS:	Windows (Vista)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
It just occured me that workbench crashed when deleting (multiple) columns. (See attached screenshot).

After clicking on "Weiter" (continue) on the message box, all columns still stay there, but the last one (the one which was under the mouse when right clicking) is suddenly no index-column anymore. (The key-icon is replaced with the standard diamond-icon). - Perhaps that helps in diagnosing the error.

I will attach the stacktrace and the workbench-file which shows the error.

How to repeat:
Appearently this only happens if the selected columns are columns automatically created from a foreign-key constraint. - That means columns which refer to indexed data in the foreign-table.

Note: This columns come from a DBDesigner4-imported file which automatically creates such columns.

- I just found out that this happens also when just deleting one of these columns. MySQL Workbench always crashes when deleting one of these columns.

So to repeat:
1. Create a model with foreign-key constraints in DBDesigner4
2. Import the model within workbench
3. Try to delete one of the autogenerated columns from the foreign table.

Suggested fix:
MySQL Workbench should just delete the columns as expected.

Screenshot showing the stacktrace.

Attachment: deleting_columns.png (image/png, text), 234.55 KiB.

The complete text of the stacktrace.

Attachment: stacktrace.txt (text/plain), 7.86 KiB.

Hi

Would it be possible to attach a sample model? Thanks!

What exact column should I try to delete after loading your model?

As visible in the screenshot, try to delete one of the trains_* columns in the train_run_messages table.
These are the auto generated columns which originally just refer to the keys in the foreign table trains.

I wasn't able to repeat using the model provided and instructions with
your last comment:'As visible in the screenshot, try to delete one of the trains_* columns in the train_run_messages table.'. I tried on XP and I am asking to co-worker to try on Vista.

Unfortunatly, after restarting Workbench and loading the file I had attached, i wasn't able to reproduce the bug. - Sorry. Yesterday it happend for me on every row, and i was only able to delete them once they went from key-icon to diamond-icon (by pressing continue in the error dialog).
I keep you posted if i encounter the bug again.

Daniel, thank you for the additional information.

Set sttus of bug to "Need feedback" as your feedback is needed.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".