Bug #12797 Moving columns, Rearranging Columns, Changing Column does not work
Submitted: 25 Aug 2005 7:24 Modified: 23 Sep 2005 12:21
Reporter: Tamer Salama Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.1 rc OS:Windows (Win XP SP 2)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[25 Aug 2005 7:24] Tamer Salama 
Description:
Moving columns/Rearranging Columns/Changing Column Order using MySQL Administrator does not work.
Dragging a column from its current position to a new position would give a marker blue line in the new location but with a "Not Allowed" sign. Dropping the column to the new location does nothing.
The ALTER TABLE statement works perfectly on the same server using SQL clients (ALTER TABLE tablename CHANGE oldcol newcol type AFTER somecol)

How to repeat:
Using MySQL Administrator
[25 Aug 2005 7:27] Tamer Salama 
Shows the drag action (without the no-enter sign)

Attachment: new position place holder.jpg (image/jpeg, text), 115.61 KiB.
[30 Aug 2005 20:36] Jorge del Conde 
Thanks for your bug report.  I was able to reproduce this bug with MA 1.1.2
[23 Sep 2005 12:21] Vladimir Kolesnikov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

for now just disabled dnd. column rearranging is to be added later.