[
https://issues.apache.org/jira/browse/OAK-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14242397#comment-14242397
]
Thomas Mueller commented on OAK-2339:
-------------------------------------
Can the LucenePropertyIndex be used for the following query?
{noformat}
SELECT value FROM nt:unstructured ORDER BY jcr:score
{noformat}
If not, why not?
> LucenePropertyIndex should support path restrictions expressed via jcr:path
> ---------------------------------------------------------------------------
>
> Key: OAK-2339
> URL: https://issues.apache.org/jira/browse/OAK-2339
> Project: Jackrabbit Oak
> Issue Type: Improvement
> Components: oak-lucene
> Reporter: Chetan Mehrotra
> Priority: Minor
> Fix For: 1.2
>
>
> Following testcase fail for {{LucenePropertyIndex}} as it does not handle
> query like
> bq. SELECT value FROM nt:unstructured WHERE jcr:path LIKE '/testroot/%' ORDER
> BY jcr:score
> It supports queries where path restriction is specified explicitly via
> {{isdescendantnode}}. Following options are possible
> # For generic cases like /foo/% we can convert it to
> isdescendantnode(.,'/foo')
> # For any other case like /foo/%/bar we can do a best effort change and
> return result for /foo
> # For any other case opt out
> {noformat}
> testOrderByScore(org.apache.jackrabbit.core.query.OrderByTest): No plan
> found for filter [Filter(query=SELECT value FROM nt:unstructured WHERE
> jcr:path LIKE '/testroot/%' ORDER BY jcr:score, value, path=*)] while using
> definition [IndexDefinition : /oak:index/luceneGlobal] and testMode is found
> to be enabled
> testOrderByMVP(org.apache.jackrabbit.core.query.OrderByTest): No plan found
> for filter [Filter(query=SELECT value FROM nt:unstructured WHERE jcr:path
> LIKE '/testroot/%' ORDER BY text, path=*)] while using definition
> [IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be
> enabled
> testSimpleQuerySQL4(org.apache.jackrabbit.core.query.SimpleQueryTest): No
> plan found for filter [Filter(query=SELECT * FROM nt:unstructured WHERE
> jcr:path LIKE '/testroot/%', path=*)] while using definition [IndexDefinition
> : /oak:index/luceneGlobal] and testMode is found to be enabled
> testIsNull(org.apache.jackrabbit.core.query.SimpleQueryTest): No plan found
> for filter [Filter(query=SELECT * FROM nt:unstructured WHERE mytext is null
> and jcr:path LIKE '/testroot/%', path=*)] while using definition
> [IndexDefinition : /oak:index/luceneGlobal] and testMode is found to be
> enabled
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
