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