[CALCITE-6095] Arithmetic expression with VARBINARY value causes AssertionFailure

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Mihai Budiu
• Created: 07/Nov/23 23:28
• Updated: 06/May/24 22:19
• Resolved: 09/Jan/24 00:28

Description

The following SqlOperatorTest causes an AssertionFailure:

f.check("SELECT x'31' + 0", "INTEGER NOT NULL", "50");

The top of the stack trace is:

	at org.apache.calcite.sql.validate.implicit.AbstractTypeCoercion.needToCast(AbstractTypeCoercion.java:297)
	at org.apache.calcite.sql.validate.implicit.AbstractTypeCoercion.coerceOperandType(AbstractTypeCoercion.java:117)
	at org.apache.calcite.sql.validate.implicit.TypeCoercionImpl.binaryArithmeticWithStrings(TypeCoercionImpl.java:200)
	at org.apache.calcite.sql.validate.implicit.TypeCoercionImpl.binaryArithmeticCoercion(TypeCoercionImpl.java:172)
	at org.apache.calcite.sql.type.CompositeOperandTypeChecker.checkOperandTypes(CompositeOperandTypeChecker.java:261)
	at org.apache.calcite.sql.SqlOperator.checkOperandTypes(SqlOperator.java:761)
	at org.apache.calcite.sql.SqlOperator.validateOperands(SqlOperator.java:498)
	at org.apache.calcite.sql.SqlOperator.deriveType(SqlOperator.java:607)
	at org.apache.calcite.sql.SqlBinaryOperator.deriveType(SqlBinaryOperator.java:178)

Issue Links

• links to: GitHub Pull Request #3527