MySQL Bugs: #58135: synchronization of foreign keys broken

Bug #58135	synchronization of foreign keys broken
Submitted:	11 Nov 2010 12:06	Modified:	10 Jan 2013 23:58
Reporter:	nan orch	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.29 CE	OS:	Windows (2003 Enterprise SP2)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	catalog diff, forward engineer, regression, synchronization

Description:
Synchronization of foreign keys was broken between v5.2.27 and v5.2.29:

using v5.2.29 certain foreign keys get dropped and recreated. I experience 2-sync cycles: 
  - on 1st sync one foreign key is recreated
  - on 2nd cycle three other foreign keys are recreated
  - 3rd cycle like 1st cycle

No such behavior with 5.2.27

How to repeat:
I am not sure how to repeat, but I can provide a model on request 
(trying to reduce that model by removing some tables not involved in the foreign key defintions was enough to make the bug disappear...)

Suggested fix:
no fix to suggest, but as a workaround it would be nice to have 5.2.27 available for download again (took me a while to find a copy)

@nan .. download from a FTP-mirror.  Example direct link:
ftp://ftp.easynet.be/mysql/Downloads/MySQLGUITools/mysql-workbench-gpl-5.2.27-win32.msi

Peter
(not a MySQL person)

This bug was fixed previously, and has been documented with MySQL Bug #60705 -- which was closed via MySQL Workbench 5.2.40

Thank you for the bug report.