Bug #27468 self referencing foreign key
Submitted: 27 Mar 2007 10:46 Modified: 27 Mar 2007 12:17
Reporter: Matthew Heald Email Updates:
Status: Won't fix Impact on me:
Category:MySQL GUI Common Severity:S3 (Non-critical)
Version:WorkBench 1.1.10 alpha OS:Microsoft Windows (windows XP SP2)
Assigned to: CPU Architecture:Any

[27 Mar 2007 10:46] Matthew Heald
cannot change the label shown on a self referencing key.
cannot edit the label, or index from the diagram after creation
label can be changed in the table edit, but on the diagram remains the same
tried to edit the label on the diagram but cannot pull up the edit dialog by using a right click as you caa on the other FK defintions

..actually just checked to make sure Ive got the method right... you cannot select the foreign key.. but you can alter the name in the properties panel on the lower RHS.

However changes to the fk name in the table editor are not displayed

How to repeat:
create a key to the PK in the same table

change the name of the fk definition in a table edit (using the table editor)
switch back to the diagram and check the label

In the diagram editor attempt to select the FK and then pull up the
[27 Mar 2007 11:20] Miguel Solorzano
Thank you for the bug report. I changed the Category to MySQL GUI
Common because the Workbench isn't available anymore.
[27 Mar 2007 12:17] Matthew Heald
having problems with table editor,
..tried to delete all columns, indices, FK's etc... worked ok in table editor
however find there is no way to delete the relationship on the screen.
[13 Mar 2014 13:36] Omer Barnir
This bug is not scheduled to be fixed at this time.