[CAY-2587] SQLServer Limit Offset convertation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.M1
• Fix Version/s: 4.2.M3
• Component/s: Core Library
• Assignee: Nikita Timofeev
• Reporter: Konstantin
• Created: 24/Jun/19 14:16
• Updated: 25/Feb/21 12:22
• Resolved: 25/Feb/21 12:22

Description

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;