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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Anton Vinogradov (Jira)
Vladimir Ozerov created IGNITE-10379:
----------------------------------------

             Summary: 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


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)