SQL syntax higlighting misses the first single quote, and thus has inverted syntax coloring

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create a JEditorPane, init the DefaultSyntaxKit and set the contentType
if the JEditorPane to "text/sql"
2. Insert the following sql, or something like it:
SELECT * FROM a 
WHERE 
(tt LIKE 'kek%' OR a.message = 'lol') AND 
date LIKE '1970-01-01%'    

What is the expected output? What do you see instead?
The first ' has the wrong color, which means that the string color is
applied to the variables and vice versa.

What version of the product are you using? On what operating system?
0.9.5-b7 and b11 both exhibit this problem

Please provide any additional information below.
Using NetBeans 6.5 gui builder, but I doubt it matters.

Original issue reported on code.google.com by jevr...@gmail.com on 6 Mar 2009 at 9:10

Attachments:

• jsyntaxpane_fails_sql_highlighting.JPG

[GoogleCodeExporter]

Thanks for the report.  The SQL support had double quoted strings only.
Will be fixed soon.

Original comment by ayman.al...@gmail.com on 8 Mar 2009 at 5:16

• Changed state: Started
• Added labels: OpSys-All, Priority-Medium, Type-Defect

[GoogleCodeExporter]

Fixed in r96

Original comment by ayman.al...@gmail.com on 8 Mar 2009 at 6:32

• Changed state: Fixed