You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Nikolay Izhikov (Jira)" <ji...@apache.org> on 2020/12/01 08:56:00 UTC

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

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

Nikolay Izhikov updated IGNITE-13765:
-------------------------------------
    Fix Version/s: 2.9.1

> 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
>             Fix For: 2.10, 2.9.1
>
>         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)