MySQL Bugs: #17111: False syntax erors

Bug #17111	False syntax erors
Submitted:	4 Feb 2006 2:39	Modified:	4 Dec 2006 10:54
Reporter:	Chris Tallman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.19	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Source Editors

Description:
The install script from ver 1.2.4 of ChurchInfo, avalible from SourceForge, fails when run inside query browser, but runs fine if executed from the command line.  I have repeated this on two seperate XP machines with different downloads of the same application.

How to repeat:
To get a successful execution comment out lines 274,275 and 276.  Next I found anomolies on lines 488 and 489. If I back space from the last value of 0, in order to get everything on line 487 the cursor will jump to the right and delete the last value of 0, and does the same thing on the second to last value deleteing the 1. So I just typed them back in and it executes fine.
 
After running the script with 274, 275 and 276 commented out I run them all individualy in a resultset window and they insert fine. I also found that trying to execute all three lines at the same time and they fail again? 
 

Suggested fix:
?

Seems similar to another post I seen describing indentions in the SQL code.

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html