Bug #15138 Syntax error during script execution
Submitted: 22 Nov 2005 15:27 Modified: 4 Jan 2006 14:59
Reporter: Victoria Reznichenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.17 OS:Windows (windows)
Assigned to: Mike Lischke CPU Architecture:Any

[22 Nov 2005 15:27] Victoria Reznichenko 
Description:
MySQL Query Browser produces syntax error if SQL statement contains newlines and semi-colons.

How to repeat:
execute script via MySQL Query Browser
[3 Jan 2006 13:17] Mike Lischke 
Sorry, I cannot reproduce the problem here. Even if I use the erroneus way of having a new line within a string constant (which is in no programming or scripting language allowed that I know, and I know quite some). It does not matter whether I execute the query exactly as I copy it out of the browser or if I move the second line of the INSERT INTO qberr.test command up so that the first VALUE becomes ''.

Mike
[3 Jan 2006 14:23] MySQL Verification Team 
script

Attachment: script.sql (application/octet-stream, text), 627 bytes.
[3 Jan 2006 14:24] MySQL Verification Team 
I uploaded file with SQL statements cause syntax error (it works ok if I just copy/paste from bug report).
[4 Jan 2006 14:59] Mike Lischke 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html