[ https://issues.apache.org/jira/browse/IGNITE-22204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17851993#comment-17851993 ]
Maksim Zhuravkov commented on IGNITE-22204: ------------------------------------------- The previous issue was moved to https://issues.apache.org/jira/browse/IGNITE-22392. > Sql. Set operation. Incorrect query transformation for a query with limit / > offset and sort > ------------------------------------------------------------------------------------------- > > Key: IGNITE-22204 > URL: https://issues.apache.org/jira/browse/IGNITE-22204 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 3.0.0-beta2 > Reporter: Maksim Zhuravkov > Assignee: Maksim Zhuravkov > Priority: Critical > Labels: ignite-3 > Time Spent: 10m > Remaining Estimate: 0h > > Query > {code:java} > SELECT a FROM > (SELECT a FROM > (SELECT a FROM test ORDER BY a LIMIT 3 OFFSET 2) i(a) > ORDER BY a OFFSET 1 > ) t(a) > {code} > Should be transformed into > {code:java} > Limit(offset=[1]), id = 201 > Limit(offset=[2], fetch=[3]), id = 200 > Exchange(distribution=[single]), id = 199 > Sort(sort0=[$0], dir0=[ASC], offset=[2], fetch=[3]), id = 198 > TableScan(table=[[PUBLIC, TEST]], requiredColumns=[{0}]), id = 168 > {code} > But it gets rewritten as > {code:java} > Limit(offset=[1]), id = 201 > Limit(offset=[2], fetch=[3]), id = 200 > Exchange(distribution=[single]), id = 199 > Sort(sort0=[$0], dir0=[ASC], offset=[1], fetch=[1]), id = 198 > TableScan(table=[[PUBLIC, TEST]], requiredColumns=[{0}]), id = 168 > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)