Bug #69277 Workbench move of tables whne in layer move the layer too
Submitted: 18 May 2013 19:46 Modified: 15 Aug 2013 15:03
Reporter: Petronel MALUTAN Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.47 CE OS:Windows
Assigned to: CPU Architecture:Any
Tags: move, move with layer, table move table

[18 May 2013 19:46] Petronel MALUTAN
Description:
When you try to move a table located into a layer to another layer, the table moves together with the original layer and both layers + table are moved into the top left of the diagram.

How to repeat:
When you try to move a table located into a layer to another layer, the table moves together with the original layer and both layers + table are moved into the top left of the diagram.

Suggested fix:
only table should be moved and the layers should stay fixed on the old position in the diagram
[20 May 2013 11:29] MySQL Verification Team
Thank you for the bug report. Please check for related/duplicate with http://bugs.mysql.com/bug.php?id=68727 . Thanks.
[12 Jun 2013 11:05] Simon Hooker
MySQL Workbench bug 69277 2-table demo

Attachment: MySQL Workbench - Bug 69227 demo.mwb (application/octet-stream, text), 8.06 KiB.

[12 Jun 2013 11:06] Simon Hooker
MySQL Workbench bug 69277 1-table demo

Attachment: MySQL Workbench - Bug 69227 demo 2.mwb (application/octet-stream, text), 6.23 KiB.

[12 Jun 2013 11:10] Simon Hooker
Below steps are shown in "MySQL Workbench bug 69277 1-table demo".  "MySQL Workbench bug 69277 2-table demo" illustrates the same happening with multiple tables.

Step 1 : Create a table and create a layer around it.  Table name / rows / layer name make no difference.

Step 2 : Move the layer to a different position on the canvas

Step 3 : Move the table to a position where any part of the table is outside of the layer

At this point the table will reposition to an unexpected position and the layer will snap to top-left of the screen.

Anecdotally in some examples it has proved impossible to move the tables/layers once snapped to top left and so has required either rebuilding the diagram from scratch, or removing and re-adding affected layers and tables.

A workaround for this is to remove the layers prior to moving the tables however this should not be necessary.
[12 Jun 2013 11:18] Simon Hooker
As an addition.  Assume that the top left square of the grid is [1,1].  If I have a layer dimensions 3x3 starting at [2,2] going to [4,4] and a table dimensions 1x1 in [3,3] (in the centre of the 3x3 layer) then the movement of the table from it's intended position seems relative to the movement of the table.

If I move the layer so it is positioned at [3,3]->[5,5] (so the table is now in [4,4] and then move the table so it is then at [6,4], the layer moves to the top left (so -2,-2 from it's original position) and the table I had just moved relocates to [8,6] (so +2,+2 from where I dropped it)

Additionally if I move the layer (now empty) back to [1,1] and place the table in the middle again (at [3,3]), the table snaps back to [1,1] but this time with the table still positioned in the centre (so now at [2,2], but the same place as I dropped it relative to the layer)
[6 Aug 2013 23:20] Alfredo Kojima
Please try version 6.0.5
[15 Aug 2013 8:24] Simon Hooker
Have just tried in 6.0.6.11184.  Happy to confirm this is now fixed.  Thanks a lot, will save much frustration!
[15 Aug 2013 15:03] Alfredo Kojima
Duplicate of bug #68727