jackrabbit-oak-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Reschke (Jira)" <j...@apache.org>
Subject [jira] [Commented] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.
Date Fri, 01 Nov 2019 16:02:00 GMT

    [ https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16964928#comment-16964928
] 

Julian Reschke commented on OAK-8162:
-------------------------------------

trunk: (1.14.0) [r1857996|http://svn.apache.org/r1857996]

> 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
>              Labels: candidate_oak_1_10, candidate_oak_1_8
>             Fix For: 1.14.0
>
>
> 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)

Mime
View raw message