I have a query like select application.* from [ka:asset] as application left outer join [ka:asset] as rating on application.[jcr:uuid] = rating.[connectionId] left outer join [ka:asset] as applicant on application.[applicantId] = applicant.[jcr:uuid] where application.[ka:assetType] = 'application' and application.[positionref] = '3e32ebc9-8612-4b44-8862-cc081795a953' and application.[companyref] = '5e9d5632-c219-44bd-b6e1-f96e9f3ff37e'
If I change the first join to be a right outer join, I get a null pointer exception like java.lang.NullPointerException: null at org.apache.jackrabbit.oak.query.QueryImpl.prepare(QueryImpl.java:662) at org.apache.jackrabbit.oak.query.QueryEngineImpl.prepareAndSelect(QueryEngineImpl.java:298) at org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:273) at org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:136) Before I try to isolate this into a test case I just wanted to check if combining right and left joins are supported with or without the lucene index? Am running oak v1.4.6 without lucene index. -- -Tor
