Bug #52583 Column comments incorrectly displayed in Alter Table causing overwrite on update

• Submitted: 4 Apr 2010 7:40
• Modified: 5 Apr 2010 12:49
• Reporter: Tim Brown
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.16 OSS beta
• OS: Windows (XP)
• CPU Architecture: Any
• Tags: ALTER TABLE, comments, sql editor

[4 Apr 2010 7:40] Tim Brown

Description:
When a comment is added to a column through the Alter Table it updates fine but when you open Alter Table again the comment has the last character cropped off and a single apostrophe at the start e.g. if you add the comment "test" it is saved as "test" but shows up as "`tes".

If you then add a new comment to the same field without correcting the first one, your first comment is stored incorrectly.

How to repeat:
From within SQL Editor, right click on a table and select Alter Table. Click "Columns" tab and highlight a column. Add some text to the comments box and click apply and close. Open Alter Table again and you can see the malformed comment.

[4 Apr 2010 7:50] Valeriy Kravchuk

Looks like a duplicate of Bug #51972. Please, check with a newer version, 5.2.17, and inform about the results.

[5 Apr 2010 9:01] Tim Brown

now fixed in version 5.2.17, thanks.

[5 Apr 2010 12:49] Valeriy Kravchuk

Not repeatable in 5.2.17. Likely a duplicate of a closed bug.