Bug #52608 Table Comment not properly escaping
Submitted: 5 Apr 2010 23:38 Modified: 26 Apr 2010 13:19
Reporter: Martin Pirringer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.17 OS:Any
Assigned to: CPU Architecture:Any
Tags: Comment Escaping

[5 Apr 2010 23:38] Martin Pirringer 
Description:
Single quote not escaping in Table comment

How to repeat:
Add a table comment with a single quote like
Let's go

Then sync will cause an error

Suggested fix:
Change above 'Let's go' to 'Let\'s go' like in the comments of individual fields
[5 Apr 2010 23:49] MySQL Verification Team 
Thank you for the bug report.
[21 Apr 2010 0:04] Alfredo Kojima 
Alter code generation fixed
[24 Apr 2010 0:30] Johannes Taxacher 
fix confirmed in repository
[26 Apr 2010 13:19] Tony Bedford 
An entry has been added to the 5.2.20 changelog:

If a table comment contained a single quote character, then when an attempt was made to synchronize this with a live server, an error would result. This was because the code generated by the synchronization process did not escape single quotes in the table comments.