[IGNITE-23141] Sql. Add execution test to verify numeric type coercion in binary comparison and arithmetic

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Iurii Gerzhedovich
• Created: 04/Sep/24 10:14
• Updated: 08/Oct/24 07:41
• Resolved: 08/Oct/24 07:41

Description

We already have coercion planner test for binary comparison and arithmetic.
Let's add tests for the same operations but for execution and check have we the same casts or not.

See NumericComparisonTypeCoercionTest and NumericBinaryOperationsTypeCoercionTest

Issue Links

• Dependency: IGNITE-23192 Sql. Arithmetic operations failed with "out of range" exception.
• is related to: IGNITE-19997 Sql. Enhancing test coverage of type coercion
• links to: GitHub Pull Request #4382