bun icon indicating copy to clipboard operation
bun copied to clipboard

fix: allow Limit() without Order() with MSSQL

Open CL-Jeremy opened this issue 7 months ago • 0 comments

Implements workaround from https://stackoverflow.com/a/36156953 for all backends supporting feature.OffsetFetch from ISO/ANSI SQL:2008, which specifies ORDER BY as a requirement. This should be tested further if more backends are to be added (such as Oracle in #995 – this feature is not enable there, and there seems to be an impact noted by https://stackoverflow.com/q/48620590 and https://stackoverflow.com/q/59864964).

Closes #811

CL-Jeremy avatar Jul 16 '24 08:07 CL-Jeremy