[
https://issues.apache.org/jira/browse/IGNITE-13710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17335366#comment-17335366
]
Aleksey Plekhanov commented on IGNITE-13710:
--------------------------------------------
Since Calcite version 1.26, {{OR}} operator on the same field replaced with
{{SEARCH}} operator. If we will try to replace each {{SEARCH}} by {{UNION}},
there will be too many plan variants, since other operators can also be
translated to search (for example {{a != n}} can be replaced by {{SEARCH}} with
two ranges {{[-infinity, n)}} and {{(n, infinity]}}). I think it's better to
add native {{SEARCH}} support with the ability to scan indexes using {{SEARCH}}
operator.
> Calcite integration. Fix or to union rule logic
> -----------------------------------------------
>
> Key: IGNITE-13710
> URL: https://issues.apache.org/jira/browse/IGNITE-13710
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Igor Seliverstov
> Assignee: Aleksey Plekhanov
> Priority: Minor
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
