Taras Ledkov created IGNITE-16494:
-------------------------------------
Summary: 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
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)
