[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-12 Thread Julian Reschke (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Reschke updated OAK-8162:

Labels:   (was: candidate_oak_1_8)

> 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-12 Thread Julian Reschke (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Reschke updated OAK-8162:

Fix Version/s: 1.8.18

> 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_8
> 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-01 Thread Julian Reschke (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Reschke updated OAK-8162:

Fix Version/s: 1.10.6

> 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, 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-01 Thread Julian Reschke (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Reschke updated OAK-8162:

Labels: candidate_oak_1_8  (was: candidate_oak_1_10 candidate_oak_1_8)

> 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_8
> Fix For: 1.14.0, 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-01 Thread Thomas Mueller (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Mueller updated OAK-8162:

Labels: candidate_oak_1_10 candidate_oak_1_8  (was: )

> 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-01 Thread Thomas Mueller (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Mueller updated OAK-8162:

Affects Version/s: (was: 1.6.18)

> 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
>
>
> 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-11-01 Thread Thomas Mueller (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Mueller updated OAK-8162:

Affects Version/s: 1.6.18
   1.8.17

> 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.6.18, 1.8.17
>Reporter: Piotr Tajduś
>Assignee: Thomas Mueller
>Priority: Major
> 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-10-31 Thread Thomas Mueller (Jira) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Mueller updated OAK-8162:

Fix Version/s: (was: 1.20.0)
   1.14.0

> 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
>Reporter: Piotr Tajduś
>Assignee: Thomas Mueller
>Priority: Major
> 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)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-06-04 Thread Davide Giannella (JIRA) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Davide Giannella updated OAK-8162:
--
Fix Version/s: (was: 1.14.0)

> 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
>Reporter: Piotr Tajduś
>Assignee: Thomas Mueller
>Priority: Major
> Fix For: 1.16.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
(v7.6.3#76005)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-06-04 Thread Davide Giannella (JIRA) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Davide Giannella updated OAK-8162:
--
Fix Version/s: 1.16.0

> 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
>Reporter: Piotr Tajduś
>Assignee: Thomas Mueller
>Priority: Major
> Fix For: 1.14.0, 1.16.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
(v7.6.3#76005)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-04-23 Thread Thomas Mueller (JIRA) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Mueller updated OAK-8162:

Fix Version/s: 1.14.0

> 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
>Reporter: Piotr Tajduś
>Assignee: Thomas Mueller
>Priority: Major
> 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
(v7.6.3#76005)

[jira] [Updated] (OAK-8162) When query with OR is divided into union of queries, options (like index tag) are not passed into subqueries.

2019-04-23 Thread Thomas Mueller (JIRA) 


 [ 
https://issues.apache.org/jira/browse/OAK-8162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Mueller updated OAK-8162:

Description: 
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}


  was:
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.

 

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]])


> 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
>Reporter: Piotr Tajduś
>Assignee: Thomas Mueller
>Priority: Major
>
> 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
(v7.6.3#76005)