[IGNITE-23278] Calcite. Incorrect error with TIMESTAMP WITH TIME ZONE type

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.14
• Fix Version/s: 2.17
• Labels: calcite ignite-2 ise
• Release Note: SQL Calcite: Fixed incorrect error for TIME* WITH TIME ZONE types
• Ignite Flags: Release Notes Required
• Assignee: Vladimir Steshin
• Reporter: Vladimir Steshin
• Created: 25/Sep/24 18:00
• Updated: 04/Oct/24 08:00
• Resolved: 04/Oct/24 07:30

Description

Wrong error on TIMESTAMP WITH TIME ZONE type even if we do not support it. Not a 'null type' or NPE.

Reproducer:

sql("CREATE TABLE test (val TIMESTAMP WITH TIME ZONE)");

Error:

java.lang.NullPointerException: null
	at org.apache.ignite.internal.processors.query.calcite.exec.ddl.DdlCommandHandler.toQueryEntity(DdlCommandHandler.java:330) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.ddl.DdlCommandHandler.handle0(DdlCommandHandler.java:141) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.ddl.DdlCommandHandler.handle(DdlCommandHandler.java:106) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.executeDdl(ExecutionServiceImpl.java:528) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.executePlan(ExecutionServiceImpl.java:518) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.CalciteQueryProcessor.lambda$parseAndProcessQuery$6(CalciteQueryProcessor.java:530) ~[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/:?]

Or

sql("CREATE TABLE test (val TIMESTAMP)");

sql("INSERT INTO test VALUES (CAST('2024-07-22 12:00:00 -02:00' as TIMESTAMP WITH TIME ZONE))")

Error:

java.lang.RuntimeException: unsupported type null
	at org.apache.calcite.linq4j.tree.Types.toClass(Types.java:152) ~[calcite-linq4j-1.37.0.jar:1.37.0]
	at org.apache.calcite.linq4j.tree.Types.isAssignableFrom(Types.java:233) ~[calcite-linq4j-1.37.0.jar:1.37.0]
	at org.apache.calcite.linq4j.tree.Types.needTypeCast(Types.java:476) ~[calcite-linq4j-1.37.0.jar:1.37.0]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.ConverterUtils.convert(ConverterUtils.java:224) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.ConverterUtils.convert(ConverterUtils.java:195) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.ConverterUtils.convert(ConverterUtils.java:183) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.translateCast(RexToLixTranslator.java:558) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$CastImplementor.implementSafe(RexImpTable.java:1535) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.genValueStatement(RexImpTable.java:1956) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.implement(RexImpTable.java:1917) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:1052) ~[classes/:?]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:81) ~[classes/:?]
....

Issue Links

• relates to: IGNITE-23298 Calcite. Pass and read user-side timezone.
• links to: GutHub Pull Request #11566