[CALCITE-5859] Compile-time evaluation of LEFT(NULL, n) should not throw RuntimeException

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.34.0, 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 18/Jul/23 21:52
• Updated: 10/Nov/23 11:34
• Resolved: 02/Aug/23 16:24

Description

SELECT LEFT(NULL, 100)

causes this exception:

Caused by: java.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:449)
	at org.apache.calcite.linq4j.tree.Expressions.call(Expressions.java:461)
	at org.apache.calcite.adapter.enumerable.EnumUtils.convert(EnumUtils.java:396)
	at org.apache.calcite.adapter.enumerable.EnumUtils.convert(EnumUtils.java:339)

Issue Links

• links to: GitHub Pull Request #3323