You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Nikita Timofeev (Jira)" <ji...@apache.org> on 2021/02/25 12:23:00 UTC

[jira] [Closed] (CAY-2587) SQLServer Limit Offset convertation

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

Nikita Timofeev closed CAY-2587.
--------------------------------
      Assignee: Nikita Timofeev
    Resolution: Fixed

https://github.com/apache/cayenne/pull/448
and a follow-up commit https://github.com/apache/cayenne/commit/37ee115185a3234c14d7dcf1bc6afc014e7225c1

> SQLServer Limit Offset convertation 
> ------------------------------------
>
>                 Key: CAY-2587
>                 URL: https://issues.apache.org/jira/browse/CAY-2587
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 4.2.M1
>            Reporter: Konstantin
>            Assignee: Nikita Timofeev
>            Priority: Major
>             Fix For: 4.2.M3
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> Now cayenne query for SQLServer Limit/Offset converts to 'top (Limit+Offset)'.
> I think we should convert it to:
> OFFSET n ROWS
> FETCH NEXT k ROWS ONLY;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)