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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.11.1
• Fix Version/s: 2.13
• Component/s: sql
• Labels: ise.lts
• Release Note: Fixed query engine allows to insert rows with logically equal compound PK
• Ignite Flags: Release Notes Required
• Assignee: Taras Ledkov
• Reporter: Taras Ledkov
• Created: 08/Feb/22 08:30
• Updated: 13/May/22 09:20
• Resolved: 14/Feb/22 10:57

Description

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:

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

Issue Links

• links to: GitHub Pull Request #9808
• links to: TC result
• links to: TCBot