MySQL Bugs: #45556: alter script generation does not contain column upper/lowercase renaming

Bug #45556	alter script generation does not contain column upper/lowercase renaming
Submitted:	17 Jun 2009 14:16	Modified:	16 Feb 2010 17:09
Reporter:	Rainer Herzog	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.0.30 OSS, 5.1.13	OS:	Windows (XP)
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	column name, lowercase, rename, uppercase

Description:
When the function ALTER Script Generation is used to generate SQL statements that change column names from upper to lower case, these changes are not included in the output script.

How to repeat:
Consider the following table creation:

CREATE  TABLE IF NOT EXISTS `mydb`.`sample_table1` (
  `Id` INT NOT NULL ,
  `Firstname` VARCHAR(45) NULL ,
  `Lastname` VARCHAR(45) NULL ,
  PRIMARY KEY (`Id`) )
ENGINE = InnoDB;

Now we change "Firstname" to "firstname" (lower case) and "Lastname" to "surname". The alter script generation will output:

ALTER TABLE `mydb`.`sample_table1` CHANGE COLUMN `Lastname` `surname` VARCHAR(45) NULL DEFAULT NULL  ;

It is leaving out the "Firstname" column rename.

Suggested fix:
Please include the upper/lower case changes as well.

Thank you for the problem report. Verified just as described with both 5.0.30 and 5.1.13.

fixed in repository

An entry has been added to the 5.2.16 changelog:

When using MySQL Workbench to create an ALTER script, the generated script did not reflect columns where only the case of the column name had changed.