[Dbix-class] Regarding Oracle's 1000 element limit in IN clause

Jorge Gonzalez jorge.gonzalez at daikon.es
Mon Nov 7 14:24:15 GMT 2011


SGkgYWxsLAoKSSB0cmllZCB0aGUgYXBwcm9hY2ggbWVudGlvbmVkIGJlbG93LiBJIGhhdmUgZ29v
ZCBuZXdzIGFuZCBiYWQgbmV3cy4KClRoZSBnb29kIG9uZXMgYXJlIHRoYXQgT3JhY2xlIHNlZW1z
IHRvIGFjY2VwdCBpdCAoc2VydmVyIHZlcnNpb24gaXMgCjEwZykuIEkgZ2VuZXJhdGVkIGEgcXVl
cnkgd2l0aCBzb21lIDUwIE9SJ2VkIElOIGNsYXVzZXMsIHdpdGggfjkwMCAKZWxlbWVudHMgZWFj
aCwgZm9yIGEgdG90YWwgb2YgYXJvdW5kIDQ1MDAwIGVsZW1lbnRzLiBUaGUgU1FMIHF1ZXJ5ICh0
ZXh0IApmb3JtYXQpIHdlaWdodGVkIGFib3V0IDQwMGtCLiBCaWcsIGJ1dCBub3RoaW5nIHNlcmlv
dXMsIEkgdGhpbmsuCgpUaGUgYmFkIG5ld3MgKGZvciBtZSkgaXMgdGhhdCBPcmFjbGUgcmVqZWN0
ZWQgdGhlIHF1ZXJ5IHdpdGggYSBPUkEtMDQwMzEgCmVycm9yLCAiIHVuYWJsZSB0byBhbGxvY2F0
ZSAzOTk0NDggYnl0ZXMgb2Ygc2hhcmVkIG1lbW9yeSIsIHdoaWNoIHRlbGxzIAptZSB0aGF0IHBy
b2JhYmx5IHRoZSBEQiBhZG1pbnMgKHRob3NlIHRoYXQgd29uJ3QgYWxsb3cgbWUgdG8gdXNlIHRl
bXAgCnRhYmxlcyksIGRvbid0IGFsbG93IG1lIHRvIGNyZWF0ZSBhIDQwMGtCIHF1ZXJ5IG5laXRo
ZXIuCgpTbyBmb3IgdGhlIHNob3J0IHRlcm0sIEknbGwgaGF2ZSB0byBzdGljayB3aXRoIHRoZSA1
MCBxdWVyaWVzIGFuZCBsb2NhbCAKZmlsdGVyaW5nLiBGb3IgdGhlIGZ1dHVyZSwgbXkgY3VzdG9t
ZXIgaGFzIG5lYXJseSBhcHByb3ZlZCBhIHByb2plY3QgdG8gCm1pcnJvciB0aGUgcmVtb3RlIGRh
dGEgd2FyZWhvdXNlIGxvY2FsbHkgc28gdGhhdCB3ZSBjYW4gZG8gYW55dGhpbmcgd2UgCndhbnQg
d2l0aCBpdC4KClRoYW5rcyB0byBhbGwgd2hvIHJlcGxpZWQgYW5kIGZvciB0aGUgcHJvcG9zZWQg
aWRlYXMuCgpCZXN0IHJlZ2FyZHMKSi4KCkVsIDI0LzEwLzExIDE2OjMwLCBKb3JnZSBHb256YWxl
eiBlc2NyaWJpw7M6Cj4KPiBFbCAyNC8xMC8xMSAxNjoxNSwgQWxleGFuZGVyIEhhcnRtYWllciBl
c2NyaWJpw7M6Cj4+IFdoeSBkb24ndCB5b3UgdXNlIHRoZSBjb2x1bW4gSU4gKC4uLikgT1IgY29s
dW1uIElOICguLi4pIHNvbHV0aW9uPwo+PiBJJ2QgbGlrZSB0byBzZWUgdGhpcyBhcyBhIHBhdGNo
IGZvciB0aGUgT3JhY2xlIFNRTE1ha2VyLgo+Pgo+PiBDaGVlcnMsIEFsZXgKPj4KPgo+IEkgaGF2
ZSBpdCBvbiBteSAodXJnZW50KSBUTy1ETyBsaXN0LiBQcm9taXNlIEknbGwgY2hlY2sgYmFjayB3
aXRoIHRoZSAKPiByZXN1bHRzLiBIb25lc3QgOi0pCj4KPiBCUgo+IEouCj4KPgo+IF9fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gTGlzdDogaHR0cDovL2xp
c3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9kYml4LWNsYXNzCj4gSVJD
OiBpcmMucGVybC5vcmcjZGJpeC1jbGFzcwo+IFNWTjogaHR0cDovL2Rldi5jYXRhbHlzdC5wZXJs
Lm9yZy9yZXBvcy9iYXN0L0RCSXgtQ2xhc3MvCj4gU2VhcmNoYWJsZSBBcmNoaXZlOiAKPiBodHRw
Oi8vd3d3Lmdyb2tiYXNlLmNvbS9ncm91cC9kYml4LWNsYXNzQGxpc3RzLnNjc3lzLmNvLnVrCi0t
LS0tLS0tLS0tLS0tIG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQg
d2FzIHNjcnViYmVkLi4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL3BpcGVybWFpbC9k
Yml4LWNsYXNzL2F0dGFjaG1lbnRzLzIwMTExMTA3LzBiZGNlOTcyL2F0dGFjaG1lbnQuaHRtCg==


More information about the DBIx-Class mailing list