MySQL Bugs: #41219: Inbound syncronize does not update the model.

Bug #41219	Inbound syncronize does not update the model.
Submitted:	4 Dec 2008 9:57	Modified:	6 Aug 2009 15:03
Reporter:	Jonas Stenberg	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.28 SE	OS:	Windows (XP)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	CHECKED

Description:
I have used Reverse engineering from the database to build my model within MySql Workbench.
When I update a foreign key in the database and then try to synchronize the workbench to the database to get the changes into the model the following happends:

1. The sychronization completes. OK
2. The Catalog is updated with the changes from the database. OK
3. The model is not updated with the new relation between the tables. ERROR

How to repeat:
1. Create a database.
2. Create two tables.
3. Create a Workbench project by reverse engineering from the database. Let the wizard layout the diagram.
4. Create a foreign key between the tables within the database.
5. Synchronize the Workbench model to get the changes into the Workbench project.
6. Note that the relation is not not displayed in the model.

Suggested fix:
Make sure that the model is updated after a syncronization or at least make it possible to manually update the model with changes.

Could you please try the new release version 5.0.28. Thanks in advance.

The problem remains in 5.0.28 SE. 

I also found another pecurlior bahavior: When I use the "Check for Updates..." I get directed to the OSS version instead of the SE version.

Thank you for the report.

Verified as described.

the FK is created in the table-object, but the connection item on canvas is not created

fixed in WB 5.1.13

sorry, faulty test, inst fixed for all cases yet

Corrected priority.

this has been fixed.
fix will be in 5.1.17

An entry was added to the 5.1.17 changelog:

When a MySQL Workbench model was synchronized with a live database, a foreign key relationship, recently added to the database, was not reflected in the EER Diagram. Although the foreign key was created in the table object, the relationship connector widget was not drawn on the canvas.