Bug #11762 rename and add another column is impossible at the same time
Submitted: 6 Jul 2005 11:17 Modified: 19 Aug 2005 16:05
Reporter: [ name withheld ]
Status: Closed
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.10 OS:Microsoft Windows (Windows)
Assigned to: Bugs System Target Version:

[6 Jul 2005 11:17] [ name withheld ] 
Description:
on table editor, when i rename a column, and then add another one, i've got an execution
error.

The SQL generated refer to the old name of the column

"ALTER TABLE `db.dummy` CHANGE COLUMN `column1` `column_new` SMALLINT(6) NOT NULL DEFAULT
0,

ADD COLUMN `column2` VARCHAR(45) NOT NULL AFTER `column1` "

How to repeat:
create a table, add a column, then "apply change"

change the column name, and add another one.

then "apply change", then , the error.
[19 Aug 2005 16:05] 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