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:27:00 UTC

[jira] [Created] (IGNITE-17972) incorrect

Yury Gerzhedovich created IGNITE-17972:
------------------------------------------

             Summary: incorrect 
                 Key: IGNITE-17972
                 URL: https://issues.apache.org/jira/browse/IGNITE-17972
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Yury Gerzhedovich


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)