You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ilya Kazakov (Jira)" <ji...@apache.org> on 2020/11/26 03:08: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 ]

Ilya Kazakov updated IGNITE-13765:
----------------------------------
    Description: 
The combination of these two conditions results in an empty selection always, 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.

 

  was:
Еhe combination of these two conditions results in an empty selection always, 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.

 


> 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
>            Priority: Major
>         Attachments: CompoundPkPredicateTest.java
>
>
> The combination of these two conditions results in an empty selection always, 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)