Bug #53212 SQL editor doesn't handle escaped quotes
Submitted: 27 Apr 2010 16:05 Modified: 27 Apr 2010 21:26
Reporter: Todd Farmer (OCA) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.1.17 OS:MacOS (XP)
Assigned to: CPU Architecture:Any

[27 Apr 2010 16:05] Todd Farmer 
Description:
Syntax highlighting breaks with following:

SELECT 'Doesn\'t work!';

How to repeat:
SELECT 'Doesn\'t work!';

Suggested fix:
Fix syntax highlighting to account for escaped characters.
[27 Apr 2010 16:48] Valeriy Kravchuk 
Not repeatable for me with current 5.2.20 on Mac OS X. Highlighting looks properly (as single string literal).
[27 Apr 2010 18:33] Todd Farmer 
Repeated in 5.1.19 on WinXP, attaching screenshot.
[27 Apr 2010 18:35] Todd Farmer 
Example

Attachment: SP32-20100427-113228.gif (image/gif, text), 2.76 KiB.
[27 Apr 2010 21:26] Todd Farmer 
Confirmed fixed in 5.2.20.
[28 Apr 2010 6:16] Valeriy Kravchuk 
Fixed in 5.2.20 on Windows XP also.