[CALCITE-6227] ELEMENT(NULL) causes an assertion failure

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Mihai Budiu
• Created: 25/Jan/24 22:27
• Updated: 06/May/24 22:19
• Resolved: 26/Jan/24 17:22

Description

Adding the following test to SqlValidatorTest:

@Test void testElement() {
    expr("element(null)").columnType("null");
}

causes an assertion failure. The bottom of the stack trace is the following:

	at org.apache.calcite.sql.type.ReturnTypes$2.get(ReturnTypes.java:577)
	at org.apache.calcite.sql.type.ReturnTypes$2.get(ReturnTypes.java:571)
	at org.apache.calcite.sql.ExplicitOperatorBinding.getOperandType(ExplicitOperatorBinding.java:78)
	at org.apache.calcite.sql.SqlOperatorBinding$1.get(SqlOperatorBinding.java:255)
	at org.apache.calcite.sql.SqlOperatorBinding$1.get(SqlOperatorBinding.java:253)
	at org.apache.calcite.sql.type.SqlTypeFactoryImpl.leastRestrictive(SqlTypeFactoryImpl.java:174)
	at org.apache.calcite.rel.type.RelDataTypeFactory.leastRestrictive(RelDataTypeFactory.java:222)
	at org.apache.calcite.sql.type.ReturnTypes.lambda$static$3(ReturnTypes.java:537)
	at org.apache.calcite.sql.type.ReturnTypes.lambda$static$6(ReturnTypes.java:586)
	at org.apache.calcite.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:58)
	at org.apache.calcite.sql.SqlOperator.inferReturnType(SqlOperator.java:534)

Issue Links

• links to: GitHub Pull Request #3652