There is _PACKET_SIZE parameter which limits size of communication packet. Try
in increase it. Max size allowed is 131072 bytes.
Alexei.
----- Original Message ----
From: Michael P <[EMAIL PROTECTED]>
To: List <maxdb@lists.mysql.com>
Sent: Thursday, September 27, 2007 3:07:34 PM
Subject: ".. WHERE id IN (..1340 ids..)" => error
Hi,
I use 1340 ids in the IN condition. The result is the error message:
#Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
# General error;-1103 POS(1) Too complicated SQL statement
Is the number of ids or the length of the sql cmd measured in chars the
problem? What are the limits. I use MaxDB 7.5.
Is there any chance to make it possible to use 1340 explicitely
mentioned ids or even more?
Of course, when I use a subquery instead of the list of ids the error
disappears.
Best wishes -- thanks for hints
Michael
- - - - -
SELECT s_registrationno, p_id, p_name, p_firstname, p_sexcodeno,
p_title1codeno, p_title2codeno, p_titleelse, p_title3codeno
FROM persons, students
WHERE p_fk_student_id = s_id
AND p_id IN (220,260,318,329,431,526,572,575,584,632,643,653,656,745,790,
853,861,867,874,875,876,885,886,891,894,902,903,916,923,930,
932,934,936,940,945,971,996,1011,1013,1014,1015,1016,1026,
1030,1041,1048,1060,1062,1089,1119,1129,1132,1133,1135,1136,
1137,1138,1139,1141,1142,1143,1144,1145,1146,1147,1149,1152,
1153,1154,1155,1158,1160,1161,1162,1165,1166,1167,1168,1169,
1170,1171,1173,1174,1175,1176,1177,1178,1179,1180,1181,1183,
1184,1185,1188,1191,1192,1193,1194,1195,1196,1197,1198,1199,
1200,1203,1204,1205,1206,1207,1209,1210,1211,1212,1215,1216,
1217,1218,1219,1220,1221,1222,1223,1224,1225,1227,1228,1229,
1230,1231,1232,1233,1234,1236,1237,1238,1239,1240,1242,1243,
1244,1246,1249,1250,1251,1252,1253,1254,1255,1256,1257,1259,
1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,
1273,1274,1275,1276,1277,1278,1280,1282,1283,1289,1293,1294,
1296,1297,1302,1308,1317,1319,1320,1324,1327,1329,1331,1334,
1335,1338,1340,1342,1343,1345,1348,1349,1352,1355,1359,1361,
1363,1364,1368,1369,1370,1372,1373,1375,1376,1378,1379,1381,
1382,1384,1386,1396,1399,1400,1411,1415,1416,1431,1432,1434,
1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1447,
1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,
1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,
1473,1474,1475,1476,1478,1479,1480,1481,1484,1485,1486,1487,
1488,1489,1490,1491,1492,1494,1495,1496,1497,1498,1499,1500,
1501,1502,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,
1514,1515,1516,1517,1518,1519,1522,1523,1524,1525,1526,1527,
1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,
1541,1542,1543,1544,1546,1547,1548,1549,1553,1554,1555,1558,
1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,
1571,1572,1573,1574,1576,1577,1578,1579,1580,1582,1583,1584,
1585,1586,1587,1588,1589,1590,1591,1592,1594,1595,1596,1597,
1598,1599,1600,1601,1602,1603,1604,1606,1611,1613,1614,1615,
1616,1617,1618,1619,1621,1622,1623,1624,1626,1627,1628,1629,
1631,1632,1633,1635,1637,1639,1641,1643,1644,1645,1646,1648,
1649,1650,1651,1652,1653,1654,1655,1656,1657,1659,1660,1661,
1662,1663,1666,1668,1669,1670,1671,1672,1673,1674,1675,1676,
1677,1678,1679,1680,1683,1684,1686,1688,1690,1691,1692,1693,
1694,1698,1700,1701,1703,1704,1705,1706,1707,1708,1709,1710,
1712,1713,1715,4946,4948,4949,4950,4951,4952,4953,4954,4955,
4956,4957,4958,4959,4960,4961,4964,4965,4966,4968,4969,4970,
4971,4973,4974,4975,4976,4977,4978,4980,4981,4982,4983,4984,
4985,4986,4987,4988,4989,4991,4993,4994,4995,4996,4997,4998,
4999,5000,5001,5002,5003,5004,5006,5007,5008,5009,5010,5011,
5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,
5024,5025,5026,5027,5029,5030,5031,5032,5033,5034,5035,5036,
5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047,5048,
5049,5050,5051,5052,5053,5054,5055,5056,5059,5060,5061,5062,
5063,5064,5065,5067,5068,5069,5070,5071,5072,5073,5074,5075,
5076,5077,5078,5079,5080,5081,5082,5083,5084,5085,5086,5087,
5088,5089,5090,5091,5093,5094,5095,5096,5097,5098,5099,5100,
5101,5102,5103,5104,5105,5106,5107,5108,5109,5110,5111,5112,
5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5126,5127,
5128,5129,5130,5131,5132,5134,5136,5137,5138,5139,5140,5141,
5142,5143,5144,5145,5146,5148,5149,5150,5151,5152,5154,5155,
5156,5157,5158,5159,5160,5161,5162,5163,5164,5165,5166,5167,
5168,5169,5170,5171,5172,5173,5174,5175,5176,5177,5178,5179,
5180,5181,5182,5183,5184,5185,5186,5187,5188,5189,5190,5192,
5193,5194,5195,5196,5197,5198,5201,5202,5203,5204,5205,5206,
5207,5208,5279,5280,5356,5407,5480,5481,5652,5653,5654,5655,
5656,5657,5760,5865,5946,6148,6149,6151,6154,6156,6221,6232,
6455,6456,6457,6458,6459,6460,6461,6462,6463,6464,6465,6466,
6468,6469,6470,6471,6476,6480,6481,6482,6483,6484,6485,6486,
6487,6488,6489,6491,6492,6493,6494,6496,6498,6500,6501,6502,
6503,6504,6505,6506,6507,6512,6513,6514,6515,6516,6517,6518,
6519,6520,6521,6523,6524,6525,6526,6529,6530,6532,6533,6534,
6535,6536,6537,6538,6540,6541,6543,6545,6546,6547,6549,6550,
6551,6552,6553,6554,6556,6557,6558,6559,6560,6561,6562,6564,
6566,6567,6568,6569,6570,6572,6573,6575,6576,6577,6578,6579,
6580,6583,6585,6586,6587,6588,6589,6590,6591,6593,6597,6598,
6599,6600,6601,6602,6603,6604,6607,6608,6609,6610,6611,6612,
6614,6615,6616,6617,6618,6619,6620,6621,6623,6625,6627,6628,
6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6639,6640,
6641,6642,6643,6644,6645,6646,6647,6649,6650,6651,6652,6653,
6654,6655,6656,6657,6658,6659,6660,6661,6662,6663,6664,6665,
6666,6667,6668,6669,6671,6672,6673,6675,6677,6678,6679,6680,
6681,6682,6684,6685,6686,6687,6688,6689,6690,6691,6692,6693,
6694,6695,6696,6697,6699,6700,6702,6703,6704,6705,6706,6707,
6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6720,
6721,6722,6723,6724,6725,6726,6727,6728,6730,6731,6732,6734,
6735,6737,6740,6741,6742,6744,6745,6747,6748,6755,6756,6757,
6758,6760,6761,6762,6764,6765,6777,6778,6780,6783,6800,6828,
6830,6845,6949,7008,7101,7107,7108,7135,7137,7139,7167,7187,
7198,7213,7214,7250,7251,7253,7254,7256,7257,7259,7260,7261,
7265,7268,7269,7270,7271,7272,7273,7274,7275,7278,7279,7280,
7281,7282,7283,7284,7286,7287,7289,7290,7291,7330,7414,7524,
7560,7562,7568,7569,7570,7571,7572,7573,7581,7583,7584,7585,
7587,7589,7590,7591,7593,7597,7716,7744,7745,7748,7750,7751,
7752,7753,7757,7759,7760,7761,7763,7766,7768,7769,7770,7771,
7772,7773,7774,7776,7777,7778,7779,7780,7781,7782,7783,7784,
7785,7786,7792,7793,7796,7797,7798,7799,7800,7801,7802,7803,
7804,7808,7809,7810,7814,7815,7816,7818,7819,7821,7822,7823,
7827,7828,7830,7831,7833,7835,7836,7843,7844,7846,7847,7848,
7849,7850,7851,7852,7853,7856,7858,7864,7867,7869,7870,7872,
7873,7874,7876,7877,7880,7892,7893,7894,7895,7896,7897,7899,
7900,7901,7902,7903,7904,7905,7908,7909,7911,7913,7914,7915,
7916,7917,7918,7919,7920,7922,7923,7924,7926,7927,7928,7930,
7951,7952,7960,7961,7963,7964,7967,7969,7970,7975,7977,7980,
7981,7985,7988,7989,7992,7995,7997,7998,8001,8003,8004,8005,
8006,8012,8014,8015,8017,8020,8021,8024,8026,8027,8035,8037,
8041,8042,8045,8047,8048,8050,8052,8054,8055,8058,8059,8060,
8065,8066,8072,8073,8076,8078,8081,8084,8086,8087,8089,8093,
8097,8099,8106,8114,8142,8143,8144,8151,8155,8157,8158,8159,
8162,8165,8166,8167,8168,8170,8171,8175,8178,8179,8182,8241,
8242,8243,8244,8245,8246,8249,8250,8251,8252,8255,8257,8263,
8273,8275,8276,8278,8279,8280,8282,8289,8290,8291,8292,8293,
8295,8297,8298,8299,8300,8302,8303,8304,8307,8308,8309,8310,
8312,8315,8317,8318,8321,8322,8323,8325,8327,8328,8329,8331,
8332,8354,8355,8356,8357,8358,8359,8360,8361,8362,8363,8364,
8365,8366,8367,8368,8369,8370,8371,8372,8373,8374,8375,8376,
8377,8378,8379,8380,8381,8382,8385,8386,8388,8389,8390,8391,
8394,8395,8396,8397,8399,8400,8401,8409,8424,8429,8430,8431,
8432,8433,8442,8443,8444,8445,8446,8447,8448,8449,8450,8459,
8460)
ORDER BY s_registrationno
