[Sqlalchemy-tickets] =?utf-8?b?W3NxbGFsY2hlbXldICMzNjk6IGpvaW4s?= =?utf-8?q?_sorting_and_limit/offs
Brought to you by:
zzzeek
Menu
▾
▴
[Sqlalchemy-tickets] =?utf-8?b?W3NxbGFsY2hlbXldICMzNjk6IGpvaW4s?= =?utf-8?q?_sorting_and_limit/offset_issue?=
|
From: sqlalchemy <mi...@zz...> - 2006-11-15 14:27:05
|
IzM2OTogam9pbiwgc29ydGluZyBhbmQgbGltaXQvb2Zmc2V0IGlzc3VlDQotLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogUmVwb3J0ZXI6ICBkenVpa292QGdtYWlsLmNvbSAgICAgIHwgICAgICAgT3duZXI6 ICB6enplZWsgICAgICAgICAgICAgICAgDQogICAgIFR5cGU6ICBkZWZlY3QgICAgICAgICAgICAg ICAgIHwgICAgICBTdGF0dXM6ICBuZXcgICAgICAgICAgICAgICAgICAgDQogUHJpb3JpdHk6ICBo aWdoICAgICAgICAgICAgICAgICAgIHwgICBNaWxlc3RvbmU6ICAwLjMuMCAgICAgICAgICAgICAg ICAgDQpDb21wb25lbnQ6ICBvcm0gICAgICAgICAgICAgICAgICAgIHwgICAgU2V2ZXJpdHk6ICBu byB0cmlhZ2Ugc2VsZWN0ZWQgeWV0DQogS2V5d29yZHM6ICBqb2luIGFzYyBsaW1pdCBvZmZzZXQg IHwgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KVGhlcmUgaXMgYSB2ZXJ5IHN0cmFuZ2UgYmVoYXZp b3Igd2l0aCB0YWJsZSBqb2lucyBhbmQgbGltaXQvb2Zmc2V0Og0KIGV4YW1wbGU6DQoNCiB7e3sN CiBmcm9tIHNxbGFsY2hlbXkgaW1wb3J0ICoNCg0KIGRiID0gY3JlYXRlX2VuZ2luZSgibXlzcWw6 Ly90ZXp6dDp0ZXp6dEBsb2NhbGhvc3QvdGV6enQiKQ0KIG0gPSBCb3VuZE1ldGFEYXRhKGRiKQ0K IGRiLmVuZ2luZS5lY2hvID0gVHJ1ZQ0KDQogY2xhc3MgVDEob2JqZWN0KTpwYXNzDQogY2xhc3Mg VDIob2JqZWN0KTpwYXNzDQoNCg0KIHQxID0gVGFibGUoImEiLCBtLCBDb2x1bW4oImlkIiwgSW50 ZWdlciwgcHJpbWFyeV9rZXk9VHJ1ZSksIENvbHVtbigiYl9pZCIsDQogSW50ZWdlciwgRm9yZWln bktleSgiYi5pZCIpKSkNCiB0MiA9IFRhYmxlKCJiIiwgbSwgQ29sdW1uKCJpZCIsIEludGVnZXIs IHByaW1hcnlfa2V5PVRydWUpLCBDb2x1bW4oIm5hbWUiLA0KIFN0cmluZygxMCkpKQ0KDQogVDEu bWFwcGVyID0gbWFwcGVyKFQxLCB0MSwgcHJvcGVydGllcz17ImIiOnJlbGF0aW9uKFQyLCBsYXp5 PUZhbHNlLA0KIG9yZGVyX2J5PU5vbmUpfSkNCiBUMi5tYXBwZXIgPSBtYXBwZXIoVDIsIHQyKQ0K DQogbS5kcm9wX2FsbCgpDQogbS5jcmVhdGVfYWxsKCkNCg0KDQogc2Vzc2lvbiA9IGNyZWF0ZV9z ZXNzaW9uKCkNCg0KIGZvciBhIGluIHhyYW5nZSgxLDEwKToNCiAgICAgYWEgPSBUMSgpDQogICAg IGJiID0gVDIoKQ0KICAgICBiYi5uYW1lID0gIkIlZCIlYQ0KICAgICBhYS5iID0gYmINCiAgICAg c2Vzc2lvbi5zYXZlKGFhKQ0KICAgICBzZXNzaW9uLnNhdmUoYmIpDQoNCiBzZXNzaW9uLmZsdXNo KCkNCiBzZXNzaW9uLmNsZWFyKCkNCg0KIGZvciBhIGluIHNlc3Npb24ucXVlcnkoVDEpLnNlbGVj dChvcmRlcl9ieT1bVDIuYy5uYW1lXSwgbGltaXQ9MTAsDQogb2Zmc2V0PTApOg0KICAgICBwcmlu dCBhLmlkLCBhLmIubmFtZQ0KDQoNCiBmb3IgYSBpbiBzZXNzaW9uLnF1ZXJ5KFQxKS5zZWxlY3Qo b3JkZXJfYnk9W2FzYyhUMi5jLm5hbWUpXSwgbGltaXQ9MTAsDQogb2Zmc2V0PTApOg0KICAgICBw cmludCBhLmlkLCBhLmIubmFtZQ0KIH19fQ0KDQogcmVzdWx0czoNCg0KIHt7ew0KIDIwMDYtMTEt MTUgMTc6MjA6MjYsNDUwIElORk8gc3FsYWxjaGVteS5lbmdpbmUuYmFzZS5FbmdpbmUuMHguLmQ0 IFNFTEVDVA0KIGJfMWIyOS5pZCBBUyBiXzFiMjlfaWQsIGJfMWIyOS5uYW1lIEFTIGJfMWIyOV9u YW1lLCBhLmlkIEFTIGFfaWQsIGEuYl9pZA0KIEFTIGFfYl9pZA0KIEZST00gKFNFTEVDVCBhLmlk IEFTIGFfaWQsIGIubmFtZSBBUyBiX25hbWUNCiBGUk9NIGEsIGIgT1JERVIgQlkgYi5uYW1lDQog IExJTUlUIDEwIE9GRlNFVCAwKSBBUyB0Ymxfcm93X2NvdW50LCBhIExFRlQgT1VURVIgSk9JTiBi IEFTIGJfMWIyOSBPTg0KIGJfMWIyOS5pZCA9IGEuYl9pZA0KIFdIRVJFIGEuaWQgPSB0Ymxfcm93 X2NvdW50LmFfaWQgT1JERVIgQlkgYl8xYjI5Lm5hbWUNCiAyMDA2LTExLTE1IDE3OjIwOjI2LDQ1 MiBJTkZPIHNxbGFsY2hlbXkuZW5naW5lLmJhc2UuRW5naW5lLjB4Li5kNCBbXQ0KIDEgQjENCiAy IEIyDQogMyBCMw0KIDQgQjQNCiA1IEI1DQogNiBCNg0KIDcgQjcNCiA4IEI4DQogOSBCOQ0KIDIw MDYtMTEtMTUgMTc6MjA6MjYsNTEyIElORk8gc3FsYWxjaGVteS5lbmdpbmUuYmFzZS5FbmdpbmUu MHguLmQ0IFNFTEVDVA0KIGJfMWIyOS5pZCBBUyBiXzFiMjlfaWQsIGJfMWIyOS5uYW1lIEFTIGJf MWIyOV9uYW1lLCBhLmlkIEFTIGFfaWQsIGEuYl9pZA0KIEFTIGFfYl9pZA0KIEZST00gKFNFTEVD VCBhLmlkIEFTIGFfaWQsIGIubmFtZSBBUyBiX25hbWUNCiBGUk9NIGEsIGIgT1JERVIgQlkgYi5u YW1lIEFTQw0KICBMSU1JVCAxMCBPRkZTRVQgMCkgQVMgdGJsX3Jvd19jb3VudCwgYSBMRUZUIE9V VEVSIEpPSU4gYiBBUyBiXzFiMjkgT04NCiBiXzFiMjkuaWQgPSBhLmJfaWQNCiBXSEVSRSBhLmlk ID0gdGJsX3Jvd19jb3VudC5hX2lkIE9SREVSIEJZIHRibF9yb3dfY291bnQuYl9uYW1lIEFTQw0K IDIwMDYtMTEtMTUgMTc6MjA6MjYsNTE0IElORk8gc3FsYWxjaGVteS5lbmdpbmUuYmFzZS5Fbmdp bmUuMHguLmQ0IFtdDQogMyBCMw0KIDYgQjYNCiA5IEI5DQogMiBCMg0KIDUgQjUNCiA4IEI4DQog MSBCMQ0KIDQgQjQNCiA3IEI3DQogfX19DQoNCiBJIGhhdmUgZXhwZWN0ZWQgdG8gc2VlIHNhbWUg cmVzdWx0cyBpbiB0aGUgYm90aCBjYXNlcy4NCg0KLS0gDQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3 dy5zcWxhbGNoZW15Lm9yZy90cmFjL3RpY2tldC8zNjk+DQpzcWxhbGNoZW15IDxodHRwOi8vZXhh bXBsZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0 |