[Dbix-class] Regarding Oracle's 1000 element limit in IN clause
Jorge Gonzalez
jorge.gonzalez at daikon.es
Sat Oct 22 10:36:18 GMT 2011
SGkgYWxsLAoKZmlyc3Qgb2YgYWxsLCBJIHRoaW5rIHRoaXMgcXVlc3Rpb24gaXMgcHJvYmFibHkg
b2ZmdG9waWMgaW4gdGhpcyBsaXN0IApzaW5jZSBpdCdzIG5vdCBEQkl4OjpDbGFzcyBzcGVjaWZp
YywgYnV0IHNpbmNlIEkgZG8gYWxsIG15IERCIApkZXZlbG9wbWVudCB3aXRoIERCSXg6OkNsYXNz
IEknZCBsaWtlIHRvIGFzayBoZXJlIGZpcnN0LiBUaGUgcXVlc3Rpb24gaXMgCnByb2JhYmx5IG9m
IGludGVyZXN0IGZvciBvdGhlcnMgYW55d2F5LiBUaGlzIGlzIGl0OgoKSSBoYXZlIHJlYWQtb25s
eSBhY2Nlc3MgdG8gYW4gT3JhY2xlIHNjaGVtYS4gVGhlIHVzZXIgaXMgbGltaXRlZCwgaXQgCmNh
bid0IGNyZWF0ZSB0ZW1wb3JhcnkgdGFibGVzLCB2aWV3cywgZXRjLiBKdXN0IGFjY2VzcyB0byBz
b21lIHRhYmxlcy4KCkkgaGF2ZSBhIGJpZyB0YWJsZSBCSUdUQUJMRSBpbiB0aGlzIHNjaGVtYSAo
fm1pbGxpb25zIG9mIHJvd3MpIHdoaWNoIEkgCndhbnQgdG8gZmlsdGVyIGJ5IHZhbHVlcyBpbiBh
IHNwZWNpZmljIGZpZWxkLiBUaGUgbnVtYmVyIG9mIHZhbHVlcyB0byAKZmlsdGVyIGlzIGFsc28g
YmlnICh+NDAuMDAwKSwgYW5kIGNhbid0IGJlIG9idGFpbmVkIGZyb20gb3RoZXIgdGFibGVzLCAK
aS5lLiBJIHRha2UgdGhlbSBvdXQgb2YgYW5vdGhlciBkYXRhIHNvdXJjZSB3aGljaCBpcyBub3Qg
dGhlIE9yYWNsZSBzY2hlbWEuCgpGb3IgdGhpcyBJIHRyaWVkIHRoZSBmb2xsb3dpbmcgcXVlcnk6
IFNFTEVDVCAqIEZST00gQklHVEFCTEUgV0hFUkUgRklFTEQgCklOICguLi5+NDAuMDAwIHZhbHVl
cy4uLikuIE9yYWNsZSwgdGhvdWdoLCBoYXMgYSAxMDAwIGVsZW1lbnQgbGltaXQgZm9yIApJTiBj
bGF1c2VzLCBzbyBJIGhhdmUgdG8gYnJlYWsgdGhlIHF1ZXJ5IGluIHNvbWUgNDAgc21hbGxlciBx
dWVyaWVzIGFuZCAKdGhlbiBwcm9jZXNzIHRoZSByZXN1bHRzIGFmdGVyd2FyZHMgKEkgY2FsbCB0
aGlzIHRoZSAic2xpY2UgdGVjaG5pcXVlIiAKc2luY2UgSSBicmVhayB0aGUgbGlzdCBpbiBzbGlj
ZXMgd2l0aCBzcGxpY2UgOi0pIEFwcGFydCBmcm9tIGhhdmluZyB0byAKZG8gTi8xMDAwIHF1ZXJp
ZXMgaW5zdGVkIG9mIDEgKGFuZCBub3cgTiBpcyA0MC4wMDAgYnV0IGl0IHdpbGwgc3VyZWx5IApn
cm93LCBzbyBtb3JlIHF1ZXJpZXMpLCBJIGNhbid0IG9mZmxvYWQgZGF0YSBwcm9jZXNzaW5nIHRv
IHRoZSBTUUwgCnNlcnZlciAod2hpY2ggb2YgY291cnNlIHdvdWxkIGJlIGdvb2QpIGFuZCBteSBh
cHAgaGFzIHRvIHByb2Nlc3MgdGhlIApkYXRhIGl0c2VsZi4KCk15IHF1ZXN0aW9uIGlzOiBoYXMg
YW55b25lIG1hbmFnZWQgdG8gZ2V0IHBhc3QgdGhpcyBsaW1pdGF0aW9uIGluIGFueSB3YXk/CgpP
bmUgYXBwcm9hY2ggY291bGQgYmUgdG8gbG9hZCBzb21lIHRlbXBvcmFyeSB0YWJsZSB3aXRoIHRo
ZSBmaWx0ZXIgZGF0YSAKYW5kIHRoZW4gam9pbiBCSUdUQUJMRSB3aXRoIHRoZSB0ZW1wIHRhYmxl
LCBidXQgYXMgSSBzYWlkLCBteSBPcmFjbGUgCnVzZXIgaXMgdmVyeSBsaW1pdGVkIGFuZCBjYW4n
dCBjcmVhdGUgdGVtcG9yYXJ5IHRhYmxlcywgbXVjaCBsZXNzIGxvYWQgCnRoZW0gd2l0aCBkYXRh
LgoKSSdkIHZlcnkgbXVjaCBhcHByZWNpYXRlIGFueSBpZGVhIGZvciBzb2x2aW5nIHRoaXMuIEFu
ZCBhZ2FpbiwgYWNjZXB0IG15IAphcG9sb2dpZXMgaWYgeW91IGZlZWwgdGhpcyBxdWVzdGlvbiBp
cyB2ZXJ5IG9mZnRvcGljLgoKVGhhbmtzIGluIGFkdmFuY2UuClJlZ2FyZHMKSi4KCi0tIAoKCSov
Sm9yZ2UgR29uesOhbGV6IFZpbGxhbG9uZ2EvKgpEaXJlY3RvciBUw6ljbmljbwoKKi9EQUlLT04g
SW50ZWdyYWNpw7NuIHkgRGVzYXJyb2xsbyBTLkwuLyoKVGVsZjogKCszNCkgOTEgMTg4IDA4IDI4
CkZheDogKCszNCkgOTEgNjMyIDY1IDQyCip3d3cuZGFpa29uLmVzKgoKLS0tLS0tLS0tLS0tLS0g
bmV4dCBwYXJ0IC0tLS0tLS0tLS0tLS0tClNraXBwZWQgY29udGVudCBvZiB0eXBlIG11bHRpcGFy
dC9yZWxhdGVk
More information about the DBIx-Class
mailing list