MySQL Bugs: #25704: Quoting in backquotes should not highlited

Bug #25704	Quoting in backquotes should not highlited
Submitted:	18 Jan 2007 19:27	Modified:	30 Jan 2007 15:51
Reporter:	Sebastien Caisse	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.2	OS:	Windows (Windows XP Pro, sp2)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
When you're trying to set a "legible" name in as an "AS" value using a backquote and you're using a double or single quote in it (while not closing it), the syntax highliting thus never ends.

How to repeat:
Simply type something with a quote/double quote, for example:

SELECT "Red" AS `User's favorite color`;

Suggested fix:
For the syntax highliting engine, treat backquotes in a similar fashion as quotes - though with no real highliting...

Thank you for the bug report. I was unable to repeat or I didn't understood
what are you reporting. Could you please attach a picture illustrating
that? Thanks in advance.

Sample picture of issue

Attachment: string_backquote_issue.png (image/x-png, text), 3.34 KiB.

In the picture you'll notice that the backquote for the name start, then a single quote is used and starts a string - which is not as string, it's a field value. The backquote is closed, yet the highliting of the string remains until the end of the line.

Nothing huge albeit annoying.

Obviously the query works pefectly fine in MySQL.

What is your Windows regional setting language? Thanks in advance.

English (Canada)

Sorry, after quite some fiddinling I recently discovered that I still had 1.1.20 isntalled and the query System Tray monitor was of that version and as such started the old 1.1.2 version instead of the 1.1.20r9 (or 8 in which the bug was reported!