[
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16964928#comment-16964928
]
Julian Reschke edited comment on OAK-8162 at 11/12/19 3:29 PM:
---------------------------------------------------------------
trunk: (1.14.0) [r1857996|http://svn.apache.org/r1857996]
1.10: (1.10.6) [r1869270|http://svn.apache.org/r1869270]
1.8: [r1869704|http://svn.apache.org/r1869704]
was (Author: reschke):
trunk: (1.14.0) [r1857996|http://svn.apache.org/r1857996]
1.10: [r1869270|http://svn.apache.org/r1869270]
> When query with OR is divided into union of queries, options (like index tag)
> are not passed into subqueries.
> --------------------------------------------------------------------------------------------------------------
>
> Key: OAK-8162
> URL: https://issues.apache.org/jira/browse/OAK-8162
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: core
> Affects Versions: 1.10.2, 1.8.17
> Reporter: Piotr Tajduś
> Assignee: Thomas Mueller
> Priority: Major
> Fix For: 1.14.0, 1.8.18, 1.10.6
>
>
> When query with OR is divided into union of queries, options (like index tag)
> are not passed into subqueries - in effect alternative query sometimes f.e.
> uses indexes it shouldn't use.
> {noformat}
> org.apache.jackrabbit.oak.query.QueryImpl.buildAlternativeQuery()
> org.apache.jackrabbit.oak.query.QueryImpl.copyOf()
>
> 2019-03-21 16:32:25,600 DEBUG
> [org.apache.jackrabbit.oak.query.QueryEngineImpl] (default task-1) Parsing
> JCR-SQL2 statement: select distinct d.* from [crkid:document] as d where
> ([d].[metadane/inneMetadane/*/wartosc] = 'AX' and
> [d].[metadane/inneMetadane/*/klucz] = 'InnyKod') or
> ([d].[metadane/inneMetadane/*/wartosc] = 'AB' and
> [d].[metadane/inneMetadane/*/klucz] = 'InnyKod') option(index tag
> crkid_dokument_month_2019_3)
> 2019-03-21 16:32:25,607 DEBUG [org.apache.jackrabbit.oak.query.QueryImpl]
> (default task-1) cost using filter Filter(query=select distinct d.* from
> [crkid:document] as d where ([d].[metadane/inneMetadane/*/wartosc] = 'AB')
> and ([d].[metadane/inneMetadane/*/klucz] = 'InnyKod'), path=*,
> property=[metadane/inneMetadane/*/klucz=[InnyKod],
> metadane/inneMetadane/*/wartosc=[AB]])
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
