[jira] [Closed] (OAK-5120) Automatically convert *all* "or" queries to "union" for SQL-2, take 2

["Davide Giannella (JIRA)" <ji...@apache.org>]

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

Davide Giannella closed OAK-5120.
---------------------------------

Bulk close for 1.5.14

> Automatically convert *all* "or" queries to "union" for SQL-2, take 2
> ---------------------------------------------------------------------
>
>                 Key: OAK-5120
>                 URL: https://issues.apache.org/jira/browse/OAK-5120
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: query
>            Reporter: Thomas Mueller
>            Assignee: Thomas Mueller
>             Fix For: 1.5.14
>
>
> OAK-4681 is trying to convert "or" SQL-2 queries to union (if that's faster). However, the following nested case is not yet converted fully to a union (one "or" is converted, but the other one is not):
> {noformat}
> select * from [nt:unstructured] as [c] 
> where isdescendantnode('/tmp') 
> and ([a]=1 or [b]=2) and ([c]=3 or [d]=4)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)