Bug #103550 Bug in foreign keys
Submitted: 2 May 2021 9:39 Modified: 3 Jun 2021 12:52
Reporter: giada betti Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:8.0 OS:Windows
Assigned to: MySQL Verification Team CPU Architecture:Any

[2 May 2021 9:39] giada betti 
Description:
Every time that I try to add foreign keys through GUI, the app returns sintax errors. So I am forced to apply the constraints manually

How to repeat:
Every time that I try to add foreign keys through GUI, the app returns sintax errors. So I am forced to apply the constraints manually

Suggested fix:
Please fix the sintax error
[3 May 2021 12:52] MySQL Verification Team 
Hello,

Thank you for the bug report.
Could you please provide an SQL query and screenshot of the error to confirm this issue at our end?

Regards,
Ashwini Patil
[20 May 2021 7:02] John King 
The cause might be the problem I see here. 
Specifying a referencing column is ignored without warning. The key can therefor not be created.
A small video showing this: http://youtu.be/vGN1Vuvwyyw?hd=1
[4 Jun 2021 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".