[IGNITE-18665] Sql. subquery with ORDER BY is not supported

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Component/s: sql
• Labels: calcite2-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 12:08
• Updated: 15/Mar/24 08:49
• Resolved: 10/Apr/23 12:09

Description

The following query is not supported:

SELECT i, (WITH i2 AS (SELECT i+i1.i FROM integers ORDER BY 1 LIMIT 1 OFFSET 1) SELECT * FROM i2) AS j FROM integers i1 ORDER BY i;

i	j
1	3
2	4
3	5
null	null

Issue Links

• is duplicated by: IGNITE-18311 AssertionError in SQL on subquery with offset and limit