[jira] [Created] (IGNITE-18965) Sql. CREATE TABLE fails when a column with DEFAULT constraint NULL is present.

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

Maksim Zhuravkov created IGNITE-18965:
-----------------------------------------

             Summary: Sql. CREATE TABLE fails when a column with DEFAULT constraint NULL is present.
                 Key: IGNITE-18965
                 URL: https://issues.apache.org/jira/browse/IGNITE-18965
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Maksim Zhuravkov
             Fix For: 3.0.0-beta2


Default constraint with value = NULL causes an error.

{code:java}
CREATE TABLE tbl(id int PRIMARY KEY, val INTEGER DEFAULT NULL)
{code}

{code:java}
Caused by: java.lang.ClassCastException: Cannot cast org.apache.calcite.rel.metadata.NullSentinel$1 to java.lang.Integer
	at java.base/java.lang.Class.cast(Class.java:3605)
	at org.apache.calcite.sql.SqlLiteral.getValueAs(SqlLiteral.java:288)
	at org.apache.ignite.internal.sql.engine.prepare.ddl.DdlSqlToCommandConverter.fromLiteral(DdlSqlToCommandConverter.java:799)
{code}




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