Bug #51124 | Workbench has no method to drop a foreign key | ||
---|---|---|---|
Submitted: | 11 Feb 2010 22:14 | Modified: | 12 May 2010 15:11 |
Reporter: | Barry Galbraith | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
Version: | 5.2.15 | OS: | Windows (WinXP) |
Assigned to: | Sergei Tkachenko | CPU Architecture: | Any |
[11 Feb 2010 22:14]
Barry Galbraith
[11 Feb 2010 23:48]
MySQL Verification Team
Delete FK
Attachment: fk.png (image/png, text), 87.07 KiB.
[11 Feb 2010 23:50]
MySQL Verification Team
Thank you for the bug report. Could you please take a look in the prior attached picture. Thanks in advance.
[12 Feb 2010 0:53]
Barry Galbraith
In SQL editor, select the table. Right click, select Alter table. Select the Foreign Keys tab. Change On Update and/or On Delete action. Click on Apply The foreign key CANNOT be altered. Any attempt results in error "Type mismatch: expected type string, but got list. The On Update / On Delete actions cannot be set or changed from the EER view. So, the only method is to Create FK in SQL editor. If it needs changing, then Drop it in EER view, and re-create in SQL view. ?!?!?!
[15 Feb 2010 9:07]
Valeriy Kravchuk
Thank you for the bug report. Indeed, there is no good way to alter foreign key in SQL Editor.
[15 Apr 2010 10:59]
Sergei Tkachenko
Can't repeat with snapshot version (5.2.18+).
[10 May 2010 18:32]
Johannes Taxacher
confirmed working in repository
[12 May 2010 15:11]
Tony Bedford
An entry has been added to the 5.2.21 changelog: In the Alter Table dialog of the SQL Editor, there was no effective way of altering a foreign key.