You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2022/10/25 13:28:00 UTC

[jira] [Updated] (IGNITE-17972) SQL. Incorrect error message for explicit NULL values for NON NULL column

     [ https://issues.apache.org/jira/browse/IGNITE-17972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yury Gerzhedovich updated IGNITE-17972:
---------------------------------------
    Summary: SQL. Incorrect error message for explicit NULL values for NON NULL column  (was: incorrect error message for explicit NULL values for NON NULL column)

> 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
>
> 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}
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)