[IGNITE-18664] Sql. subquery with OFFSET is not supported

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 12:03
• Updated: 04/Sep/24 16:22
• Resolved: 10/Apr/23 12:09

Description

The following query is not supported

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

Expected result:

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