Bug #57872 Alter colums "after" changes the case of column names
Submitted: 31 Oct 2010 14:26 Modified: 13 Dec 2010 1:48
Reporter: Roman Victor Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.29 CE OS:Windows (XP Pro)
Assigned to: CPU Architecture:Any
Tags: Alter tabel colums "after" changes the case of column names

[31 Oct 2010 14:26] Roman Victor 
Description:
When changing the order of column using the Workbench I notice that my previous mixed case columns were switch to all lower case.

e.g. MasterMLSIDs became mastesmlsids

This is an important bug as it can cause slight problem when data disapears since no error are thrown when  $rows['MasterMLSIDs'] that once gave correct results and then stops return anything but raises no error. 

How to repeat:
Start workbench , connect to database, change column using this type of SQL.

alter table `my_schema`.`masterlistings` MODIFY column `MasterMLSIDs` varchar after `Masterid`;

Suggested fix:
Change forcing lower case column names to not be used.
[13 Nov 2010 1:32] Alfredo Kojima 
Hi

Can you paste the script generated by the editor when you click Apply?
[14 Dec 2010 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".