[jira] [Comment Edited] (IGNITE-23426) Calcite. 'CREATE TABLE' fails if 'DEFAULT' is null.

[Vladimir Steshin (Jira)]

    [ 
https://issues.apache.org/jira/browse/IGNITE-23426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17889286#comment-17889286
 ] 

Vladimir Steshin edited comment on IGNITE-23426 at 10/14/24 5:45 PM:
---------------------------------------------------------------------

Reproducer:

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

{code:java}
org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot convert 
literal NULL to type class java.lang.Byte
        at 
org.apache.ignite.internal.processors.query.calcite.util.TypeUtils.fromLiteral(TypeUtils.java:508)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.prepare.ddl.DdlSqlToCommandConverter.convertCreateTable(DdlSqlToCommandConverter.java:235)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.prepare.ddl.DdlSqlToCommandConverter.convert(DdlSqlToCommandConverter.java:158)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.prepare.PrepareServiceImpl.prepareDdl(PrepareServiceImpl.java:132)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.prepare.PrepareServiceImpl.prepareSingle(PrepareServiceImpl.java:84)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.lambda$parseAndProcessQuery$5(CalciteQueryProcessor.java:524)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.prepare.QueryPlanCacheImpl.lambda$queryPlan$0(QueryPlanCacheImpl.java:70)
 ~[classes/:?]
        at 
java.base/java.util.concurrent.ConcurrentMap.computeIfAbsent(ConcurrentMap.java:330)
 ~[?:?]
        at 
org.apache.ignite.internal.processors.query.calcite.prepare.QueryPlanCacheImpl.queryPlan(QueryPlanCacheImpl.java:70)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.lambda$parseAndProcessQuery$6(CalciteQueryProcessor.java:521)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.processQuery(CalciteQueryProcessor.java:641)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.parseAndProcessQuery(CalciteQueryProcessor.java:518)
 ~[classes/:?]
        at 
org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.query(CalciteQueryProcessor.java:393)
 ~[classes/:?]
{code}

Adoption of #IGNITE-18965



was (Author: vladsz83):
Reproducer:

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

Adoption of #IGNITE-18965


> Calcite. 'CREATE TABLE' fails if 'DEFAULT' is null.
> ---------------------------------------------------
>
>                 Key: IGNITE-23426
>                 URL: https://issues.apache.org/jira/browse/IGNITE-23426
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 2.14
>            Reporter: Vladimir Steshin
>            Assignee: Vladimir Steshin
>            Priority: Major
>              Labels: calcite, ignite-2, ise
>




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