Bug #47246 No Foreign Key constraint in a generated sql script

• Submitted: 10 Sep 2009 11:10
• Modified: 11 Sep 2009 4:03
• Reporter: Nathan Sala
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.1.17
• OS: Windows
• CPU Architecture: Any
• Tags: constraint, foreign key, SQL

[10 Sep 2009 11:10] Nathan Sala

Description:
The foreign key constraints are not included in the generated sql script using the "Forward Engineer SQL CREATE script" feature.

The indexes refering to the foreign keys are created, but nothing more about the foreign keys.

How to repeat:
Use the "Forward Engineer SQL CREATE script" feature on the foreign key constrained schema attached, leave the options blank and generate.
The SQL file doesn't include any constraint.

Suggested fix:
It seems that the problem is related to a bad interpretation of the generation options, because when using the "Forward Engineer SQL ALTER script" feature based on the previously generated file, all the missing constraints are generated, which means they are recognized.

[10 Sep 2009 11:12] Valeriy Kravchuk

Thank you for the problem report. Please, try to repeat with a newer version, 5.1.18, and inform about the results.

[10 Sep 2009 22:21] Nathan Sala

The bug is fixed in 5.1.18a.

Thanks

[11 Sep 2009 4:03] Valeriy Kravchuk

Not repeatable with 5.1.18.