MySQL Bugs: #11672: Invalid SQL generated during table alter (change & add at same time)

Bug #11672	Invalid SQL generated during table alter (change & add at same time)
Submitted:	30 Jun 2005 15:29	Modified:	5 Jul 2005 10:43
Reporter:	Lee Saferite	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.10	OS:	Windows (WinXP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
While changing a table in the Query Browser, If you change the last column name AND add new columns at the same time, the first ADD COLUMN statement will be wrong.  It will try to place itself AFTER using the old column name instead of the new one.

How to repeat:
Create a table and save it.  Edit the table.  Change the last column name and add a new column. Try to commit the changes.

Suggested fix:
Make sure that if you CHANGE COLUMN right before an ADD COLUMN , that the ADD COLUMN uses the potentially new column name and not the old one.

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