MySQL Bugs: #32958: Deleting FK silently removes the columns

Bug #32958	Deleting FK silently removes the columns
Submitted:	4 Dec 2007 12:53	Modified:	1 Feb 2008 13:06
Reporter:	Roland Bouman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.11a SE, 5.0.10 OSS	OS:	Any
Assigned to:	Johannes Taxacher	CPU Architecture:	Any

Description:
When you delete a FK, the FK columns are silently removed. 

At the very least, you should be prompted for it.

Better still, it should configurable whether this should occur, and whether you should be promted for it.

How to repeat:
create a relationship, delete it.

Suggested fix:
At the very least, you should be prompted for the removal. Silent removal is a no-no.

Better still, it should configurable whether this should occur, and whether you should be prompted for it.

Thank you for the bug report. Which version of MySQL Workbench are you using.
I wasn't able to repeat with version 5.0.10. If you are using the same version
could you please provide a screen-shot of the tables before to mark to delete?.
Thanks in advance.

model to reproduce the issue

Attachment: test.mwb (application/octet-stream, text), 4.81 KiB.

screensshot step 1

Attachment: wb32958step1.PNG (image/png, text), 60.25 KiB.

step 2, observe removal of columns

Attachment: wb32958step2.PNG (image/png, text), 54.81 KiB.

step 3, oberve how undo messes up original column order

Attachment: wb32958step3.PNG (image/png, text), 57.12 KiB.

Thank you for the bug report.

the user is promted now if the columns related to the FK should be removed too

works in 5.0.12 SVN Rev 2471