[IGNITE-21946] Cover SQL F863(Nested <result offset clause> 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: Maksim Zhuravkov
• Reporter: Iurii Gerzhedovich
• Created: 03/Apr/24 13:07
• Updated: 14/May/24 15:30
• Resolved: 14/May/24 15:29

Description

We don't have at all any tests for F863(Nested <result offset clause> 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

• Testing discovered: IGNITE-22204 Sql. Set operation. Incorrect query transformation for a query with limit / offset and sort
• links to: GitHub Pull Request #3732