[ https://issues.apache.org/jira/browse/IGNITE-17972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Konstantin Orlov updated IGNITE-17972: -------------------------------------- Fix Version/s: 3.0.0-beta2 > SQL. Incorrect error message for explicit NULL values for NON NULL column > ------------------------------------------------------------------------- > > Key: IGNITE-17972 > URL: https://issues.apache.org/jira/browse/IGNITE-17972 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Yury Gerzhedovich > Assignee: Maksim Zhuravkov > Priority: Major > Labels: ignite-3 > Fix For: 3.0.0-beta2 > > Time Spent: 20m > Remaining Estimate: 0h > > Ignite 3 has an incorrect error message during inserting explicit NULL value > for the column which has a default value and has NOT NULL constraint. > {code:java} > CREATE TABLE tbl(key int DEFAULT 9 primary key, val varchar); > INSERT INTO tbl (key, val) VALUES (NULL,'AA'); > result: Column 'KEY' has no default value and does not allow NULLs{code} > Need to amend message, due to we have DEFAULT value, but say 'has no default' > -- This message was sent by Atlassian Jira (v8.20.10#820010)