MySQL Bugs: #53252: On Synchronizing new field from db to model the relations dissappears

Bug #53252	On Synchronizing new field from db to model the relations dissappears
Submitted:	28 Apr 2010 13:36	Modified:	21 May 2010 12:49
Reporter:	Milen Dimitrov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.20	OS:	Windows (XP sp3)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	model, relation, synchronize

Description:
When synchronizing table that has 1:n relation from db, the relation is no more drawn (or dissappears) on the model screen

How to repeat:
1. create 3 tables
2. link 2 of them to the third (my case: 1:n non-identifying)
3. synchronize to the db (model->db)
4. create new fields in the first or second table directly in the db (my case: 2 datetime)
5. synchronize to the model (db->model, I`m not using reverse engineering)
6. the link from the table with the new fields to the third table is not shown anymore

Suggested fix:
...

don`t work in 5.2.20 and 5.2.19

What exact version of MySQL server are you working with? I can not repeat this with local 5.1.46 on XP.

5.0.51a-3ubuntu5.5

5.0.51a-3ubuntu5.5

ubuntu 8.04 LTS

Which storage engine did you use?

InnoDB

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

When a model containing a table using a 1:n relationship was synchronized with a live database, the relationship then failed to render in the EER Diagram.