Bug #77445 Drag-n-drop for reordering table columns not working
Submitted: 23 Jun 2015 5:15 Modified: 23 Jun 2015 10:28
Reporter: Diogo Domanski Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.3.4/6.3.9 OS:Ubuntu (gnome 15.04)
Assigned to: CPU Architecture:Any

[23 Jun 2015 5:15] Diogo Domanski
Description:
In table's column editor, is not being possible anymore to reorder columns using drag-n-drop.

How to repeat:
1. Open MySQL Workbench
2. Create a new model (or open an existing one)
3. Add new EER diagram (or open an existing one)
4. Create a new table (or double click to edit an existing one)
5. Set table name (optional)
6. Select "Columns" tab
7. Add at least 2 columns
8. Try to drag and drop any of them to reorder
[23 Jun 2015 10:28] Miguel Solorzano
Thank you for the bug report. Verified on Ubuntu 15.04 (Works on Windows 8.1).
[2 Sep 2015 16:22] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=75472 marked as duplicate of this one.
[13 Apr 2016 10:21] Vivien DE BONA
Hi,

Same here with Debian Jessie and MySQL Workbench 6.2.3

Any news about a fix possibility?
[23 Sep 2016 16:28] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=83131 marked as duplicate of this one.
[27 Oct 2016 11:59] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=83571 marked as duplicate of this one.
[27 Oct 2016 12:48] Huseyin INAN
So, when you fix this issue?
[7 Nov 2016 8:27] Alberto Ureña
Any news about this issue?
[13 Nov 2016 19:38] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=83792 marked as duplicate of this one.
[12 Feb 2017 15:32] Miguel Solorzano
https://bugs.mysql.com/bug.php?id=84959 marked as duplicate of this one.
[1 Mar 2017 20:05] Fredrik Motin
Same here with Sierra, both on mwb v 6.3.6 and 6.3.9 (upgraded in the hopes this bug would be solved).

The bug makes MWB rather useless, since our primary use is to create and modify the database schema. 

Any news about a fix timeline or a workaround?
[5 Apr 2017 19:32] Miguel Solorzano
https://bugs.mysql.com/bug.php?id=85815 marked as duplicate of this one.
[8 Jun 2017 6:42] Umesh Shastry
Bug #86548 marked as duplicate of this one
[8 Jun 2017 23:21] Shravan Rajinikanth
@Umesh You marked my previous issue as a duplicate of this. Can we please have a progress update? It has been nearly 2 years with no news.
[24 Oct 2017 21:48] Miguel Solorzano
https://bugs.mysql.com/bug.php?id=88211 marked as duplicate of this one.
[10 Dec 2017 0:05] O J
Is this software no longer supported?  The Mac version has had this bug for years now?
[11 Jan 21:56] Caleb S
Please fix this. It is truly a pain to right-click, move up, right-click, move up, etc. on a table with many columns, when drag & drop reordering was working fine in previous versions.
[17 Jan 4:05] yixiang zhou
One workaround is cut the column and past it to the new position, but is really inconvenient.
[2 Feb 10:15] Michael de Hart
The workaround of cutting the column and paste it in position will make it lose its FK relation.
Should I make another bug report of this or would that be as useless as this one? 

I've noticed that the MacOS Sierra bug was marked as duplicate of this Ubuntu gnome 15.04 bug.
[2 Feb 12:47] Umesh Shastry
Bug #85782 marked as duplicate of this one
[2 Feb 13:17] Umesh Shastry
Bug #83735 marked as duplicate of this one
[3 Feb 11:50] Umesh Shastry
Bug #78877 marked as duplicate of this one
[24 Apr 9:04] Miguel Tadeu
Posted by developer:
 
Can not reproduce any more.
[27 Apr 14:27] Free Me
Still seeing the same issue in 8.0.11RC on MacOS 10.13.4
[2 Aug 9:14] Shingo Maeda
Still seeing the same issue in 8.0.12 on MacOS 10.13.6
[2 Aug 9:21] Huseyin INAN
Still seems same. I'm on High Sierra 10.12.6 (16G1510)
[2 Aug 9:23] Huseyin INAN
Still seems same. 

System:
MacOSX High Sierra 10.12.6 (16G1510)
Mysql Workbench 8.0.12 build 13312926 CE (64Bit) Community
[28 Aug 12:32] Robert Tajnšek
After 2 years no change on MacOS ... If not drag-n-drop at least add a keyboard shortcut.

Regards,
Robert
[28 Aug 12:51] Free Me
I don't understand how this cannot be seen as a semi-important bug... All the database tables are hard to use in tools because all new fields are plopped on to the end instead of grouped with other fields where they belong.

I am ashamed to show my database tables to other developers... why would I not group fields?  Because I don't have all day to use the context menu to move a field up one entry at a time for 30 entries.

Thanks for reconsidering!
[29 Aug 10:50] Fredrik Motin
> I don't understand how this cannot be seen as a semi-important bug... All the database tables are hard to use in tools because all new fields are plopped on to the end instead of grouped with other fields where they belong.
> I am ashamed to show my database tables to other developers... why would I not group fields?  Because I don't have all day to use the context menu to move a field up one entry at a time for 30 entries.

Same here! It has been like this for more than three years now. Had my hopes up for v8 but nah... Bugs like this are what has brought me away from the MySQL ecosystem and onto more modern platforms. There is not enough manpower available (paid and hobbyist contributions) to maintain the tools above fixing severe crashes and data corruption bugs. Anything else, ie  "Non-critical" will not be fixed. 

Assuming this will never be fixed, maybe a workaround is to record a mouse macro with Automator or some other software, which would automate the right-click and selecting Move up/down? Haven't tried.

PS Can the developers at least change the OS tag of this bug to also include Mac OSX?
[7 Sep 12:27] Michael de Hart
Please change
Version to 6.3.4/8.0.12 
OS add "MacOS High Sierra"
Severity: Raise a level

On MacOS  I do:
Right-Click > Cut  Select column when the field needs to go below Right-click > Paste

It's faster then 
Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up Right-Click > Move Up