[DBIx-Class-Devel] OffsetFetchNext Support for SQL Server 2012

[Alexander Hartmaier]

T24gRnJpLCBKdWwgMTksIDIwMTMgYXQgOToxNyBQTSwgZlJFVyBTY2htaWR0IDxmcmlvdXhAZ21h
aWwuY29tPiB3cm90ZToKCj4gSSBqdXN0IHB1c2hlZCBhIHRvdGFsbHkgd29ya2luZyB2ZXJzaW9u
IG9mIE9mZnNldEZldGNoTmV4dC4gIE9GTiBpcwo+IHRoZSBuZXcgcGFnaW5hdGlvbiBmb3IgU1FM
IFNlcnZlciAyMDEyIGFuZCBpdCdzIHByZXR0eSBncmVhdCBjb21wYXJlZAo+IHRvIHdoYXQgd2Ug
aGFkIGJlZm9yZS4gIFRvIGJlIGNsZWFyLCBoZXJlIGlzIHRoZSBkaWZmZXJlbmNlOgo+Cj4gICAg
LS0gQkVGT1JFCj4KPiAgICBTRUxFQ1QgW21lXS5baWRdLCBbbWVdLltmcm9tXSwgW21lXS5bdG9d
LCBbbWVdLltncm91cF9pZF0KPiAgICAgIEZST00gKAo+ICAgICAgICBTRUxFQ1QgW21lXS5baWRd
LCBbbWVdLltmcm9tXSwgW21lXS5bdG9dLCBbbWVdLltncm91cF9pZF0sCj4gIFJPV19OVU1CRVIo
KSBPVkVSICgKPiAgICAgICAgICAgIE9SREVSIEJZCj4gICAgICAgICAgICBTRUxFQ1QoIDEgKQo+
ICAgICAgICAgICApIEFTIFtybm9fX3Jvd19faW5kZXhdCj4gICAgICAgICAgRlJPTSAoCj4gICAg
ICAgICAgICBTRUxFQ1QgW21lXS5baWRdLCBbbWVdLltmcm9tXSwgW21lXS5bdG9dLCBbbWVdLltn
cm91cF9pZF0KPiAgICAgICAgICAgICAgRlJPTSBbTG9va3VwXSBbbWVdCj4gICAgICAgICAgICkg
W21lXQo+ICAgICAgICkgW21lXQo+ICAgIFdIRVJFIFtybm9fX3Jvd19faW5kZXhdID49ICcxJyBB
TkQgW3Jub19fcm93X19pbmRleF0gPD0gJzI1Jwo+Cj4KPiAgICAtLSBBRlRFUgo+Cj4gICAgU0VM
RUNUIFttZV0uW2lkXSwgW21lXS5bZnJvbV0sIFttZV0uW3RvXSwgW21lXS5bZ3JvdXBfaWRdCj4g
ICAgICBGUk9NIFtMb29rdXBdIFttZV0KPiAgICBPUkRFUiBCWSAxCj4gICAgT0ZGU0VUIDAgUk9X
UyBGRVRDSCBORVhUIDI1IFJPV1MgT05MWQo+Cj4gU1FMIFNlcnZlciBjbGFpbXMgdGhhdCB0aGUg
Zm9ybWVyIGNvc3RzIDglIG1vcmUgdGhhbiB0aGUgbGF0dGVyLCBzbwo+IHRoYXQncyBhIHByZXR0
eSBuaWNlIHdpbiB0b28uICBBbHNvLCBhcyByaWJhIHBvaW50ZWQgb3V0IHRvIG1lLCB3aXRoCj4g
dGhlIGxhdHRlciB3ZSB3aWxsIGFsd2F5cyBiZSBnZW5lcmF0aW5nIHRoZSBzYW1lIGtpbmQgb2Yg
cXVlcnkgd2hldGhlcgo+IG9yIG5vdCB3ZSBoYXZlIGFuIG9mZnNldCwgc28gcXVlcmllcyBzaG91
bGQgYmUgY2FjaGVkIGJldHRlci4KPgpJJ3ZlIG5ldmVyIHdvcmtlZCB3aXRoIE1TU1FMIGJ1dCB0
aGUgc2ltcGxpZmllZCBTUUwgaXMgZGVmaW5pdGVseSBhbmQKaW1wcm92ZW1lbnQsIGFsc28gZm9y
IGRlYnVnZ2luZyBiZWNhdXNlIGl0J3MgbW9yZSBjb25jaXNlLgoKCj4gVGhlIGNvbW1pdHMgYXJl
IHZpZXdhYmxlIGF0Cj4KPiBodHRwczovL2dpdGh1Yi5jb20vZGJzcmdpdHMvZGJpeC1jbGFzcy9j
b21taXRzL3RvcGljL21zc3FsLTIwMTItbGltaXQtZGlhbGVjdAo+Cj4gSSB0aGluayAibW9yZSBm
aW5lIGdyYWluZWQgdmVyc2lvbmluZyIgc2hvdWxkIGJlIHNxdWFzaGVkIGludG8KPiAicmVmYWN0
b3IgY29kZSBuZWVkaW5nIHZlcnNpb24iLCBidXQgd2FudGVkIHRvIG1ha2Ugc3VyZSB0aGF0IG1h
ZGUKPiBzZW5zZSB0byBvdGhlcnMgZmlyc3QuCj4KOTU2YzAzZTI3MSBzZWVtcyB0byBoYXZlIGEg
dHlwbzogIk9mZnNldEZldGNoICpyZXF1aXJlcyogYW4KT1JERVIgQlkgY2xhdXNlIiwgbm90IGFu
ZC4KRm9yIG1lIGl0IG1ha2VzIHNlbnNlIHRvIHNlZSBpbiB2ZXJzaW9uIGNvbnRyb2wgd2hhdCBs
ZWFkIHRvIGEgcGllY2Ugb2YKY29kZSwgYnV0IHJpYmEgbGlrZXMgc3F1YXNoaW5nIG11bHRpcGxl
IGNvbW1pdHMgaW50byBhIHNpbmdsZSBjb21taXQuCgoKPgo+IFRoZSByZWFsIHF1ZXN0aW9uIGlz
IHdoYXQgdGhlIHJpZ2h0IHNvbG4gaXMgZm9yICJTdGVhbCBiaW5kdHlwZQo+IHRyYW5zZm9ybXMg
ZnJvbSBTUUxpdGUiLiAgRm9yIHNvbWUgcmVhc29uIFNRTCBTZXJ2ZXIgaXMgbXVjaCBtb3JlCj4g
cGlja3kgd3J0IGJpbmQgdHlwZXMgaW4gdGhlIG5ldyBwYWdpbmF0aW9uLCBzbyBJIGhhZCB0byBh
ZGQgdGhhdCBpbi4KPiBJIHN1c3BlY3QgdGhhdCB3ZSBtYXkgbmVlZCB0byBtYWtlIGEgYmV0dGVy
IHJlZ2V4IGZvciBJTlRFR0VScyBmb3IgU1FMCj4gU2VydmVyLCBlZyB3ZSBzaG91bGQgYWRkIGJp
dHMgYWxyZWFkeS4gIFdhbnRlZCB0byBnZXQgc29tZSB0aG91Z2h0cwo+IHRoZXJlLgo+Ckl0IHNl
ZW1zIHlvdSBhbHJlYWR5IGZvdW5kIGEgc29sdXRpb24gZm9yIHRoZSBiaW5kIHR5cGVzIGluIGNv
bW1pdAo4MWVjYzBiYzk0LgoKCj4KPiBMYXN0bHksIHdydCB0aGUgYWN0dWFsIGltcGxlbWVudGF0
aW9uLCB0aGUgb25seSBraW5kYSBncm9zcyB0aGluZyBpbgo+IG15IG1pbmQgaXMgdGhlIGhhcmRj
b2RlZCBcJzEnIGFuZCAnIE9SREVSIEJZIDEnLiAgSSdtIG9wZW4gdG8gYmV0dGVyCj4gc29sdXRp
b25zLgo+CkltaG8gcGFnaW5nIHdpdGhvdXQgYSBkZWZpbmVkIG9yZGVyIG1ha2VzIG5vdCBhIGxv
dCBvZiBzZW5zZSBiZWNhdXNlIHRoZQpyZXR1cm5lZCByZXN1bHRzZXQgaXMgdW5zdGFibGUgYW5k
IHRoZSBzYW1lIHJvd3MgbWlnaHQgYmUgaW5jbHVkZWQgaW4KbXVsdGlwbGUgcGFnZXMuCkkgaGFk
IHN1Y2ggYSBwcm9ibGVtIHdpdGggdGhlIE9yYWNsZSBwYWdpbmF0aW9uIHR3byB5ZWFycyBhZ286
Cmh0dHBzOi8vZ2l0aHViLmNvbS9kYnNyZ2l0cy9kYml4LWNsYXNzL2NvbW1pdC82YTYzOTRmMTlm
MzFkYmM0NGNiNTM4MmQyNDE4OTA1NTVlOGNlYmQ1CgpTaG91bGRuJ3QgREJJQyB3YXJuKG9yIGV2
ZW4gZGllPykgaWYgcGFnaW5hdGlvbiBvZiBhIG5vbi1vcmRlcmVkIHJlc3VsdHNldAp3YXMgcmVx
dWVzdGVkPwoKSXQgbWlnaHQgbWFrZSBzZW5zZSB0byBoYXZlIGEgbWV0aG9kLCB0aGF0IGFkZHMg
c3VjaCBhbiBvcmRlciBieSB0bwpyZXN1bHRzZXRzLCB3aGljaCBjb3VsZCBiZSB1c2VkIGJ5IG1l
dGhvZHMgbGlrZSBfT2Zmc2V0RmV0Y2hOZXh0IHRvIGVuc3VyZQp0aGF0IHRoZSByZXN1bHRzZXQg
aGFzIG9uZS4KRWFjaCBTUUxNYWtlciBjb3VsZCBvdmVycmlkZSB0aGUgbWV0aG9kIGlmIHRoZSBz
dGFuZGFyZCB3YXkgZG9lc24ndCB3b3JrIG9uCnRoZSBSREJNUy4KLS0tLS0tLS0tLS0tLS0gbmV4
dCBwYXJ0IC0tLS0tLS0tLS0tLS0tCkFuIEhUTUwgYXR0YWNobWVudCB3YXMgc2NydWJiZWQuLi4K
VVJMOiBodHRwOi8vbGlzdHMuc2NzeXMuY28udWsvcGlwZXJtYWlsL2RiaXgtY2xhc3MtZGV2ZWwv
YXR0YWNobWVudHMvMjAxMzA3MjEvMmZkOWI1YWEvYXR0YWNobWVudC5odG0K