[
https://issues.apache.org/jira/browse/OAK-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14242393#comment-14242393
]
Thomas Mueller commented on OAK-2339:
-------------------------------------
[~chetanm] are you aware of OAK-2134 - Lucene: not using the path restriction
can speed up queries ? Does the Lucene property index store the path as one
term, the same as the Lucene full-text index? If yes, then path constraints
that match many thousand nodes are going to run into the same problem.
(I know this is not related to "jcr:path like ...", but it is important to
understand)
> 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)
