[IGNITE-15112] Calcite bug. Function TRUNCATE fails for NULL argument

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Iurii Gerzhedovich
• Created: 12/Jul/21 14:20
• Updated: 04/Aug/21 07:38
• Resolved: 04/Aug/21 07:38

Description

Function INITCAP fails for NULL argument

see src/test/sql/function/numeric/test_truncate.test_ignore

SELECT truncate(null)

java.lang.RuntimeException: while resolving method 'valueOf[void]' in class class java.lang.Voidjava.lang.RuntimeException: while resolving method 'valueOf[void]' in class class java.lang.Void
 at org.apache.calcite.linq4j.tree.Types.lookupMethod(Types.java:318) at org.apache.calcite.linq4j.tree.Expressions.call(Expressions.java:448) at org.apache.calcite.linq4j.tree.Expressions.call(Expressions.java:460) at org.apache.calcite.linq4j.tree.Expressions.box(Expressions.java:1424) at org.apache.ignite.internal.processors.query.calcite.exec.exp.ConverterUtils.convert(ConverterUtils.java:305) at org.apache.ignite.internal.processors.query.calcite.exec.exp.ConverterUtils.convert(ConverterUtils.java:176) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.genValueStatement(RexImpTable.java:1963) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexImpTable$AbstractRexCallImplementor.implement(RexImpTable.java:1910) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:991) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:79) at org.apache.calcite.rex.RexCall.accept(RexCall.java:189) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitLocalRef(RexToLixTranslator.java:886) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitLocalRef(RexToLixTranslator.java:79) at org.apache.calcite.rex.RexLocalRef.accept(RexLocalRef.java:77) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.translate(RexToLixTranslator.java:205) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.translate(RexToLixTranslator.java:198) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.translateList(RexToLixTranslator.java:763) at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.translateProjects(RexToLixTranslator.java:179) at org.apache.ignite.internal.processors.query.calcite.exec.exp.ExpressionFactoryImpl.compile(ExpressionFactoryImpl.java:300) at org.apache.ignite.internal.processors.query.calcite.exec.exp.ExpressionFactoryImpl.lambda$scalar$4(ExpressionFactoryImpl.java:263)

Issue Links

• is fixed by: IGNITE-15002 Calcite engine. String functions fail on NULL constant
• is part of: IGNITE-14535 Caclite SQL engine capabilities