MySQL Bugs: #46875: foreign key generation not working

Bug #46875	foreign key generation not working
Submitted:	24 Aug 2009 2:41	Modified:	28 Aug 2009 6:28
Reporter:	Xavier Irias	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.1.17	OS:	Any (Windows, Mac OS X)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	regression

Description:
New bug for this version.

DDL generated without foreign keys, regardless of whether the "skip generation of foreign keys" option is turned on.

I rate severity as serious since the software is not usable for its primary purpose till this new bug is fixed.

 

How to repeat:
generate DDL by choosing Export, then forward engineer create script.

Note that the DDL generates indexes on foreign keys but omits the declaration of the keys themselves.

Thank you for the bug report. Verified just as described. Any model with foreign key(s) can be used to demonstrate the bug.

this has been fixed. it will be included in 5.1.18

An entry was added to the 5.1.18 changelog:

The DDL was generated without foreign keys, regardless of whether the Skip generation of foreign keys option was turned on.