Bug #60500 Alter table does not detecting changes made to column comments

• Submitted: 17 Mar 2011 4:02
• Modified: 17 Mar 2011 10:50
• Reporter: david pugh
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.32
• OS: Windows
• CPU Architecture: Any

[17 Mar 2011 4:02] david pugh

Description:
After making changes to a columns comment's and not making any further changes to the table.  Your actions are not being detected and the "No changes to object were detected message" is being displayed on clicking apply. 

How to repeat:
repeatable

[17 Mar 2011 4:13] Valeriy Kravchuk

What exact version of server, 5.x.y, are you working with?

I can not repeat it with Workbench 5.2.33 while working with MySQL 5.1.57 on Mac OS X.

[17 Mar 2011 5:44] david pugh

Server version is 5.1.53.

I have noticed this on previous versions of workbench, so I don't think it is related to this release.

[17 Mar 2011 5:50] david pugh

I might not have update the OS field when submitting the bug

I am using workbench under Windows 7

[17 Mar 2011 7:51] Valeriy Kravchuk

Please, check with 5.2.33. I still do not see any problem with Workbench 5.2.33 on Windows XP SP2 while working with local MySQL server 5.1.56. The following code was generated when I tried to remove a couple of characters from column comment:

ALTER TABLE `test`.`a` CHANGE COLUMN `method` `method` TINYINT(4) NOT NULL COMMENT 'cm'  ;

Send exact CREATE TABLE statement and describe what comment to change and in what way if you still see this with 5.2.33.

[17 Mar 2011 10:19] david pugh

I have installed 5.2.33 and it is working correctly now.  

Thank you for your help

[17 Mar 2011 10:50] Valeriy Kravchuk

Not repeatable with current version, 5.2.33.