Bug #11762 rename and add another column is impossible at the same time

• Submitted: 6 Jul 2005 9:17
• Modified: 19 Aug 2005 14:05
• Reporter: [ name withheld ]
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.10
• OS: Windows (Windows)
• Assigned to: Vladimir Kolesnikov
• CPU Architecture: Any

[6 Jul 2005 9: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 14: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