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: | |
Category: | MySQL Workbench Preview | Severity: | S2 (Serious) |
Version: | 1.0.2a | OS: | Windows (XP SP2) |
Assigned to: | Mike Lischke | CPU Architecture: | Any |
[4 Nov 2005 9:45]
Pierre Delporte
[4 Nov 2005 10:11]
Pierre Delporte
Retested with version 1.02alpha and it is the same.
[17 Nov 2005 9:10]
Vasily Kishkin
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 ?
[17 Nov 2005 12:44]
Pierre Delporte
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
[17 Nov 2005 13:14]
Pierre Delporte
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.
[17 Nov 2005 13:15]
Pierre Delporte
Can't delete FK after removal of referred table (screenshot)
Attachment: bugRemoveTable.jpg (image/jpeg, text), 138.24 KiB.
[21 Nov 2005 18:14]
Jorge del Conde
Thank you for your bug report. I was able to repeat this problem using the provided how-to.
[20 Apr 2006 7:25]
Mike Lischke
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