problem with SQL query that uses "contains" function

[Lei Zhou]

Hi all,

I have the following SQL query (using Jackrabbit 1.3.1): 

select * from my:nodeType where jcr:path LIKE '/my:root/contents/%' AND 
my:state='published' AND contains(., 'account')

When I run it against the repository, from time to time, the resultset may 
contain some entries that doesn't match the condition "contains(., 
'account')" at all.

Is this a bug or something I just didn't pickup? 

Thanks