Bug #32736 SQL treated as a comment
Submitted: 26 Nov 2007 19:52 Modified: 10 Feb 2009 22:08
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.12 OS:Windows (Vista, XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: comment, highlighting, qc, SQL, syntax

[26 Nov 2007 19:52] Jared S
Description:
There is a very annoying gremlin in MySQL Query Browser that treats actuals SQL code as a comment.  Please see my repo steps..

How to repeat:
--
-- Cut & paste these 4 lines into QB
--
UPDATE `flat-settings` SET value = '1.2.1' WHERE iname = 'Gene_Version';

RESULT when you trim the semi-colon and place cursor at top of comments, the sql line is then treated as a comment.
[26 Nov 2007 20:20] Valeriy Kravchuk
Thank you for a bug report. Verified just as described on XP.
[10 Feb 2009 12:44] Mike Lischke
Jared, I don't see this effect in QB. How do you come to the conclusion that the SQL line is treated as comment? When you execute it (by placing the caret in that line and press ctrl+enter) does it show an error about an empty command? Also, is the text all gray and printed with italic font like the comment starting with double dash?
[10 Feb 2009 22:08] Jared S
I have been confused by because I thought gray lines were all comments but comments are actually *in reality* white backcolor - although this is never seen.