[jira] [Updated] (IGNITE-16494) Query engine allows to insert rows with logically equal compound PK

["Amelchev Nikita (Jira)" <ji...@apache.org>]

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

Amelchev Nikita updated IGNITE-16494:
-------------------------------------
    Ignite Flags: Release Notes Required  (was: Docs Required,Release Notes Required)
    Release Note: Fixed query engine allows to insert rows with logically equal compound PK

> Query engine allows to insert rows with logically equal compound PK
> -------------------------------------------------------------------
>
>                 Key: IGNITE-16494
>                 URL: https://issues.apache.org/jira/browse/IGNITE-16494
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.11.1
>            Reporter: Taras Ledkov
>            Assignee: Taras Ledkov
>            Priority: Major
>             Fix For: 2.13
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> It's possible now to insert two logically equal yet physically different keys with SQL API into a table, that will bring indexes into inconsistent state.
> For example follow snippet will pass, although it should have fallen on the third statement:
> {code}
> create table test (id1 int, id2 int, val int, constraint primary key(id1, id2));
> insert into test (id1, id2, val) values (1, null, 1);
> insert into test (id1, val) values (1, 1); <-- should fail here because there is already exists such key, but it's
> {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)