MySQL Bugs: #77445: Drag-n-drop for reordering table columns not working

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, 8.0.16	OS:	Ubuntu (gnome 15.04)
Assigned to:		CPU Architecture:	Any

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

Thank you for the bug report. Verified on Ubuntu 15.04 (Works on Windows 8.1).

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

Hi,

Same here with Debian Jessie and MySQL Workbench 6.2.3

Any news about a fix possibility?

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

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

So, when you fix this issue?

Any news about this issue?

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

https://bugs.mysql.com/bug.php?id=84959 marked as duplicate of this one.

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?

https://bugs.mysql.com/bug.php?id=85815 marked as duplicate of this one.

Bug #86548 marked as duplicate of this one

@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.

https://bugs.mysql.com/bug.php?id=88211 marked as duplicate of this one.

Is this software no longer supported?  The Mac version has had this bug for years now?

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.

One workaround is cut the column and past it to the new position, but is really inconvenient.

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.

Bug #85782 marked as duplicate of this one

Bug #83735 marked as duplicate of this one

Bug #78877 marked as duplicate of this one

Posted by developer:
 
Can not reproduce any more.

Still seeing the same issue in 8.0.11RC on MacOS 10.13.4

Still seeing the same issue in 8.0.12 on MacOS 10.13.6

Still seems same. I'm on High Sierra 10.12.6 (16G1510)

Still seems same. 

System:
MacOSX High Sierra 10.12.6 (16G1510)
Mysql Workbench 8.0.12 build 13312926 CE (64Bit) Community

After 2 years no change on MacOS ... If not drag-n-drop at least add a keyboard shortcut.

Regards,
Robert

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!

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

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

screencast of issue

Attachment: workbench_drag_reorder_8-13.mov (video/quicktime, text), 2.81 MiB.

Bug #93910 marked as duplicate of this one

Bug #93973 marked as duplicate of this one

Really no way to make this feature work? It's been 4 years at least!!

Bug #95132 marked as duplicate of this one

https://bugs.mysql.com/bug.php?id=98025 marked as duplicate of this one.

https://bugs.mysql.com/bug.php?id=100470 marked as duplicate of this one.

https://bugs.mysql.com/bug.php?id=100470 marked as duplicate of this one.

This is still an issue in v8.0.21

workbench: 8.0.24
OS: MacOs big sur 11.2.3
Year: 2021-May-10

The issue still persist :)

2023...... The issue still persist :)