[jira] [Updated] (IGNITE-22204) Sql. Sort operator cannot use offset parameter

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-22204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Zhuravkov updated IGNITE-22204:
--------------------------------------
    Summary: Sql. Sort operator cannot use offset parameter  (was: Sql. Sort operator can not use offset parameter)

> Sql. Sort operator cannot use offset parameter
> ----------------------------------------------
>
>                 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
>
> Patch IGNITE-16013 for AI-2 can not be applied for AI-3, because that patch assumes that its inputs always returns data from a single source 
> Which is not correct, because fetch parameter is applied incorrectly when query splits into multiple fragments.
> So
> {noformat}
> Sort(ordering=ord, offset=o, fetch=f) 
> >Scan
> {noformat}
> into 
> {noformat}
> Limit (offset=o, fetch=f) 
> >Sort(ordering=ord, offset=o, fetch=f)
> >>Scan
> {noformat}
> Is not applicable.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)