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:Microsoft Windows (2003 Enterprise SP2)
Assigned to: Assigned Account CPU Architecture:Any
Tags: catalog diff, forward engineer, regression, synchronization

[11 Nov 2010 12:06] nan orch
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)
[11 Nov 2010 12:21] Peter Laursen
@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)
[10 Jan 2013 23:58] Philip Olson
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.