[IGNITE-21949] Cover SQL T122(WITH (excluding RECURSIVE) in subquery) 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:09
• Updated: 13/May/24 09:36
• Resolved: 13/May/24 09:36

Description

We don't have at all any tests for T122(WITH (excluding RECURSIVE) in subquery) 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-15995 Calcite engine. Order by subquery containing WITH clause failed
• links to: GitHub Pull Request #3741