[
https://issues.apache.org/jira/browse/IGNITE-10379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728708#comment-16728708
]
Vladimir Ozerov commented on IGNITE-10379:
------------------------------------------
Design considerations:
1) Consider limit of elements between bounds after which partition pruning is
not very beneficial and hence could be skipped. E.g. 16 elements. Consider
adding it to {{IgniteSystemProperties}}
2) May be it makes sense to move greater/less optimizations to a separate
ticket, as they will require more complex expression tree analysis
3) For BETWEEN with parameters we are likely to need additional node type (e.g.
RangeNode). For constants, group node will be enough.
> SQL: Extract partition info from BETWEEN and range conditions for integer
> types
> -------------------------------------------------------------------------------
>
> Key: IGNITE-10379
> URL: https://issues.apache.org/jira/browse/IGNITE-10379
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Vladimir Ozerov
> Priority: Major
> Labels: iep-24
>
> If there is a range condition on affinity column of integer type, we may try
> to extract partition info from it in a way similar to IN clause [1]:
> {{x BETWEEN 1 and 5}} -> {{x IN (1, 2, 3, 4, 5)}}
> {{x > 1 and x <= 5}} -> {{x IN (2, 3, 4, 5)}}
> [1] IGNITE-9632
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
