[IGNITE-22580] Sql. Add planner test to verify numeric type coercion for CASE operator

• 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
• Epic Link: Improve SQL quality in AI3. Part1
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Evgeny Stanilovsky
• Reporter: Iurii Gerzhedovich
• Created: 26/Jun/24 07:06
• Updated: 04/Sep/24 16:08
• Resolved: 02/Aug/24 06:23

Description

Let's add new tests to validate type coercion for CASE operator. The tests should be as easy as possible, every test case must answer a question "what are expected types of each set operation when we use a given numeric type pair?"

Issue Links

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