MySQL Bugs: #89530: Relationships not showing after reverse-engineer

Bug #89530	Relationships not showing after reverse-engineer
Submitted:	5 Feb 2018 9:53	Modified:	5 Feb 2018 13:48
Reporter:	Arthur Attout	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	6.3 CE, 6.3.10	OS:	Microsoft Windows
Assigned to:		CPU Architecture:	Any
Tags:	relationships;lines

Description:
After reverse-engineering a MySQL script into MySQL Workbench, the relationships lines are not shown, even though they are referenced in each table's "FOREIGN KEY" tab, and the columns are valid. 

"Draw lines crossing" option is checked under relationships/connections.
Even stranger, if I manually create a relation using "place a relationship using existing columns" the line is not shown.

How to repeat:
- Choose File > import > Reverse engineer MYSQL create script
- Check 'place imported objects on diagram'
- Create a relationship using existing columns

I managed to import a SQL script and show the relationships BUT I had to create a new model BEFORE, and then import data in it, instead of using the option "Create EER model from Script". This seems to be a completely different bug.

Hello Arthur,

Thank you for the report.
I'm not seeing any issues with dummy test case, observed that relationships are properly mapped after importing. Could you please attach the script here to confirm the issue at our end? I assume that you are using latest GA WB build.

Thanks,
Umesh

Hello ! 

Here is the file I have used
https://pastebin.com/9515AxCU

Here are the steps to reproduce the issue : 

Scenario with bug : 

On the main menu, in the "models" tab, use the arrow to show the options, and click "Create EER Model from script"
Check "place imported objects on a diagram"
Click Execute
The relationships are not shown

_____

Scenario without bug :

Click "File > new model"
In the model tab, click "File > import > Reverse engineer MySQL Create Script"
Check "place imported objects on a diagram"
Click Execute
The relationships are successfully shown

Thank you for the requested details.
Verified as described.

Thanks,
Umesh

Reduced sql script file

Attachment: bug.sql (application/octet-stream, text), 713 bytes.