Re: .. WHERE id IN (..1340 ids..) = error
Michael P wrote: 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,
Re: .. WHERE id IN (..1340 ids..) = error
Becker, Holger schrieb: Michael P wrote: 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,
Re: .. WHERE id IN (..1340 ids..) = error
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 [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