[
https://issues.apache.org/jira/browse/IGNITE-25531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-25531:
-----------------------------------------
Assignee: Konstantin Orlov
> Sql. Remove Limit if there is Sort with fetch
> ---------------------------------------------
>
> Key: IGNITE-25531
> URL: https://issues.apache.org/jira/browse/IGNITE-25531
> Project: Ignite
> Issue Type: Improvement
> Components: sql ai3
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> Take a look at example below:
> {code}
> SELECT *
> FROM (SELECT x AS c1, x::varchar AS c2 FROM system_range(1, 10))
> ORDER BY c1, c2
> FETCH FIRST 5 ROWS ONLY;
> ----
> Limit
> fetch: 5
> est: (rows=5)
> Sort
> collation: [C1 ASC, C2 ASC]
> fetch: 5
> est: (rows=5)
> Project
> fieldNames: [C1, C2]
> projection: [X, CAST(X):VARCHAR CHARACTER SET "UTF-8" NOT NULL]
> est: (rows=100)
> TableFunctionScan
> fieldNames: [X]
> invocation: SYSTEM_RANGE(1, 10)
> est: (rows=100)
> {code}
> Looks like we could remove Limit node on top because Sort incorporates the
> same limit.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
