Bug #18044 Script tab parses \' wrong.
Submitted: 7 Mar 2006 17:23 Modified: 27 Nov 2006 11:41
Reporter: Tobias Asplund Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.20 OS:Windows (Windows)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Source Editors

[7 Mar 2006 17:23] Tobias Asplund
Description:
QB fails to parse \' correctly (replacing \' with '' works, however).

It works correctly in 1.1.17, so somewhere along the path from that it broke.

How to repeat:
CREATE TABLE t123 ( a CHAR(5) );

INSERT INTO t123 VALUES ('a\'b');
INSERT INTO t123 VALUES ('def');

paste this into a script tab of the QB and try to run it, you will get a syntax error.
[17 Jul 2006 11:09] Tobias Asplund
This seriously have to be escalated in severity. It currently means that you cannot even import out example tables from the documentation section without syntax errors.
[27 Nov 2006 11:41] Mike Lischke
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/