[ https://issues.apache.org/jira/browse/IGNITE-16578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vyacheslav Koptilin updated IGNITE-16578: ----------------------------------------- Labels: ignite-3 (was: ) > Sql. Implement validation of inserts with composite PK and partially > determined PK consistent columns. > ------------------------------------------------------------------------------------------------------ > > Key: IGNITE-16578 > URL: https://issues.apache.org/jira/browse/IGNITE-16578 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Evgeny Stanilovsky > Assignee: Evgeny Stanilovsky > Priority: Major > Labels: ignite-3 > Fix For: 3.0.0-alpha5 > > > Partial PK update possibilities: > {noformat} > CREATE TABLE test1 (k1 int, k2 int, a int, b int, CONSTRAINT PK PRIMARY KEY > (k1, k2)); > INSERT INTO test1 (k2, b) VALUES (1, 1); <-- need to be rejected > CREATE TABLE test2 (k1 int DEFAULT 0, k2 int, a int, b int, CONSTRAINT PK > PRIMARY KEY (k1, k2)); > INSERT INTO test1 (k2, b) VALUES (1, 1); <-- it`s all ok there. > {noformat} -- This message was sent by Atlassian Jira (v8.20.1#820001)