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.
