| 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: | |
| 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 | ||
[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.
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.