Bug #35237 reflexive foreign key connector not clickable
Submitted: 12 Mar 2008 1:23 Modified: 15 Mar 2008 12:46
Reporter: Devananda van der Veen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.14 Beta OS:Windows
Assigned to: CPU Architecture:Any
Tags: foreign key, workbench

[12 Mar 2008 1:23] Devananda van der Veen 
Description:
Reflexive foreign key is not displayed well, and it is not possible to move the connector. Sometimes the connector "floats" in the middle of the table.

How to repeat:
Define a table with a reflexive foreign key, such as:

CREATE TABLE tbl1 (
col1 int,
col2 int,
constraint `test` foreign key (col2) references tbl1 (col1)
);

Import this table into the workbench using the File->Import method, then place this table on an EER diagram. Try to click on the line representing the reflexive foreign key, it does not work. Move the table around and sometimes the connector moves inappropriately (this may only happen when other tables/connectors are present).
[12 Mar 2008 4:33] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[13 Mar 2008 14:01] Johannes Taxacher 
this issue is already fixed in our reposiory and will be incorporated in 5.0.15
[15 Mar 2008 12:46] MC Brown 
A note has been added to the 5.15 changelog: 

A foreign key relationship to the source table (a reflexive relationship) gives a bad representation in the entity model diagram.