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

[Jorge Gonzalez]

SGkgYWxsLAoKT2J2aWF0aW5nIHRoZSB1bmNoZWVyZnVsIHJlc3BvbnNlIChJJ20gbm90IGEgaGFu
ZGljYXBwZWQgcGVyc29uOyBteSAKb3JhY2xlIHVzZXJuYW1lIGlzIGEgaGFuZGljYXBwZWQgb25l
KSwgSSdsbCBleHBsYWluIHRoZSBzaXR1YXRpb24gc28gCnRoYXQgZXZlcnlib2R5IGNhbiB1bmRl
cnN0YW5kIHdoeSBJIGNhbid0IGNyZWF0ZSB0ZW1wb3JhcnkgdGFibGVzOgoKMS4gTXkgY3VzdG9t
ZXIgaXMgYSBTTUFMTCBjb21wYW55ICg9bGl0dGxlIG5lZ290aWF0aW9uIHBvd2VyKS4KMi4gVGhl
eSBoYXZlIGFuZCBhZ3JlZW1lbnQgd2l0aCBhIEhVR0UgY29tcGFueSAoPWJpZyBwcmVzc3VyZSBw
b3dlciksIAp3aGljaCBvZmZlcnMgdG8gU01BTEwgY29tcGFueSBhIGRldGFpbGVkIGFjY2VzcyB0
byB0aGVpciBkYXRhIHdhcmVob3VzZS4gClRoaXMgaXMgdGhlIE9yYWNsZSBhY2Nlc3MgSSdtIHVz
aW5nLiBJdCdzIGEgcmVhZG9ubHkgdXNlciB3aGljaCBjYW4ndCBkbyAKYW55dGhpbmcgb24gdGhl
IERCIGV4Y2VwdCBxdWVyeSBfc29tZV8gdGFibGVzLgozLiBUaGUgU01BTEwgY29tcGFueSB3YW50
cyB0byBjcm9zcyBpbmZvcm1hdGlvbiBmcm9tIHRoZWlyIHN5c3RlbXMgCih3aGljaCB3ZSBtYW5h
Z2UgYW5kIHRvIHdoaWNoIHdlIGhhdmUgZnVsbCBhY2Nlc3MpIHdpdGggdGhlIEhVR0UgCmNvbXBh
bnkncyBkYXRhIHdhcmVob3VzZS4KNC4gVGhlIEhVR0UgY29tcGFueSBoYXMgYSBzdGF0ZWQgcG9s
aWN5IHJlZ2FyZGluZyBhY2Nlc3MgdG8gdGhlaXIgZGF0YSAKd2FyZWhvdXNlLCB3aGljaCBmb3Ji
aWRzIGNyZWF0aW5nIHRlbXBvcmFyeSB0YWJsZXMuCjUuIFRoZSBIVUdFIGNvbXBhbnkgY2FuJ3Qg
Y2hhbmdlIHRoZWlyIHBvbGljeSBlYXNpbHkgd2l0aG91dCBicmVha2luZyAKdGhlaXIgaW50ZXJu
YWwgcXVhbGl0eSBhdWRpdHMuIEFuZCB0aGV5IHdpbGwgTk9UIGNoYW5nZSBpdCBmb3IgdGhlIFNN
QUxMIApjb21wYW55LiBBbmQgdGhlcidzIE5PIHdheSBJIGNhbiBjaGFsbGVuZ2UgdGhvc2UgcXVh
bGl0eSBhdWRpdHMsIHNpbmNlIApJJ20gYW4gZXh0ZXJuYWwgcGVyc29uIGZvciB0aGVtLgo2LiBB
cyBhIGNvcm9sbGFyeSB0byB0aGUgZm9ybWVyIHBvaW50cywgaXQncyBwcmV0dHkgY2xlYXIgdGhh
dCB0aGUgREIgCnBlcm1pc3Npb25zIGFyZSBjb21wbGV0ZWx5IG91dCBvZiBteSBjb250cm9sIGFu
ZCBteSBjdXN0b21lcidzLiBUaGV5IApmdWxseSBkZXBlbmQgb24gYSB0aGlyZCBwYXJ0eSB3aGlj
aCB3b24ndCBhbGxvdyB1cyB0byBkbyBpdC4gRnVsbCBzdG9wLgoKU286CgpBLiBJIGNhbid0IGNy
ZWF0ZSB0ZW1wb3JhcnkgdGFibGVzCkIuIEkgY2FuJ3QgYXNrIHRoZSBEQkFzIHRvIGFsbG93IG1l
IHRvIGRvIGl0ICh3ZWxsIEkgY2FuLCBidXQgdGhleSdsbCAKaWdub3JlIG1lKQpDLiBJIGRvbid0
IGhhdmUgdGhlIHBvd2VyIHRvIG5lZ290aWF0ZSBhIGNoYW5nZSBpbiB0aGUgSFVHRSBjb21wYW55
J3MgCnBvbGljeS4KClJlZ2FyZGluZyB0aGUgY29tbWVudCAiSSB0aGluayBpdCdzIG5vdCBub3Jt
YWwsIHdoZW4gZGV2ZWxvcGVyIHdhbnQgLSAKYW5kIG5vdCBqdXN0IHdhbnQsIGJ1dCBoYXZlIHRv
IC0gaGF2ZSB0byB1c2UgdGVtcG9yYXJ5IHRhYmxlcywgYW5kIApjYW4ndC4gV2h5IHRoaXMgd291
bGQgYmUgbm9ybWFsPyIgLSBXZWxsLCB0aGUgY29uY2VwdCBvZiAibm9ybWFsaXR5IiBpcyAKcHJl
dHR5IGRlcGVuZGVudCBvbiBldmVyeW9uZSdzIGV4cGVyaWVuY2UuIFdoYXQgaXMgbm90IG5vcm1h
bCBmb3IgeW91IGlzIApqdXN0IG9uZSBvZiBteSBkYWlseSBzaXR1YXRpb25zLiBTb21ldGltZXMg
eW91IGNhbiBiZW5kIHRoaW5ncyBzbyB0aGF0IAp5b3UgY2FuIHdvcmsgYmV0dGVyLCBhbmQgc29t
ZSB0aW1lcyB5b3UgY2FuJ3QgYW5kIGl0J3MgeW91IHdobyBoYXMgdG8gCmJlbmQgdG8gdGhlIGNp
cmN1bXN0YW5jZXMgdG8gZ2V0IHRoZSB3b3JrIGRvbmUuCgpJIGFwb2xvZ2l6ZSBpZiBteSBsYW5n
dWFnZSBzZWVtcyBhIGJpdCBoYXJzaC4KUmVnYXJkcwpKLgoKRWwgMjIvMTAvMTEgMTM6NDksIE9s
ZWcgS29zdHl1ayBlc2NyaWJpw7M6Cj4gSGkgSm9yZ2UgYW5kIGFsbCwKPgo+IEFzIGZvciBtZSwg
b2J2aW91cyB3YXkgdG8gc29sdmUgdGhpcyAtIGl0J3MgdXNlIHRlbXBvcmFyeSB0YWJsZXMuIEJ1
dCAKPiB5b3UgY2FuJ3QuIFdoeT8gSSdtIHRvbyB0aGluayB0aGF0IGFuc3dlciB0byB0aGlzIHF1
ZXN0aW9uIGlzIG91dCBvZiAKPiBzY29wZSBvZiB0aGlzIGxpc3QuIEJ1dCB0aGlzIGlzIG1haW4g
dGhpbmcsIGFzIGZvciBtZS4KPgo+IEkgdGhpbmsgaXQncyBub3Qgbm9ybWFsLCB3aGVuIGRldmVs
b3BlciB3YW50IC0gYW5kIG5vdCBqdXN0IHdhbnQsIGJ1dCAKPiBoYXZlIHRvIC0gaGF2ZSB0byB1
c2UgdGVtcG9yYXJ5IHRhYmxlcywgYW5kIGNhbid0LiBXaHkgdGhpcyB3b3VsZCBiZSAKPiBub3Jt
YWw/IFlvdSBqdXN0IHRyeWluZyB0byB1c2Ugc29tZSB0b29sIHRvIHNvbHZlIHlvdXIgdGFzaywg
YW5kIGhhdmUgCj4gcmVzdHJpY3Rpb25zIHRvIHVzZSBpdCBpbiBmdWxsLiBUaGlzIGlzIGxpa2Ug
d2hlbiB5b3UgbmVlZCB0byB1c2UgCj4gaGFtbWVyLCBidXQgeW91IGhhdmUgcmVzdHJpY3Rpb24g
dG8gbm90IHRvdWNoIGl0IC0gdGhlbiBob3cgeW91IGNhbiAKPiB1c2UgaXQgYXQgYWxsPyBPciBs
aWtlIHlvdSBuZWVkIHRvIHdyaXRlIHNjcmlwdCBpbiBQZXJsLCBidXQgY2FuJ3QgdXNlIAo+IGhh
c2hlcywgYXJyYXlzIGFuZCByZWYncyAtIGdyZWF0IGNvbmRpdGlvbnMsIGlzbid0Pwo+Cj4gT2J2
aW91c2x5LCB5b3UgY2FuJ3QgY3JlYXRlIHRlbXBvcmFyeSB0YWJsZXMgYmVjYXVzZSB5b3UgaGF2
ZSAKPiByZXN0cmljdGlvbnMgZnJvbSB5b3VyIERCQXMuIEFuZCBvYnZpb3VzbHksIHRoZXkgbWFk
ZSBzdWNoIAo+IHJlc3RyaWN0aW9ucyB0byBhY2hlaXZlIHNvbWUgZ29hbC4gTW9zdCBwcm9iYWJs
eSwgdGhleSB0cnlpbmcgdG8gc2F2ZSAKPiBDUFUgYW5kL29yIFJBTSBvbiBkYiBzZXJ2ZXIuIFdl
bGwsIHRoYXQncyBncmVhdCBnb2FsLiBCdXQgaWYgdGhleSBzbyAKPiBzbWFydCwgdGhlbiBtYXkg
YmUgd2lsbCBiZSBiZXR0ZXIgdG8gcG93ZXIgb2ZmIGRiIHNlcnZlcj8gLSBUaGlzIHdpbGwgCj4g
c2F2ZSBsb3Qgb2YgQ1BVIGFuZCBSQU0sIG9idmlvdXNseS4gT3IgZXZlbiBiZXR0ZXIgLSB0aGVu
IGxldCB0aGVtIHRvIAo+IHNvbHZlIHlvdXIgdGFzaywgb2s/Cj4KPiBUcnkgdG8gdW5kZXJzdGFu
ZDogd2hhdCB5b3UgdHJ5aW5nIHRvIGRvIGl0J3MgbGlrZSBjcm9va2VkIG5haWwuIFlvdSAKPiBj
YW4ndCB1c2UgaXQgZm9yZXZlciBhbmQga2VlcCB0aGlua2luZyB0aGF0IGV2ZXJ5dGhpbmcgaXMg
ZmluZS4gT3IsIGlmIAo+IGl0J3MgZmluZSBmb3IgeW91LCB0aGVuIG9idmlvdXNseSB5b3UgYXJl
IGhhbmRpY2FwcGVkIHBlcnNvbi4gQW5kIGlmIAo+IGl0J3Mgc28sIHRoZW4gbm9ib2R5IGNhbid0
IGFzayB5b3UgdG8gZG8gc29tZXRoaW5nIHRoYXQgY2FuIGRvIGFueSAKPiBub24taGFuZGljYXBw
ZWQgcGVyc29uLgo+Cj4gSSdtIHNvcnJ5IGlmIEkgd2FzIHRvbyBkaXJlY3QgYW5kIG1heSBiZSBs
b29rcyBjYXJlbGVzcyBpbiB0ZXJtcy4gSSAKPiBkb24ndCB3YW50ZWQgdG8gb2ZmZW5kIGFueWJv
ZHksIGFuZCB0aGlzIGlzIG9ubHkgYmVjYXVzZSBteSBsZXZlbCBvZiAKPiBFbmdsaXNoIGtub3ds
ZWRnZS4KPgo+IEhvcGUgeW91IGNhbiByZS10aGluayB5b3VyIHNpdHVhdGlvbiBhbmQgc29sdmUg
dGhpcyBwdXp6bGUgc3VjY2Vzc2Z1bGx5Lgo+IEdvb2QgbHVjayEKPgo+Cj4KPiAyMDExLzEwLzIy
IEpvcmdlIEdvbnphbGV6IDxqb3JnZS5nb256YWxlekBkYWlrb24uZXMgCj4gPG1haWx0bzpqb3Jn
ZS5nb256YWxlekBkYWlrb24uZXM+Pgo+Cj4gICAgIEhpIGFsbCwKPgo+ICAgICBmaXJzdCBvZiBh
bGwsIEkgdGhpbmsgdGhpcyBxdWVzdGlvbiBpcyBwcm9iYWJseSBvZmZ0b3BpYyBpbiB0aGlzCj4g
ICAgIGxpc3Qgc2luY2UgaXQncyBub3QgREJJeDo6Q2xhc3Mgc3BlY2lmaWMsIGJ1dCBzaW5jZSBJ
IGRvIGFsbCBteSBEQgo+ICAgICBkZXZlbG9wbWVudCB3aXRoIERCSXg6OkNsYXNzIEknZCBsaWtl
IHRvIGFzayBoZXJlIGZpcnN0LiBUaGUKPiAgICAgcXVlc3Rpb24gaXMgcHJvYmFibHkgb2YgaW50
ZXJlc3QgZm9yIG90aGVycyBhbnl3YXkuIFRoaXMgaXMgaXQ6Cj4KPiAgICAgSSBoYXZlIHJlYWQt
b25seSBhY2Nlc3MgdG8gYW4gT3JhY2xlIHNjaGVtYS4gVGhlIHVzZXIgaXMgbGltaXRlZCwKPiAg
ICAgaXQgY2FuJ3QgY3JlYXRlIHRlbXBvcmFyeSB0YWJsZXMsIHZpZXdzLCBldGMuIEp1c3QgYWNj
ZXNzIHRvIHNvbWUKPiAgICAgdGFibGVzLgo+Cj4gICAgIEkgaGF2ZSBhIGJpZyB0YWJsZSBCSUdU
QUJMRSBpbiB0aGlzIHNjaGVtYSAofm1pbGxpb25zIG9mIHJvd3MpCj4gICAgIHdoaWNoIEkgd2Fu
dCB0byBmaWx0ZXIgYnkgdmFsdWVzIGluIGEgc3BlY2lmaWMgZmllbGQuIFRoZSBudW1iZXIKPiAg
ICAgb2YgdmFsdWVzIHRvIGZpbHRlciBpcyBhbHNvIGJpZyAofjQwLjAwMCksIGFuZCBjYW4ndCBi
ZSBvYnRhaW5lZAo+ICAgICBmcm9tIG90aGVyIHRhYmxlcywgaS5lLiBJIHRha2UgdGhlbSBvdXQg
b2YgYW5vdGhlciBkYXRhIHNvdXJjZQo+ICAgICB3aGljaCBpcyBub3QgdGhlIE9yYWNsZSBzY2hl
bWEuCj4KPiAgICAgRm9yIHRoaXMgSSB0cmllZCB0aGUgZm9sbG93aW5nIHF1ZXJ5OiBTRUxFQ1Qg
KiBGUk9NIEJJR1RBQkxFIFdIRVJFCj4gICAgIEZJRUxEIElOICguLi5+NDAuMDAwIHZhbHVlcy4u
LikuIE9yYWNsZSwgdGhvdWdoLCBoYXMgYSAxMDAwCj4gICAgIGVsZW1lbnQgbGltaXQgZm9yIElO
IGNsYXVzZXMsIHNvIEkgaGF2ZSB0byBicmVhayB0aGUgcXVlcnkgaW4gc29tZQo+ICAgICA0MCBz
bWFsbGVyIHF1ZXJpZXMgYW5kIHRoZW4gcHJvY2VzcyB0aGUgcmVzdWx0cyBhZnRlcndhcmRzIChJ
IGNhbGwKPiAgICAgdGhpcyB0aGUgInNsaWNlIHRlY2huaXF1ZSIgc2luY2UgSSBicmVhayB0aGUg
bGlzdCBpbiBzbGljZXMgd2l0aAo+ICAgICBzcGxpY2UgOi0pIEFwcGFydCBmcm9tIGhhdmluZyB0
byBkbyBOLzEwMDAgcXVlcmllcyBpbnN0ZWQgb2YgMQo+ICAgICAoYW5kIG5vdyBOIGlzIDQwLjAw
MCBidXQgaXQgd2lsbCBzdXJlbHkgZ3Jvdywgc28gbW9yZSBxdWVyaWVzKSwgSQo+ICAgICBjYW4n
dCBvZmZsb2FkIGRhdGEgcHJvY2Vzc2luZyB0byB0aGUgU1FMIHNlcnZlciAod2hpY2ggb2YgY291
cnNlCj4gICAgIHdvdWxkIGJlIGdvb2QpIGFuZCBteSBhcHAgaGFzIHRvIHByb2Nlc3MgdGhlIGRh
dGEgaXRzZWxmLgo+Cj4gICAgIE15IHF1ZXN0aW9uIGlzOiBoYXMgYW55b25lIG1hbmFnZWQgdG8g
Z2V0IHBhc3QgdGhpcyBsaW1pdGF0aW9uIGluCj4gICAgIGFueSB3YXk/Cj4KPiAgICAgT25lIGFw
cHJvYWNoIGNvdWxkIGJlIHRvIGxvYWQgc29tZSB0ZW1wb3JhcnkgdGFibGUgd2l0aCB0aGUgZmls
dGVyCj4gICAgIGRhdGEgYW5kIHRoZW4gam9pbiBCSUdUQUJMRSB3aXRoIHRoZSB0ZW1wIHRhYmxl
LCBidXQgYXMgSSBzYWlkLCBteQo+ICAgICBPcmFjbGUgdXNlciBpcyB2ZXJ5IGxpbWl0ZWQgYW5k
IGNhbid0IGNyZWF0ZSB0ZW1wb3JhcnkgdGFibGVzLAo+ICAgICBtdWNoIGxlc3MgbG9hZCB0aGVt
IHdpdGggZGF0YS4KPgo+ICAgICBJJ2QgdmVyeSBtdWNoIGFwcHJlY2lhdGUgYW55IGlkZWEgZm9y
IHNvbHZpbmcgdGhpcy4gQW5kIGFnYWluLAo+ICAgICBhY2NlcHQgbXkgYXBvbG9naWVzIGlmIHlv
dSBmZWVsIHRoaXMgcXVlc3Rpb24gaXMgdmVyeSBvZmZ0b3BpYy4KPgo+ICAgICBUaGFua3MgaW4g
YWR2YW5jZS4KPiAgICAgUmVnYXJkcwo+ICAgICBKLgo+Cj4gICAgIC0tIAo+Cj4gICAgIAkqL0pv
cmdlIEdvbnrDoWxleiBWaWxsYWxvbmdhLyoKPiAgICAgRGlyZWN0b3IgVMOpY25pY28KPgo+ICAg
ICAqL0RBSUtPTiBJbnRlZ3JhY2nDs24geSBEZXNhcnJvbGxvIFMuTC4vKgo+ICAgICBUZWxmOiAo
KzM0KSA5MSAxODggMDggMjggPHRlbDolMjglMkIzNCUyOSUyMDkxJTIwMTg4JTIwMDglMjAyOD4K
PiAgICAgRmF4OiAoKzM0KSA5MSA2MzIgNjUgNDIgPHRlbDolMjglMkIzNCUyOSUyMDkxJTIwNjMy
JTIwNjUlMjA0Mj4KPiAgICAgKnd3dy5kYWlrb24uZXMgPGh0dHA6Ly93d3cuZGFpa29uLmVzPioK
Pgo+Cj4gICAgIF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
Cj4gICAgIExpc3Q6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9jZ2ktYmluL21haWxtYW4vbGlz
dGluZm8vZGJpeC1jbGFzcwo+ICAgICBJUkM6IGlyYy5wZXJsLm9yZyNkYml4LWNsYXNzIDxodHRw
Oi8vaXJjLnBlcmwub3JnI2RiaXgtY2xhc3M+Cj4gICAgIFNWTjogaHR0cDovL2Rldi5jYXRhbHlz
dC5wZXJsLm9yZy9yZXBvcy9iYXN0L0RCSXgtQ2xhc3MvCj4gICAgIFNlYXJjaGFibGUgQXJjaGl2
ZToKPiAgICAgaHR0cDovL3d3dy5ncm9rYmFzZS5jb20vZ3JvdXAvZGJpeC1jbGFzc0BsaXN0cy5z
Y3N5cy5jby51awo+Cj4KPgo+Cj4gLS0gCj4gU2luY2VyZWx5IHlvdXJzLAo+IE9sZWcgS29zdHl1
ayAoQ1VCLVVBTklDKQo+Cj4KPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fXwo+IExpc3Q6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9jZ2ktYmluL21haWxt
YW4vbGlzdGluZm8vZGJpeC1jbGFzcwo+IElSQzogaXJjLnBlcmwub3JnI2RiaXgtY2xhc3MKPiBT
Vk46IGh0dHA6Ly9kZXYuY2F0YWx5c3QucGVybC5vcmcvcmVwb3MvYmFzdC9EQkl4LUNsYXNzLwo+
IFNlYXJjaGFibGUgQXJjaGl2ZTogaHR0cDovL3d3dy5ncm9rYmFzZS5jb20vZ3JvdXAvZGJpeC1j
bGFzc0BsaXN0cy5zY3N5cy5jby51awotLS0tLS0tLS0tLS0tLSBuZXh0IHBhcnQgLS0tLS0tLS0t
LS0tLS0KU2tpcHBlZCBjb250ZW50IG9mIHR5cGUgbXVsdGlwYXJ0L3JlbGF0ZWQ=