Bug #32524 Deleting a relationship leaves refered columns.
Submitted: 20 Nov 2007 14:06 Modified: 27 Nov 2007 11:34
Reporter: marc castrovinci (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.09 OSS BETA OS:Windows (XP SP2)
Assigned to: Johannes Taxacher CPU Architecture:Any
Tags: column, fk, many, one, pk, qc, relationship, restraint

[20 Nov 2007 14:06] marc castrovinci
If you create a relationship between two tables, then delete the relationship the column (FK) still exists.

How to repeat:
1.Create a table called tab1. Give it two columns, one PK with auto_increment column.

2.Create another table called tab2. Give one column, a PK with auto_increment.

3.Create a 1-1 relationship from tab2 to tab1. 
  This will give tab2 a FK.

4.Click on the relationship.

5.Go to Edit>, Then Delete>. 
The line will disappear for the relationship, but the column and the colors still exist. I have attached an image located here>>> http://i19.tinypic.com/8g8ujus.png

In the image the tables that were related are:

1 to 2
4 to 3
6 to 5

Suggested fix:
Remove the column that was created. 
Remove the color grouping.
[27 Nov 2007 2:14] Alfredo Kojima
Now deleting columns bound to a FK when connection is deleted.
[27 Nov 2007 11:34] Johannes Taxacher
deleting of relationship in diagram leads to removal of FK and referred col