[IGNITE-18557] Sql. AbstractTypeCoercion needToCast may raise an AssertionError.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Fix Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 16/Jan/23 09:28
• Updated: 30/Apr/24 07:27
• Resolved: 30/Apr/24 07:27

Description

Some combinations of data types may cause AbstractTypeCoercion to raise an AssertionError. See TypeCoercionTest testNumericToDate.

Caused by: java.lang.AssertionError
    at org.apache.calcite.sql.validate.implicit.AbstractTypeCoercion.needToCast(AbstractTypeCoercion.java:274)
    at org.apache.ignite.internal.sql.engine.prepare.IgniteTypeCoercion.needToCast(IgniteTypeCoercion.java:123)
    at org.apache.ignite.internal.sql.engine.prepare.IgniteTypeCoercion.coerceOperandType(IgniteTypeCoercion.java:145)
    at org.apache.ignite.internal.sql.engine.prepare.IgniteTypeCoercion.binaryComparisonCoercion(IgniteTypeCoercion.java:88)
    at org.apache.calcite.sql.type.ComparableOperandTypeChecker.checkOperandTypes(ComparableOperandTypeChecker.java:70) 

AbstractTypeCoercion::needToCast:

at org.apache.calcite.sql.validate.implicit.AbstractTypeCoercion.needToCast(AbstractTypeCoercion.java:274)
// Should keep sync with rules in SqlTypeCoercionRule.
assert SqlTypeUtil.canCastFrom(toType, fromType, true);