[IGNITE-15914] Sort out and merge Calcite tickets to Ignite 3.0 (step 2)

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Release Note: All mentioned tickets have been merged.
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Evgeny Stanilovsky
• Reporter: Taras Ledkov
• Created: 15/Nov/21 10:42
• Updated: 02/Feb/22 07:54
• Resolved: 02/Feb/22 07:54

Description

Let's sort out tikets contains by filter.
Tickets that could be simply merged - merge immediately. For hard cases let's create separate tickets with estimation and link them to IGNITE-15658 or links to blocker ticket.

Issue Links

• incorporates: IGNITE-16328 Sql. Correlated queries with ORDER and LIMIT can't be planned. AssertionError: Input not sorted for some ORDER BY containing requests.
• incorporates: IGNITE-16340 Sql. Request with ORDER BY plans infinitely.
• incorporates: IGNITE-16347 Sql. Support for function TYPEOF. Incorrect plan provided for queries with correlated subquery in project list.
• incorporates: IGNITE-16364 Sql. Supports regexp operators. Remove tableSpoolBroadcastNotRewindable test. Incorrect grouping reset during rewind.
• is a child of: IGNITE-15658 Merge resolve Calcite tickets to 3.0