[jira] [Comment Edited] (IGNITE-10379) SQL: Extract partition info from BETWEEN and range conditions for integer types

["Vladimir Ozerov (JIRA)" <ji...@apache.org>]

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

Vladimir Ozerov edited comment on IGNITE-10379 at 1/14/19 2:47 PM:
-------------------------------------------------------------------

[~alapin],
My comments:
# New test class needs to be added to a test suite
# Let's try avoid repetitive operations during extraction, such as list lookups ({{AST.child(...)}}) and descriptor creation
# Let's make sure that optimization works for both {{x > 1 AND x < 10}} and {{x < 10 AND x > 1}} cases.


was (Author: vozerov):
[~alapin],
My comments:
# New test class needs to be added to a test suite
# Let's try avoid repetitive operations during extraction, such as list lookups ({{AST.child(...)}} and descriptor creation
# Let's make sure that optimization works for both {{x > 1 AND x < 10}} and {{x < 10 AND x > 1}} cases.

> 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
>            Assignee: Alexander Lapin
>            Priority: Major
>              Labels: iep-24
>             Fix For: 2.8
>
>
> 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)