[IGNITE-22462] Sql. Add planner test to verify type coercion for set operations like UNION, INTERSECT and EXCEPT

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Iurii Gerzhedovich
• Created: 11/Jun/24 12:06
• Updated: 26/Jun/24 07:09
• Resolved: 21/Jun/24 08:20

Description

Let's add new tests to validate type coercion for set operations like UNION, INTERSECT and EXCEPT. 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: pr#3957