[IGNITE-15111] Calcite bug. Function INITCAP 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:05
• Updated: 04/Aug/21 07:39
• Resolved: 04/Aug/21 07:39

Description

Function INITCAP fails for NULL argument

see src/test/sql/function/string/test_initcap.test_ignore

SELECT initcap(null)

ava.lang.RuntimeException: while resolving method 'valueOf[class java.lang.String]' 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.ignite.internal.processors.query.calcite.exec.exp.ConverterUtils.convert(ConverterUtils.java:251)
	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