Bug #68727 Diagrams explode when tables intersect with layer borders
Submitted: 20 Mar 2013 14:27 Modified: 11 Jul 2013 1:05
Reporter: Rasmus Schultz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.47 CE OS:Windows (Windows 8)
Assigned to: CPU Architecture:Any

[20 Mar 2013 14:27] Rasmus Schultz
Description:
Table/layer positioning in the latest release contains a crticial bug which completely smashes your diagrams when you move tables around - it is fully repeatable.

How to repeat:
This is easy to repeat:

1. Create a layer on the left.
2. Create a layer on the right.
3. Insert a table into the left layer.
4. Insert a table into the right layer.
5. Drag the table inside the right layer and drop it so that it is intersecting/overlapping the border of the right layer.

Upon dropping the right table, both tables will scatter to seemingly random positions on the page.

On a large, complex diagram with many layers, this is extremely destructive. Undo does not work after this, so the only work-around is to close your project without saving changes, reopen and start over.

Avoidance seems to work - don't ever drop a table over the borders of a layer, and you should be able to work around this problem for now. It took me a while to pinpoint what was triggering this however - I'm sure many users would perceive this as a "fluke" without understand what causes it, so this really needs to be fixed.
[20 Mar 2013 14:39] MySQL Verification Team
Thank you for the bug report.
[28 Mar 2013 17:56] Rasmus Schultz
I was wrong, by the way - even when I carefully drop a new table so it doesn't intersect with anything, my entire diagram now blows up. I've restarted two dozen times now, tried everything, there is no work-around.

Now what??
[13 Apr 2013 0:39] Ben Uphoff
I'm experiencing the same bug. What a great modeling tool - except for this bug. It's driving me crazy. I'm about to ditch this aspect of Workbench because, as the original poster indicates, it is extremely destructive. Please fix ASAP! Thanks much. -Ben
[9 May 2013 13:34] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=69183 duplicate of this one.
[23 May 2013 12:08] Joshua Bryant
This is quite a severe issue. I lost quite a bit of time fixing the exploded diagrams. For now I have resorted to not using layers, I hope this will be fixed in the next update.
[25 May 2013 13:34] Sam Vervaeck
I can also confirm this issue. This is a major drawback and I hope it can be fixed soon.
[23 Jun 2013 14:11] Alfredo Kojima
Posted by developer:
 
This bug was fixed in the 6.0 branch
[27 Jun 2013 13:12] Rasmus Schultz
This bug no longer affects me in the 6.0.2 beta release, so I'm closing it.
[7 Jul 2013 13:47] Dominic Dumont
Bug repro

Attachment: db.png (image/png, text), 140.10 KiB.

[7 Jul 2013 13:48] Dominic Dumont
Still have the same issue with 6.0.2 BETA 1
[8 Jul 2013 21:32] Rasmus Schultz
It has not affected me since switching to 6.0.2, but I am reopening this for Dominic.

@Dominic: what OS are you using?
[8 Jul 2013 21:33] Rasmus Schultz
Come to think of it, if everyone else could specify their OS, that might help the dev team nail this one?
[10 Jul 2013 16:01] Ben Uphoff
Bug still exists in build v6.0.2.10924. Per request, my info:

Windows 7x64 Enterprise on a Dell E6510, 8G RAM

Sure would be great to work this one out. Thanks! -Ben
[10 Jul 2013 21:08] Alfredo Kojima
Please try 6.0.3
[10 Jul 2013 21:48] Philip Olson
Fixed as of MySQL Workbench 6.0.3 (BETA 2), and here's the changelog entry:

  Moving tables around while constructing a diagram could cause the table
  positions to become lost, and scatter.

Thank you for the bug report. I'm leaving this bug report open for now, and subscribing, so please update the report after the fix is confirmed and I'll adjust the docs accordingly.
[10 Jul 2013 22:52] Ben Uphoff
So far so good with v6.0.3.11035 - have not experienced the problem. Thanks! -Ben
[11 Jul 2013 1:05] Philip Olson
Thank you for the update, status->closed.