innoq/iqvoc — Issue #101: Complete RDF Export fails on Oracle
Author: mrreynolds
Created: 2012-02-06 11:27:10+00:00
State: open
Labels: bug

```
ActionView::Template::Error (NativeException: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
: SELECT "LABELS".* FROM "LABELS" WHERE ("LABELS"."ID" IN (10662,15835,21041,36648,26249,31440,52272,47064,41856,67922,62687,57480,79540,74332,14298,19497,35103,29905,24704,50727,45519,40311,66386,61142,55935,77995,72485,83203,10663,15836,21042,36649,26250,31441,52273,47065,41857,67923,62688,57481,79541,74333,15718,20924,36531,31325,26132,46947,52155,41739,67806,62570,57363,79423,74201,84631,15017,20218,35824,30624,25425,51448,46240,41032,67103,61863,56656,78716,73349,83924,10664,15837,21043,36650,26251,31442,52274,47066,41858,67924,62689,57482,79542,74334,10665,15838,21044,36651,26252,31443,52275,47067,41859,67925,62690,57483,79543,74335,10666,15839,21045,36652,26253,31444,52276,47068,41860,67926,62691,57484,79544,74336,10667,15840,21046,36653,26254,31445,52277,47069,41861,67927,62692,57485,79545,74337,10668,15841,21047,36654,31446,26255,52278,47070,41862,67928,62693,57486,79546,74338,10669,15842,21048,36655,31447,26256,52279,47071,41863,67929,62694,57487,79547,74339,14302,19501,35107,29909,24708,50731,45523,40315,66390,61146,55939,77999,72489,72490,72491,83207,10670,15843,21049,36656,31448,26257,52280,47072,41864,67930,62695,57488,79548,74340,10671,15844,21050,36657,31449,26258,52281,47073,41865,67931,62696,57489,79549,74341,14731,19930,35536,30337,25137,51160,45952,40744,66820,61575,56368,78428,72987,83636,14304,19503,35109,29911,24710,50733,45525,40317,66392,61148,55941,78001,72494,83209,14305,19504,35110,29912,24711,50734,45526,40318,66393,61149,55942,78002,72495,83210,14306,19505,35111,29913,24712,50735,45527,40319,66394,61150,55943,78003,72496,83211,10672,15845,21051,36658,31450,26259,52282,47074,41866,67932,62697,57490,79550,74342,14307,19506,35112,29914,24713,50736,45528,40320,66395,61151,55944,78004,72497,83212,15019,20220,35826,30626,25427,51450,46242,41034,67105,61865,56658,78718,73351,83926,10674,15847,21053,36660,31452,26261,52284,47076,41868,67935,67936,62699,57492,79552,74344,10675,15848,21054,36661,31453,26262,52285,47077,41869,67937,62700,57493,79553,74345,14309,19508,35114,29916,24715,50738,45530,40322,66397,61153,55946,78006,72499,83214,10676,15849,21055,36662,31454,26263,52286,47078,41870,67938,62701,57494,79554,74346,10677,15850,21056,36663,31455,26264,52287,47079,41871,67939,62702,57495,79555,74347,14295,19494,35100,29902,24701,50724,45516,40308,66383,61139,55932,77992,72482,83200,10678,15851,21057,36664,31456,26265,52288,47080,41872,67940,62703,57496,79556,74348,10679,15852,21058,36665,31457,26266,52289,47081,41873,67941,62704,57497,79557,74349,10680,15853,21059,36666,31458,26267,52290,47082,41874,67942,62705,57498,79558,74350,10681,15854,21060,36667,31459,26268,52291,47083,41875,67943,67944,62706,57499,79559,74351,10682,15855,21061,36668,31460,26269,52292,47084,41876,67945,62707,57500,79560,74352,14314,19513,35119,29921,24720,50743,45535,40327,66402,61158,55951,78011,72508,83219,10683,15856,21062,36669,31461,26270,52293,47085,41877,67946,62708,57501,79561,74353,10684,15857,21063,36670,31462,26271,52294,47086,41878,67947,62709,57502,79562,74354,14316,19515,35121,29923,24722,50745,45537,40329,66404,61160,55953,78013,72510,83221,10685,15858,21064,36671,31463,26272,52295,47087,41879,67948,62710,57503,79563,74355,14297,19496,35102,29904,24703,50726,45518,40310,66385,61141,55934,77994,72484,83202,10686,15859,21065,36672,31464,26273,52296,47088,41880,67949,62711,57504,79564,74356,14318,19517,35123,29925,24724,50747,45539,40331,66406,61162,55955,78015,72512,83223,10687,15860,21066,36673,31465,52297,47089,41881,67950,62712,57505,79565,74357,10688,15861,21067,36674,31466,26274,52298,47090,41882,67951,62713,57506,79566,74358,10689,15862,21068,36675,31467,26275,52299,47091,41883,67952,62714,57507,79567,74359,14321,19520,35126,29928,24727,50750,45542,40334,66409,61165,55958,78018,72516,83226,10690,15863,21069,36676,31468,26276,52300,47092,41884,67953,62715,57508,79568,74360,10691,15864,21070,36677,31469,26277,52301,47093,41885,67954,62716,57509,79569,74361,10692,15865,21071,36678,31470,26278,52302,47094,41886,67955,67956,62717,57510,79570,74362,14323,19522,35128,29930,24729,50752,45544,40336,66411,61167,55960,78020,72518,83228,10693,15866,21072,36679,31471,26279,52303,47095,41887,67957,62718,57511,79571,74363,10694,15867,21073,36680,31472,26280,52304,47096,41888,67958,67959,62719,57512,79572,74364,10695,15868,21074,36681,31473,26281,52305,47097,41889,67960,62720,57513,79573,74365,10696,15869,21075,36682,31474,26282,52306,47098,41890,67961,62721,57514,79574,74366,10697,15870,21076,36683,31475,26283,52307,47099,41891,67962,57515,79575,74367,10698,15871,21077,36684,31476,26284,52308,47100,41892,67963,62722,57516,79576,74368,10699,15872,21078,36685,31477,26285,52309,47101,41893,67964,67965,67966,62723,57517,79577,74369,10700,15873,21079,36686,31478,26286,52310,47102,41894,67967,62724,57518,79578,74370,14330,19529,35135,24736,29937,50759,45551,40343,66418,66419,61174,55967,78027,72525,83235,14331,19530,35136,24737,29938,50760,45552,40344,66420,61175,55968,78028,72526,72527,83236,14332,19531,35137,24738,29939,50761,45553,40345,61176,55969,78029,72528,83237,10701,15874,21080,36687,31479,26287,52311,47103,41895,67968,67969,62725,57519,79579,74371,14333,19532,35138,24739,29940,50762,45554,40346,66421,61177,55970,78030,72529,83238,15027,20228,35834,25435,30634,51458,46250,41042,67113,61873,56666,78726,73362,83934,10702,15875,21081,36688,31480,26288,52312,47104,41896,67970,62726,57520,79580,74372,10703,15876,21082,36689,31481,26289,52313,47105,41897,67971,62727,57521,79581,74373,14334,19533,35139,24740,29941,50763,45555,40347,66422,61178,55971,78031,72530,83239,10704,15877,21083,36690,31482,26290,52314,47106,41898,67972,62728,57522,79582,74374,10705,15878,21084,36691,31483,26291,52315,47107,41899,67973,62729,57523,79583,74375,10706,15879,21085,36692,31484,26292,52316,47108,41900,67974,62730,57524,79584,74376,14336,19535,35141,24742,29943,50765,45557,40349,66424,61180,55973,78033,72532,83241,10707,15880,21086,36693,31485,26293,52317,47109,41901,67975,62731,57525,79585,74377,10708,15881,21087,36694,31486,26294,52318,47110,41902,67976,62732,57526,79586,74378,14339,19538,35144,24745,29946,50768,45560,40352,66427,61183,55976,78036,72535,83244,14340,19539,35145,24746,29947,50769,45561,40353,66428,61184,55977,78037,72536,72537,83245,14341,19540,35146,24747,29948,50770,45562,40354,66429,61185,55978,78038,72538,72539,83246,14342,19541,35147,24748,29949,50771,45563,40355,66430,61186,55979,78039,72540,83247,10709,15882,21088,36695,31487,26295,52319,47111,41903,67977,62733,57527,79587,74379,10710,15883,21089,36696,31488,26296,52320,47112,41904,67978,62734,57528,79588,74380,10711,15884,21090,36697,31489,26297,52321,47113,41905,67979,62735,57529,79589,74381,10712,15885,21091,36698,31490,26298,52322,47114,41906,67980,67981,62736,57530,79590,74382,14300,19499,35105,29907,24706,50729,45521,40313,66388,61144,55937,77997,72487,83205,10713,15886,21092,36699,31491,26299,52323,47115,41907,67982,62737,57531,79591,74383,10714,15887,21093,36700,31492,26300,52324,47116,41908,67983,67984,67985,62738,57532,79592,74384,10715,15888,21094,36701,31493,26301,52325,47117,41909,67986,67987,62739,62740,57533,79593,74385,14301,19500,35106,29908,24707,50730,45522,40314,66389,61145,55938,77998,72488,83206,14347,19546,35152,24753,29954,50776,45568,40360,66435,61191,55984,78044,72546,83252,10716,15889,21095,36702,31494,26302,52326,47118,41910,67988,62741,57534,79594,74386,15521,20725,36332,31130,25933,51956,46748,41540,62371,67606,57164,79224,73971,84432,14348,19547,35153,24754,29955,50777,45569,40361,66436,61192,55985,78045,72547,83253,15469,20673,36280,31078,25881,51904,46696,41488,62319,67552,57112,79172,73910,73911,84380,14349,19548,35154,24755,29956,50778,45570,40362,66437,61193,55986,78046,72548,83254,14350,19549,35155,24756,29957,50779,45571,40363,66438,61194,55987,78047,72549,83255,10717,15890,21096,36703,31495,26303,52327,47119,41911,67989,62742,57535,79595,74387,14351,19550,35156,24757,29958,50780,45572,40364,66439,61195,55988,78048,72550,83256,10718,15891,21097,36704,31496,26304,52328,47120,41912,67990,62743,57536,79596,74388,14352,19551,35157,24758,29959,50781,45573,40365,66440,61196,55989,78049,72551,83257,10719,15892,21098,36705,31497,26305,52329,47121,41913,67991,62744,57537,79597,74389,14354,19553,35159,24760,29961,50783,45575,40367,66442,61198,55991,78051,72553,83259,14355,19554,35160,24761,29962,50784,45576,40368,66443,61199,55992,78052,72554,83260,10720,15893,21099,36706,31498,26306,52330,47122,41914,67992,62745,57538,79598,74390,14356,19555,35161,24762,29963,50785,45577,40369,66444,61200,55993,78053,72555,83261)))
```