MySQL Bugs: #54923: Cannot move column (no reorder SQL generated)

Bug #54923	Cannot move column (no reorder SQL generated)
Submitted:	30 Jun 2010 17:47	Modified:	11 Nov 2010 14:45
Reporter:	Jesse Castleberry	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.24	OS:	Any (Win7)
Assigned to:	Alexander Musienko	CPU Architecture:	Any

Description:
I cannot move a column.  When I bring up the Alter Table dialog, and drag and drop a field to it's new location, then click Apply, a message comes up saying "No changes to object were detected.". The field will also not move if I made some other change. For instance, if I move the field, and also add a comment to some field, it will properly keep the comment, but my moved field goes back to it's original position.

How to repeat:
Open up a database, right-click on a table and choose Alter Table.  Drag a field  to a new location, then click the Apply button.  You should get a message as indicated above.

Suggested fix:
When you move a field and click Apply, move the field to it's new location.

Thank you for the problem report.

The RC (5.2.25) had an entry in the changes log, "In the Columns tab of the Table Editor, the handling of column ordering appeared to have numerous problems. For example, dragging and dropping a column did not locate the column as expected. (Bug#53749)" that sounded very similar to the problem I reported here.  However, I've installed 5.2.25, and I am still having the same problem.

I am also having this problem in 5.2.25. What is weird is that it was working fine this morning, but stopped working this afternoon.

This bug is still present in 5.2.25. The error message is: "No changes to object were detected.
SQL:

".

The desired result should have been the generated SQL code for altering the table.

fix confirmed in repository

An entry has been added to the 5.2.30 changelog:

In the Alter Table dialog of the SQL Editor, attempting to reorder columns failed. If a column position was changed, and then the Apply button was clicked, the dialog reported that no changes to the object were detected.