[
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)
