[IGNITE-21947] Cover SQL T121(WITH (excluding RECURSIVE) in query expression) feature by tests

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Epic Link: SQL Features tests. Phase 1
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Iurii Gerzhedovich
• Created: 03/Apr/24 13:08
• Updated: 13/May/24 06:29
• Resolved: 13/May/24 05:43

Description

We don't have at all any tests for T121(WITH (excluding RECURSIVE) in query expression) SQL feature.
Let's cover it and create tickets to fix them in case find any issues related to the covered area

Issue Links

• Discovered while testing: IGNITE-22200 Sql. Error in case combine CTE and SET operation
• Discovered while testing: IGNITE-22199 Sql. No validation for duplicates of CTE aliases
• links to: GitHub Pull Request #3730