[IGNITE-23426] Calcite. 'CREATE TABLE' fails if 'DEFAULT' is null.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.14
• Fix Version/s: 2.17
• Labels: calcite ignite-2 ise
• Release Note: SQL Calcite: Fixed failure on 'CREATE TABLE' DDL with Calcite engine when 'DEFAULT' column value is NULL.
• Ignite Flags: Release Notes Required
• Assignee: Vladimir Steshin
• Reporter: Vladimir Steshin
• Created: 14/Oct/24 17:41
• Updated: 16/Oct/24 15:28
• Resolved: 16/Oct/24 15:28

Description

Reproducer:

CREATE TABLE tbl(id int PRIMARY KEY, val INTEGER DEFAULT NULL)

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/:?]

Adoption of #IGNITE-18965

Issue Links

• links to: GitHub Pull Request #11591