Bug #60312 Synchronize Model remove not mandatory Realation

• Submitted: 3 Mar 2011 12:48
• Modified: 11 Jan 2013 0:12
• Reporter: Valentina Isufi
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S1 (Critical)
• Version: 5.2.33
• OS: Any (Ubuntu 10.10, Windows XP)
• CPU Architecture: Any
• Tags: Synchronize Model remove not mandatory Realation

[3 Mar 2011 12:48] Valentina Isufi

Description:
I've a EER Diagramm which I have done with the mysql workbench. I this Diagram I've 2 tables(user and role). User have a foreign Key xRole and need one Role. So I have on the referenced Table role the mandatory option enabled. For the user table I have this option disabled so that It chould be on this side 0 or many and on the role side 1. When I do this and I sync to the database. It looks ok. When I sync then back to the model I've a problem beacuse the 0 or many is lost then I've 1 or many an this is wrong.

Does you have a solution for that? When it will be fixed?

How to repeat:
I've a EER Diagramm which I have done with the mysql workbench. I this Diagram I've 2 tables(user and role). User have a foreign Key xRole and need one Role. So I have on the referenced Table role the mandatory option enabled. For the user table I have this option disabled so that It chould be on this side 0 or many and on the role side 1. When I do this and I sync to the database. It looks ok. When I sync then back to the model I've a problem beacuse the 0 or many is lost then I've 1 or many an this is wrong.

Does you have a solution for that? When it will be fixed?

[3 Mar 2011 12:58] Valeriy Kravchuk

Please, upload .mwb file that demonstrates this problem.

[3 Mar 2011 13:11] Valentina Isufi

Realation wrong

Attachment: RealationProblem.mwb (application/octet-stream, text), 79.27 KiB.

[4 Mar 2011 7:39] Valeriy Kravchuk

Verified just as described with our .mwb file on Windows XP when working with MySQL server 5.1.54.

[4 Mar 2011 14:24] Valentina Isufi

Hi did you mean it has work with this version or not ?

[16 Mar 2011 13:49] Valentina Isufi

Hi could you say me when this will be fixed? I need this to know because we are in a project and we would like to use this tool but with the right function. Otherwise we need to look for an other product. 

Thank you very much

Valentina

[22 Jul 2011 13:57] Valentina Isufi

Hi any News on this Bug?

[4 Oct 2011 8:14] Valentina Isufi

Hi,

This bus is still exist. Please check.

Thanks

[11 Jan 2013 0:12] Philip Olson

Fixed as of the upcoming MySQL Workbench 5.2.46 release, and here's the changelog entry:

Under certain circumstances, synchronizing a database to a model would
remove the mandatory relationships.

Thank you for the bug report.