Bug #51972 Altar Table GUI, Column Comments: single quote & truncation issue
Submitted: 11 Mar 2010 22:32 Modified: 16 Apr 2010 14:18
Reporter: Samir Abboushi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.16 Beta Revision 5249 OS:Windows (Vista 64)
Assigned to: Sergei Tkachenko CPU Architecture:Any
Tags: Altar Table GUI, comments

[11 Mar 2010 22:32] Samir Abboushi
Description:
Altar Table GUI displays a single quote ("'") as the first character of a comment and truncates (in the display) the last character of the comment.

e.g. "1234" will be displayed as "'123" (without the double quotes ('"').

May be related to Bug #51969 SHOW CREATE TABLE generates a statement with pairs of single quote (“'”) 

How to repeat:
Use the Altar Table GUI or SQL to add a comment to a column, e.g. "1234" (without the quotes.

If Altar Table GUI was used, close and reopen it.  Examine the column comment and you will see "'123'" (without the double quotes)

Execute a SHOW CREATE TABLE statement and you will see that this is a display issue only (i.e. the resulting CREATE statement will have COMMENT '1234')

Suggested fix:
Display the Comment in its entirety and don't display the single quote.
[12 Mar 2010 13:27] Johannes Taxacher
additionally \n characters, if contained in a comment,  are not correctly turned into line-breaks when comment is displayed in editor
[13 Mar 2010 9:19] vincent valvona
Same on Mac OS X
The extra single quote ("'") single quote isn't just a cosmetic issue, if you alter the comment and try to save the new comment without having deleted the extra quote at the beginning then it is sent as

COMMENT =''Modified comment'
and produces an error
[23 Mar 2010 12:38] Valeriy Kravchuk
Bug #52297 was marked as a duplicate of this one.
[30 Mar 2010 20:10] Johannes Taxacher
fixed in repository
[16 Apr 2010 14:18] Tony Bedford
An entry has been added to the 5.2.17 changelog:

The Alter Table dialog in the SQL Editor displayed comments with a single quote character prepending it, and with the last character of the comment truncated.