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/24 10:41:00 UTC

[jira] [Updated] (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 updated CAY-2587:
---------------------------------
    Fix Version/s: 4.2.M3

> 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
>            Priority: Major
>             Fix For: 4.2.M3
>
>          Time Spent: 10m
>  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)