[
https://issues.apache.org/jira/browse/IGNITE-17972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-17972:
---------------------------------------
Description:
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'
was:
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}
> 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
> Priority: Major
> Labels: ignite-3
>
> 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)
