Bug #18835 CASE not recognised as key word
Submitted: 6 Apr 2006 8:03 Modified: 1 Nov 2006 15:15
Reporter: Scott Cadzow Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.20 OS:Windows (XP SP2)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Source Editors

[6 Apr 2006 8:03] Scott Cadzow 
Description:
When attempting to add a "CASE .. WHEN .. THEN .. END" statement the CASE keyword is not recognised

How to repeat:
When attempting to add a "CASE .. WHEN .. THEN .. END" statement the CASE keyword is not recognised

Suggested fix:
It is not clear if the CASE statement is recognised by the mySQL server so it is necessary to validate the operation of the CASE statement and to verify that CASE is a mySQL keyword.
[6 Apr 2006 11:04] Valeriy Kravchuk 
Thank you for a bug report. Yes, "case" is not highlighted by QB 1.1.20 as other keywords.
[1 Nov 2006 15:15] 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 bug fix. More information about accessing the source trees is available at

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