New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
request size limit exceeded when selecting from a table with large number of indicies [CORE6216] #6460
Comments
Modified by: Alex Kurov (alex.kurov)description: Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {expand: meta statement} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {expand: select statement} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) => Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {code} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {code} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) |
Modified by: Alex Kurov (alex.kurov)description: Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {code} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {code} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) => Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {code:sql} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {code:sql} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) |
Modified by: Alex Kurov (alex.kurov)description: Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {code:sql} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {code:sql} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) => Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {panel} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {code:sql} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) |
Modified by: Alex Kurov (alex.kurov)description: Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing {panel} create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); {code:sql} where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) => Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing drop table TABLE_TEST; create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); SELECT where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) |
Modified by: Alex Kurov (alex.kurov)description: Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/). And we get this message executing statements with length less than 64k. We've tried to reproduce such behavior on a test example and came to conclusion, that the error is rased when you combine using IN operator and select statement from a table with large number of indicies. It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table. If we decrease the number of indicies then the error will disapear. Excuse me for such a large listing drop table TABLE_TEST; create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); SELECT where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) => Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. Excuse me for such a large listing drop table TABLE_TEST; create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); SELECT where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) |
Commented by: @dyemanov This error means that the compiled statement requires more than 10MB of memory. A kind of protection against misuse, worth thinking about re-writing the query in some other way. |
Commented by: @livius2 You should avoid such queries. |
Commented by: Alex Kurov (alex.kurov) Of course I understand that such statements are kind of bad manner. But this is auto generated sql in report builder tool. PLAN (T NATURAL) |
Commented by: Sean Leyne (seanleyne) Please post the PLAN for the original query (with indexes) |
Commented by: Sean Leyne (seanleyne) 1- It would seem appropriate to update the message, in 2 regards; (i) provide context that the size of the compiled request is the problem, and (ii) that the limit is 10MB. No? 2- IMO, given the amount of memory in modern systems,10MB seems like a really low setting. |
Commented by: Alex Kurov (alex.kurov) @sean Database: C:\temp\TEST_DATABASE.FDB, User: SYSDBA The plan (in previous comment) was taken when there was 19 indicies, because I get an error with 20 indicies in this example. |
Modified by: @dyemanovAttachment: core-6216.sql [ 13411 ] |
Commented by: @dyemanov I've moved the test case to an attachment to make the ticket readable. |
Modified by: @dyemanovdescription: Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. Excuse me for such a large listing drop table TABLE_TEST; create index TABLE_TEST_FIELD2 on TABLE_TEST(FIELD2); SELECT where t.field1 in (90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041,90,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,99000000000204190,288,991020000000001,991020000000002,272,316,368,376,225,254,262,133,237,361,210,384,336,275,285,339,346,10,17,52,53,68,108,109,116,125,126,142,153,155,180,189,205,206,208,216,218,221,223,238,240,256,266,274,276,289,291,293,334,337,343,352,369,377,990004324,3,5,6,15,16,28,33,36,25,111,129,137,235,284,350,363,371,207,209,224,228,239,263,281,282,96,43,226,236,280,331,333,375,67,178,181,366,391,22,185,4,87,134,166,164,103,197,39,98,172,261,386,106,118,345,392,40,122,184,257,200,379,367,143,194,85,18,30,123,139,147,296,297,45,991020000000007,349,38,144,145,146,170,182,187,190,233,271,277,299,300,389,95,83,312,330,232,267,310,241,227,302,303,304,305,306,307,308,311,314,319,321,322,324,327,335,340,342,351,353,354,355,356,357,358,359,360,365,373,381,388,991020000000005,990000000000016,990000000000101,990000000000102,990000000000201,990000000000202,990000000000203,990000000002001,990000000002002,990000000002003,990000000002004,990000000002005,990000000002006,990000000002007,990000000002008,990000000002009,990000000002010,990000000002011,990000000002012,990000000002013,990000000002014,990000000002015,990000000002016,990000000002017,990000000002018,990000000002019,990000000002020,990000000002021,990000000002022,990000000002023,990000000002024,990000000002025,990000000002027,990000000002028,990000000002030,990000000002031,990000000002033,990000000002034,990000000002038,990000000002039,990000000002040,990000000002041) => Error message request size limit exceeded We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit. |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Commented by: @dyemanov The problem here is that the optimizer adds hidden casts for better matching indices. And this is done for the every available index. But if matching fails, these casts remain alive and consume request's static memory, even although they're not going to be used during the query execution. This approach should be reworked, as now it explodes the request memory consumption from ~100KB to ~10MB. |
Commented by: Alex Kurov (alex.kurov) Do you have any plans for reworking this feature?) |
Commented by: @dyemanov Yes, it's in the work already. |
Commented by: @dyemanov Please try the fresh snapshot build (33242). |
Modified by: @asfernandes |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0.6 [ 10889 ] Fix Version: 4.0 Beta 2 [ 10888 ] |
Submitted by: Alex Kurov (alex.kurov)
Is related to CORE6246
Attachments:
core-6216.sql
Error message
request size limit exceeded
GDSCODE = 335544382
SQLCODE = -901
We've came across this message when using 2.5 and we thought that it is because of the SQL statement size limit.
But we still see it in 3.0 (http://www.firebirdfaq.org/faq197/).
And we get this message executing statements with length less than 64k.
We've tried to reproduce such behavior on a test example and came to conclusion,
that the error is rased when you combine using IN operator and select statement from a table with large number of indicies.
It is very strange, so we created test example with one table and 20 indicies and got an error when selecting non indexed field from the table.
If we decrease the number of indicies then the error will disapear.
Commits: dd1c155 dbd9b09 FirebirdSQL/fbt-repository@9622117
The text was updated successfully, but these errors were encountered: