[jira] [Commented] (IGNITE-13765) Incorrect work of predicates (< and >) in where clause with compound primary key.

["Konstantin Orlov (Jira)" <ji...@apache.org>]

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

Konstantin Orlov commented on IGNITE-13765:
-------------------------------------------

[~tledkov-gridgain], do a review please.

> Incorrect work of predicates (< and >) in where clause with compound primary key.
> ---------------------------------------------------------------------------------
>
>                 Key: IGNITE-13765
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13765
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.9, 2.8.1
>            Reporter: Ilya Kazakov
>            Assignee: Konstantin Orlov
>            Priority: Major
>         Attachments: CompoundPkPredicateTest.java
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> The combination of these two conditions always gives an empty selection, but the result must not be empty.
>  * Compound primary key (2 or more columns)
>  * In select query in where clause use condition on every pk-column only once and one of this conditions should be < or > 
> The reproducer is attached.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)