MySQL Bugs: #68727: Diagrams explode when tables intersect with layer borders

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

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.

Thank you for the bug report.

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??

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

http://bugs.mysql.com/bug.php?id=69183 duplicate of this one.

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.

I can also confirm this issue. This is a major drawback and I hope it can be fixed soon.

Posted by developer:
 
This bug was fixed in the 6.0 branch

This bug no longer affects me in the 6.0.2 beta release, so I'm closing it.

Bug repro

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

Still have the same issue with 6.0.2 BETA 1

It has not affected me since switching to 6.0.2, but I am reopening this for Dominic.

@Dominic: what OS are you using?

Come to think of it, if everyone else could specify their OS, that might help the dev team nail this one?

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

Please try 6.0.3

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.

So far so good with v6.0.3.11035 - have not experienced the problem. Thanks! -Ben

Thank you for the update, status->closed.