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)