MySQL Bugs: #8177: Minor syntax parsing adjustments

Bug #8177	Minor syntax parsing adjustments
Submitted:	28 Jan 2005 10:24	Modified:	28 Jan 2005 12:15
Reporter:	Miko Suria	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.5	OS:	Windows (Windows 2000)
Assigned to:		CPU Architecture:	Any

Description:
I just want to point out the following adjustments concerning the SYNTAX HIGHLIGHT feature, because I definitely find it useful when testing some sql queries before putting them in PHP code:

1. Not all KEYWORDS,FUNCTION NAMES, etc. are highlighted.
2. The line terminated by a semi-colon (;) before a PERL COMMENT (#) on the following line generates an error. Other web-based apps execute the string just ok:
Line 1 -> SELECT 1+1;
Line 2 -> # blah blah comment

Error message:
You have an error in your SQL syntax near ';
# blash' at line 1

I'm also happy that the PERL COMMENT(#) syntax highlight feature was finally fixed in this release, which made my work a lot easier.

How to repeat:
1.Try typing CONCAT(),LPAD(),RPAD() and other less-common functions in the editor. These are'nt highlighted.
2. Try doing the same query as the example.

I think it's the same bug as 8154. 
http://bugs.mysql.com/bug.php?id=8154

If you disagree, you can change the status to 'Open' again