Re: ".. WHERE id IN (..1340 ids..)" => error

There is _PACKET_SIZE parameter which limits size of communication packet. =
Try in increase it. Max size allowed is 131072 bytes.=0A=0AAlexei.=0A=0A---=
-- Original Message ----=0AFrom: Michael P <[email protected]>=0ATo: List <maxd=
[email protected]>=0ASent: Thursday, September 27, 2007 3:07:34 PM=0ASubjec=
t: ".. WHERE id IN (..1340 ids..)" =3D> error=0A=0AHi,=0A=0AI use 1340 ids =
in the IN condition. The result is the error message:=0A=0A#Auto Commit: On=
, SQL Mode: Internal, Isolation Level: Committed=0A# General error;-1103 PO=
S(1) Too complicated SQL statement=0A=0AIs the number of ids or the length =
of the sql cmd measured in chars the =0Aproblem? What are the limits. I use=
 MaxDB 7.5.=0A=0AIs there any chance to make it possible to use 1340 explic=
itely =0Amentioned ids or even more?=0A=0AOf course, when I use a subquery =
instead of the list of ids the error =0Adisappears.=0A=0ABest wishes -- tha=
nks for hints=0AMichael=0A=0A- - - - -=0A=0ASELECT   s_registrationno, p_id=
, p_name, p_firstname, p_sexcodeno, =0Ap_title1codeno, p_title2codeno, p_ti=
tleelse, p_title3codeno=0AFROM persons, students=0AWHERE p_fk_student_id =
=3D s_id=0AAND p_id IN (220,260,318,329,431,526,572,575,584,632,643,653,656=
,745,790,=0A853,861,867,874,875,876,885,886,891,894,902,903,916,923,930,=0A=
932,934,936,940,945,971,996,1011,1013,1014,1015,1016,1026,=0A1030,1041,1048=
,1060,1062,1089,1119,1129,1132,1133,1135,1136,=0A1137,1138,1139,1141,1142,1=
143,1144,1145,1146,1147,1149,1152,=0A1153,1154,1155,1158,1160,1161,1162,116=
5,1166,1167,1168,1169,=0A1170,1171,1173,1174,1175,1176,1177,1178,1179,1180,=
1181,1183,=0A1184,1185,1188,1191,1192,1193,1194,1195,1196,1197,1198,1199,=
=0A1200,1203,1204,1205,1206,1207,1209,1210,1211,1212,1215,1216,=0A1217,1218=
,1219,1220,1221,1222,1223,1224,1225,1227,1228,1229,=0A1230,1231,1232,1233,1=
234,1236,1237,1238,1239,1240,1242,1243,=0A1244,1246,1249,1250,1251,1252,125=
3,1254,1255,1256,1257,1259,=0A1260,1261,1262,1263,1264,1265,1266,1267,1268,=
1269,1270,1271,=0A1273,1274,1275,1276,1277,1278,1280,1282,1283,1289,1293,12=
94,=0A1296,1297,1302,1308,1317,1319,1320,1324,1327,1329,1331,1334,=0A1335,1=
338,1340,1342,1343,1345,1348,1349,1352,1355,1359,1361,=0A1363,1364,1368,136=
9,1370,1372,1373,1375,1376,1378,1379,1381,=0A1382,1384,1386,1396,1399,1400,=
1411,1415,1416,1431,1432,1434,=0A1435,1436,1437,1438,1439,1440,1441,1442,14=
43,1444,1445,1447,=0A1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458=
,1459,=0A1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,=0A147=
3,1474,1475,1476,1478,1479,1480,1481,1484,1485,1486,1487,=0A1488,1489,1490,=
1491,1492,1494,1495,1496,1497,1498,1499,1500,=0A1501,1502,1504,1505,1506,15=
07,1508,1509,1510,1511,1512,1513,=0A1514,1515,1516,1517,1518,1519,1522,1523=
,1524,1525,1526,1527,=0A1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1=
538,1539,=0A1541,1542,1543,1544,1546,1547,1548,1549,1553,1554,1555,1558,=0A=
1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,=0A1571,1572,15=
73,1574,1576,1577,1578,1579,1580,1582,1583,1584,=0A1585,1586,1587,1588,1589=
,1590,1591,1592,1594,1595,1596,1597,=0A1598,1599,1600,1601,1602,1603,1604,1=
606,1611,1613,1614,1615,=0A1616,1617,1618,1619,1621,1622,1623,1624,1626,162=
7,1628,1629,=0A1631,1632,1633,1635,1637,1639,1641,1643,1644,1645,1646,1648,=
=0A1649,1650,1651,1652,1653,1654,1655,1656,1657,1659,1660,1661,=0A1662,1663=
,1666,1668,1669,1670,1671,1672,1673,1674,1675,1676,=0A1677,1678,1679,1680,1=
683,1684,1686,1688,1690,1691,1692,1693,=0A1694,1698,1700,1701,1703,1704,170=
5,1706,1707,1708,1709,1710,=0A1712,1713,1715,4946,4948,4949,4950,4951,4952,=
4953,4954,4955,=0A4956,4957,4958,4959,4960,4961,4964,4965,4966,4968,4969,49=
70,=0A4971,4973,4974,4975,4976,4977,4978,4980,4981,4982,4983,4984,=0A4985,4=
986,4987,4988,4989,4991,4993,4994,4995,4996,4997,4998,=0A4999,5000,5001,500=
2,5003,5004,5006,5007,5008,5009,5010,5011,=0A5012,5013,5014,5015,5016,5017,=
5018,5019,5020,5021,5022,5023,=0A5024,5025,5026,5027,5029,5030,5031,5032,50=
33,5034,5035,5036,=0A5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047=
,5048,=0A5049,5050,5051,5052,5053,5054,5055,5056,5059,5060,5061,5062,=0A506=
3,5064,5065,5067,5068,5069,5070,5071,5072,5073,5074,5075,=0A5076,5077,5078,=
5079,5080,5081,5082,5083,5084,5085,5086,5087,=0A5088,5089,5090,5091,5093,50=
94,5095,5096,5097,5098,5099,5100,=0A5101,5102,5103,5104,5105,5106,5107,5108=
,5109,5110,5111,5112,=0A5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5=
126,5127,=0A5128,5129,5130,5131,5132,5134,5136,5137,5138,5139,5140,5141,=0A=
5142,5143,5144,5145,5146,5148,5149,5150,5151,5152,5154,5155,=0A5156,5157,51=
58,5159,5160,5161,5162,5163,5164,5165,5166,5167,=0A5168,5169,5170,5171,5172=
,5173,5174,5175,5176,5177,5178,5179,=0A5180,5181,5182,5183,5184,5185,5186,5=
187,5188,5189,5190,5192,=0A5193,5194,5195,5196,5197,5198,5201,5202,5203,520=
4,5205,5206,=0A5207,5208,5279,5280,5356,5407,5480,5481,5652,5653,5654,5655,=
=0A5656,5657,5760,5865,5946,6148,6149,6151,6154,6156,6221,6232,=0A6455,6456=
,6457,6458,6459,6460,6461,6462,6463,6464,6465,6466,=0A6468,6469,6470,6471,6=
476,6480,6481,6482,6483,6484,6485,6486,=0A6487,6488,6489,6491,6492,6493,649=
4,6496,6498,6500,6501,6502,=0A6503,6504,6505,6506,6507,6512,6513,6514,6515,=
6516,6517,6518,=0A6519,6520,6521,6523,6524,6525,6526,6529,6530,6532,6533,65=
34,=0A6535,6536,6537,6538,6540,6541,6543,6545,6546,6547,6549,6550,=0A6551,6=
552,6553,6554,6556,6557,6558,6559,6560,6561,6562,6564,=0A6566,6567,6568,656=
9,6570,6572,6573,6575,6576,6577,6578,6579,=0A6580,6583,6585,6586,6587,6588,=
6589,6590,6591,6593,6597,6598,=0A6599,6600,6601,6602,6603,6604,6607,6608,66=
09,6610,6611,6612,=0A6614,6615,6616,6617,6618,6619,6620,6621,6623,6625,6627=
,6628,=0A6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6639,6640,=0A664=
1,6642,6643,6644,6645,6646,6647,6649,6650,6651,6652,6653,=0A6654,6655,6656,=
6657,6658,6659,6660,6661,6662,6663,6664,6665,=0A6666,6667,6668,6669,6671,66=
72,6673,6675,6677,6678,6679,6680,=0A6681,6682,6684,6685,6686,6687,6688,6689=
,6690,6691,6692,6693,=0A6694,6695,6696,6697,6699,6700,6702,6703,6704,6705,6=
706,6707,=0A6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6720,=0A=
6721,6722,6723,6724,6725,6726,6727,6728,6730,6731,6732,6734,=0A6735,6737,67=
40,6741,6742,6744,6745,6747,6748,6755,6756,6757,=0A6758,6760,6761,6762,6764=
,6765,6777,6778,6780,6783,6800,6828,=0A6830,6845,6949,7008,7101,7107,7108,7=
135,7137,7139,7167,7187,=0A7198,7213,7214,7250,7251,7253,7254,7256,7257,725=
9,7260,7261,=0A7265,7268,7269,7270,7271,7272,7273,7274,7275,7278,7279,7280,=
=0A7281,7282,7283,7284,7286,7287,7289,7290,7291,7330,7414,7524,=0A7560,7562=
,7568,7569,7570,7571,7572,7573,7581,7583,7584,7585,=0A7587,7589,7590,7591,7=
593,7597,7716,7744,7745,7748,7750,7751,=0A7752,7753,7757,7759,7760,7761,776=
3,7766,7768,7769,7770,7771,=0A7772,7773,7774,7776,7777,7778,7779,7780,7781,=
7782,7783,7784,=0A7785,7786,7792,7793,7796,7797,7798,7799,7800,7801,7802,78=
03,=0A7804,7808,7809,7810,7814,7815,7816,7818,7819,7821,7822,7823,=0A7827,7=
828,7830,7831,7833,7835,7836,7843,7844,7846,7847,7848,=0A7849,7850,7851,785=
2,7853,7856,7858,7864,7867,7869,7870,7872,=0A7873,7874,7876,7877,7880,7892,=
7893,7894,7895,7896,7897,7899,=0A7900,7901,7902,7903,7904,7905,7908,7909,79=
11,7913,7914,7915,=0A7916,7917,7918,7919,7920,7922,7923,7924,7926,7927,7928=
,7930,=0A7951,7952,7960,7961,7963,7964,7967,7969,7970,7975,7977,7980,=0A798=
1,7985,7988,7989,7992,7995,7997,7998,8001,8003,8004,8005,=0A8006,8012,8014,=
8015,8017,8020,8021,8024,8026,8027,8035,8037,=0A8041,8042,8045,8047,8048,80=
50,8052,8054,8055,8058,8059,8060,=0A8065,8066,8072,8073,8076,8078,8081,8084=
,8086,8087,8089,8093,=0A8097,8099,8106,8114,8142,8143,8144,8151,8155,8157,8=
158,8159,=0A8162,8165,8166,8167,8168,8170,8171,8175,8178,8179,8182,8241,=0A=
8242,8243,8244,8245,8246,8249,8250,8251,8252,8255,8257,8263,=0A8273,8275,82=
76,8278,8279,8280,8282,8289,8290,8291,8292,8293,=0A8295,8297,8298,8299,8300=
,8302,8303,8304,8307,8308,8309,8310,=0A8312,8315,8317,8318,8321,8322,8323,8=
325,8327,8328,8329,8331,=0A8332,8354,8355,8356,8357,8358,8359,8360,8361,836=
2,8363,8364,=0A8365,8366,8367,8368,8369,8370,8371,8372,8373,8374,8375,8376,=
=0A8377,8378,8379,8380,8381,8382,8385,8386,8388,8389,8390,8391,=0A8394,8395=
,8396,8397,8399,8400,8401,8409,8424,8429,8430,8431,=0A8432,8433,8442,8443,8=
444,8445,8446,8447,8448,8449,8450,8459,=0A8460)=0AORDER BY s_registrationno=
=0A=0A-- =0AMaxDB Discussion Mailing List=0AFor list archives: http://lists=
.mysql.com/maxdb=0ATo unsubscribe:    http://lists.mysql.com/maxdb?unsub=3D=
[email protected]=0A=0A=0A=0A=0A=0A=0A      Be smarter than spam. Se=
e how smart SpamGuard is at giving junk email the boot with the All-new Yah=
oo! Mail at http://mrd.mail.yahoo.com/try_beta?.intl=3Dca=0A

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]