Subject: Re: ".. WHERE id IN (..1340 ids..) " = > error 2007-09-28 - By Michael P
Back
Hi,
thanks. -- Unfortunately the error remains the same, even when setting
the parameter _PACKET_SIZE to the max value 131072 and reduce the select
command to "SELECT p_id, p_name FROM persons WHERE p_id IN (220,260,
..<1340 ids..>)", i.e. only 1 table, no "order by". The command consists
of only about 7000 chars which is much smaller than default value of the
parameter (36864) or even the max value 131072.
What's could be wrong with the command?
Best wishes
Michael
Alexei Novakov schrieb:
>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 <mp11@(protected)>
>To: List <maxdb@(protected)>
>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
>
>
>
|
|
