jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Zhou <L...@pointalliance.com>
Subject problem with SQL query that uses "contains" function
Date Mon, 24 Mar 2008 21:34:45 GMT
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? 


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message