You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2024/10/14 17:46:00 UTC
[jira] (IGNITE-23426) Calcite. 'CREATE TABLE' fails if 'DEFAULT' is null.
[ https://issues.apache.org/jira/browse/IGNITE-23426 ]
Vladimir Steshin deleted comment on IGNITE-23426:
-------------------------------------------
was (Author: vladsz83):
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
> 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)