Bug #52786 Alter Table doesn't detect changes
Submitted: 13 Apr 2010 14:21 Modified: 4 May 2010 13:24
Reporter: Manuel C. Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.20 OSS Beta OS:Windows
Assigned to: Alexander Musienko CPU Architecture:Any

[13 Apr 2010 14:21] Manuel C. 
Description:
I can't alter a table structure using the "Alter Table" editor, as it always says "No changes to object were detected.".

I'm using the "5.2.17 OSS Beta" version, the previous beta version didn't have this issue.

How to repeat:
*) Open the SQL Development section.
*) Right-click on a table name.
*) Choose "Alter Table".
*) Change something (name, collation, engine, colums etc.)
*) Click "Apply"
*) --> "No changes to object were detected."
[13 Apr 2010 14:44] Valeriy Kravchuk 
Verified just as described on Windows XP. First ALTER (adding column, for example) usually works for me, but any further ALTERs are ignored.
[13 Apr 2010 14:47] Manuel C. 
It never works here, neither the first time.
[15 Apr 2010 13:49] Manuel C. 
I confirm this bug for "5.2.18 OSS Beta" (Beta 8) too.
[18 Apr 2010 10:26] Manuel C. 
I confirm this bug for "5.2.19 OSS Beta" (Beta 9) too.

Please note this is a serious bug on the Windows platform and I have to keep 5.2.16 (Beta 6) because 5.2.17, 5.2.18 and 5.2.19 are not really usable.
[19 Apr 2010 19:43] Alfredo Kojima 
The changes are not detected if you change the name of the table in addition to other fields,
but if you change anything *except* the name, the Apply works ok.

Marked bug #50893 as duplicate. The diff code should make sure to not ignore case changes, like in the object name.
[21 Apr 2010 3:33] Valeriy Kravchuk 
Bug #53003 was marked as a duplicate of this one.
[28 Apr 2010 12:32] Manuel C. 
I confirm this bug for "5.2.20 OSS Beta" (Beta 10) too.
I verified it only happens when you also change the table name.
[2 May 2010 8:53] Valeriy Kravchuk 
Bug #53349 was marked as a duplicate of this one.
[4 May 2010 11:58] Johannes Taxacher 
fix confirmed in repository
[4 May 2010 13:24] Tony Bedford 
An entry has been added to the 5.2.21 changelog:

In the SQL Editor, when the Alter Table context-sensitive menu option was used on a table, and changes made, it was not possible to save them, as the dialog reported that no changes to the object had been detected.