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

[jira] [Comment Edited] (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:comment-tabpanel&focusedCommentId=17241394#comment-17241394 ] 

Taras Ledkov edited comment on IGNITE-13765 at 12/1/20, 9:32 AM:
-----------------------------------------------------------------

[~korlov], thanks for contribution.
Merged to 
- [master|https://github.com/apache/ignite/commit/006c566d6743d00c63eb816930b9c41f22e1e7a6]
- [ignite-2.9.1|https://github.com/apache/ignite/commit/fc22988eb02fe6a7da6aebdb999bf62dc8d59642]


was (Author: tledkov-gridgain):
[~korlov], thanks for contribution.
Merged to 
- [master|https://github.com/apache/ignite/commit/006c566d6743d00c63eb816930b9c41f22e1e7a6]

> 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: Blocker
>             Fix For: 2.10, 2.9.1
>
>         Attachments: CompoundPkPredicateTest.java
>
>          Time Spent: 20m
>  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)