Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#782 highlighting of SQL keywords

2.6.9
open
Colin Bell
5
2012-12-29
2009-07-30
Anonymous
No

Hi. I'm using Java 1.5 and SQuirreL SQL Client 2.6.9. It looks like database-specific keywords are not highlighted properly. For example, SQL Server has the operators CONTAINS and CONTAINSTABLE for full-text search. When I'm writing queries using those two operators in SQuirreL, the operator CONTAINS is not highlighted (it's in black). The operator CONTAINSTABLE is highlighted in red instead of blue (I think SQuirreL actually considers CONTAINSTABLE as a syntax error). Two of my queries looks like the following:

select id
from message m
where contains (body, '"writedowns"')

select id
from message m, containstable (message, body, '"shell"')
where m.id = "key"

Both queries run fine. The problem is just the highlighting of CONTAINS and CONTAINSTABLE. I'm wondering if this is a bug or this is just how SQuirreL works. Thanks.

Discussion