You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@jackrabbit.apache.org by Maxim Usoltsev <ma...@gmail.com> on 2010/12/20 09:44:16 UTC

CONTAINS and inner join : javax.jcr.UnsupportedRepositoryOperationException

Hi !
jackrabbit 2.2, JCR-SQL2 query

select
agent0.[jcr:uuid] as agent0_uuid
FROM
[dt:Agent] as agent0
inner join [dt:folder] as parentFolder on IsChildNode(agent0, parentFolder)
WHERE
CONTAINS(agent0.*, '*1234*')

throws exception

11:35:06,533 ERROR [STDERR]
javax.jcr.UnsupportedRepositoryOperationException: Unknown constraint
type: CONTAINS(agent0.*, '*1234*')
11:35:06,534 ERROR [STDERR] 	at
org.apache.jackrabbit.core.query.lucene.join.ConstraintSplitter.getSelectorNames(ConstraintSplitter.java:177)
11:35:06,534 ERROR [STDERR] 	at
org.apache.jackrabbit.core.query.lucene.join.ConstraintSplitter.split(ConstraintSplitter.java:106)
11:35:06,534 ERROR [STDERR] 	at
org.apache.jackrabbit.core.query.lucene.join.ConstraintSplitter.<init>(ConstraintSplitter.java:80)
11:35:06,534 ERROR [STDERR] 	at
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:162)
11:35:06,534 ERROR [STDERR] 	at
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:147)
11:35:06,534 ERROR [STDERR] 	at
org.apache.jackrabbit.core.query.QueryObjectModelImpl.execute(QueryObjectModelImpl.java:114)

But query without inner join works fine :
select
agent0.[jcr:uuid] as agent0_uuid
FROM
[dt:Agent] as agent0
WHERE
CONTAINS(agent0.*, '*1234*')

Is it right ?
How can i use "contains" in query with more then one selector ?

--
Regards, Max.