Bug #57263 | After changing Foreign key behavior the comboBoxes (both) does not show changes | ||
---|---|---|---|
Submitted: | 5 Oct 2010 21:01 | Modified: | 27 Jun 2013 19:24 |
Reporter: | Pedram Ganjeh Hadidi | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench | Severity: | S2 (Serious) |
Version: | 5.2.28 CE Rev. 6722 | OS: | Windows (7 - 64Bit) |
Assigned to: | CPU Architecture: | Any | |
Tags: | changing foreign key behavior not shown in comboboxes |
[5 Oct 2010 21:01]
Pedram Ganjeh Hadidi
[7 Oct 2010 16:32]
Johannes Taxacher
this happens, because RESTRICT is the default policy for FKs and not explicitly returned by server in the "SHOW CREATE" result (which is used to populate the table-editor).
[27 Jun 2013 19:24]
Philip Olson
Fixed as of MySQL Workbench 5.2.47, and here's the changelog entry: The foreign key settings for "On Update" and "On Delete" would sometimes be lost after adding a new foreign key. Thank you for the bug report.