Problem with SQL statement highlighting

[GoogleCodeExporter]

What steps will reproduce the problem?
1. enter this into the editor set for text/sql

SELECT RandomData AS "Random" FROM History WHERE TestValue >'70' AND
RandomData > '30'

What is the expected output? What do you see instead?

The keyword and syntax highlighting works on the first part of the input:
SELECT RandomData AS "Random" FROM History WHERE TestValue >'70

then the closing ' (single quote) is shown in a different color (same brown
color as string text, but not black like the first single quote, and this
color highlighting continues for the segment:

' AND RandomData > 

then the part ( '30') is displayed correctly (black single quotes, dark
yellow text). 

EXPECTED OUTPUT:

the part that is not colored correctly (' AND RandomData >) is expected to
be a black single quote followed by the AND in blue (keyword) followed by
RandomData > in black

What version of the product are you using? 
downloaded on 9/1/09 (the one that works on Java 1.5) On what operating
system? Windows

Can anybody help fix the sql.flex file so that the parts in the second
single quotes are correctly recognized? If you only put in one condition it
works correctly (example below does not have this problem)

SELECT RandomData AS "Random Data" FROM History WHERE RandomData > '30'

Original issue reported on code.google.com by ergoma...@gmail.com on 31 Oct 2009 at 1:46

[GoogleCodeExporter]

This works in JDK6, but needs to be retrofitted to JDK 5 branch, which I cannot 
maintain.

Original comment by ayman.al...@gmail.com on 15 Nov 2009 at 6:43

• Added labels: JDK5

[GoogleCodeExporter]

no more jdk5 support.

Original comment by ayman.al...@gmail.com on 7 Jul 2010 at 1:29

• Changed state: WontFix