You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2019/01/16 14:17:00 UTC

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

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

Vladimir Ozerov updated IGNITE-10379:
-------------------------------------
    Ignite Flags:   (was: Docs Required)

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