MySQL Bugs: #40641: Drag&drop of clumns in columns editor drops column n+1 positions

Bug #40641	Drag&drop of clumns in columns editor drops column n+1 positions
Submitted:	11 Nov 2008 15:24	Modified:	5 Aug 2009 15:37
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.26, 5.0.27	OS:	Windows (XP)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	CHECKED, column, drag&drop, Drop, editor, position

Description:
When dragging&dropping columns in the columns editor tab to a LOWER position in the list, the column is dropped +1 position lower as the drop maker shows. If it is moved from below to a higher position, it is dropped on the drop marker.

How to repeat:
1.) Open cloumn editor tab
2.) drag a column from position 1 to position 2

--> results in column being dropped at position 3

3.) drag the column from position 3 to position 2

--> results in column being dropped on position 2

Suggested fix:
When dropping a column, it should drop on the position the drop marker indicates.

I forgot to include in the steps to reproduce that this ONLY happens when moving a column to a _LOWER_ position

Thank you for a bug report. Verified just as described.

if column is dropped ON another col. its placed after the "drop-target". when dropping columns "before" or "after" another col. (indicated by the black drop-marker) its dropped as expected now.

fix will be included in 5.1.17

An entry was added to the 5.1.17 changelog:

In the Columns tab of the Table Editor, when moving a column lower in the list of columns using drag and drop, the column was incorrectly placed one position below the point indicated by the position marker.