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:
from message m
where contains (body, '"writedowns"')
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.