[IGNITE-19999] Sql. Add planner test to verify numeric type coercion in binary comparison

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Assignee: Konstantin Orlov
• Reporter: Konstantin Orlov
• Created: 18/Jul/23 13:43
• Updated: 04/Sep/24 16:10
• Resolved: 20/Jul/23 14:30

Description

Let's add new tests to validate numeric type coercion in binary comparison. The tests should be as easy as possible, every test case must answer a question "what are expected types of each operand when we compare a given numeric type pair?"

Issue Links

• is related to: IGNITE-19997 Sql. Enhancing test coverage of type coercion
• links to: GitHub Pull Request #2335