[ 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)