MySQL Bugs: #14632: Can't delete FK after removal of referred table

Bug #14632	Can't delete FK after removal of referred table
Submitted:	4 Nov 2005 9:45	Modified:	20 Apr 2006 7:25
Reporter:	Pierre Delporte	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	1.0.2a	OS:	Windows (XP SP2)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
You can't delete a FK referencing a deleted table. The removal of a refered table should delete all FK referencing it, this to avoid inconsistent schemata.

How to repeat:
1.	Add table T1 with columns idT1 (PK), Data (varchar) and idT2
2.	Add table T2 with columns idT2 (PK), Label (varchar)
3.	Add FK where T1. idT2 = T1.idT1
4.	Delete table T2
5.	Edit table T1
6.	Select the FK
7.	Delete the FK
8.	Apply changes

The result of this give you a Dialog window with three choices  
Abort -> means quit the Workbench
Retry -> seems to work, but when you come to the main window, the FK is still there.
Ignore -> same as Retry.

Suggested fix:
This could be link to the fact that the Tables node in the Object Tree is not refreshed?

Retested with version 1.02alpha and it is the same.

Sorry....I was not able to reproduce the bug. My steps were follow:

1.	Add table T1 with columns idT1 (PK), Data (varchar) and idT2
2.	Add table T2 with columns idT2 (PK), Label (varchar)
3.	Add FK where T1. idT2 = T1.idT1
4.	Delete table T2
5.	Edit table T1
all above were done
6.	Select the FK
7.	Delete the FK
there was not any FK
8.	Apply changes
nothing apply

Could you please explane me where I must select FK ?

To select the FK, open the "Table properties" by pressing the "pencil" button on the table T1. 
Select then the "Foreign keys" tab, select the foreign key in the upper panel and do a right-click or Ctrl-Del to remove the FK.

Hope it will help,

Yours,
Pierre

Just to be sure, as I saw a typo mistake

Add Table T1, with columns idT1, Data and idT2
Add table T2, with columns idT2 and Label
Edit table properties T1 and add the FK on T1.idT2 = T2.idT2 and NOT T1.idT2 = T1.idT2
Then delete table T2

You should get the same result as the picture I joined, which is not correct as table T2 does not more exist.

Can't delete FK after removal of referred table (screenshot)

Attachment: bugRemoveTable.jpg (image/jpeg, text), 138.24 KiB.

Thank you for your bug report.  I was able to repeat this problem using the provided how-to.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html