Indexscan returns empty result for some in-lists with more than 1024 values on systems with many cpu cores
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15149 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0 |
| Fix Versions | Exasol 7.0.20, Exasol 7.1.13, Exasol 8.2.0 |
| Resolution Date | 2022-08-12 |
Description
A query may return an empty result if
- it runs on a system with at least 205 cpu cores per node (a typical system would then have 256 cores)
- it has an IN-list on a column
- there is an index on the column for the IN-list
- the IN-list contains more than 1024 and less than 5*<nr_of_cpu_cores> values
Note: The problem only occurs if the table is selected as SCAN-table (see profiling) and the IN-condition and index are selected for indexscan.
Preparation
create table t( i int); insert into t (select * from values between 1 and 200000); enforce index on t(i);
Example
-- no results for 1025 values select * from t where i in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024 ,1025 ); -- but 1024 still work very well select * from t where i in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024 --,1025 );
Workaround
Add additional (out of range) values to the IN-List to get beyond the 5*<nr_of_cpu_cores> limit.
select * from t where i in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025, -- out of range values -999999999,-999999998,-999999997,-999999996,-999999995,-999999994,-999999993,-999999992,-999999991,-999999990,-999999989,-999999988,-999999987,-999999986,-999999985,-999999984,-999999983,-999999982,-999999981,-999999980,-999999979,-999999978,-999999977,-999999976,-999999975,-999999974,-999999973,-999999972,-999999971,-999999970,-999999969,-999999968,-999999967,-999999966,-999999965,-999999964,-999999963,-999999962,-999999961,-999999960,-999999959,-999999958,-999999957,-999999956,-999999955,-999999954,-999999953,-999999952,-999999951,-999999950,-999999949,-999999948,-999999947,-999999946,-999999945,-999999944,-999999943,-999999942,-999999941,-999999940,-999999939,-999999938,-999999937,-999999936,-999999935,-999999934,-999999933,-999999932,-999999931,-999999930,-999999929,-999999928,-999999927,-999999926,-999999925,-999999924,-999999923,-999999922,-999999921,-999999920,-999999919,-999999918,-999999917,-999999916,-999999915,-999999914,-999999913,-999999912,-999999911,-999999910,-999999909,-999999908,-999999907,-999999906,-999999905,-999999904,-999999903,-999999902,-999999901,-999999900,-999999899,-999999898,-999999897,-999999896,-999999895,-999999894,-999999893,-999999892,-999999891,-999999890,-999999889,-999999888,-999999887,-999999886,-999999885,-999999884,-999999883,-999999882,-999999881,-999999880,-999999879,-999999878,-999999877,-999999876,-999999875,-999999874,-999999873,-999999872,-999999871,-999999870,-999999869,-999999868,-999999867,-999999866,-999999865,-999999864,-999999863,-999999862,-999999861,-999999860,-999999859,-999999858,-999999857,-999999856,-999999855,-999999854,-999999853,-999999852,-999999851,-999999850,-999999849,-999999848,-999999847,-999999846,-999999845,-999999844,-999999843,-999999842,-999999841,-999999840,-999999839,-999999838,-999999837,-999999836,-999999835,-999999834,-999999833,-999999832,-999999831,-999999830,-999999829,-999999828,-999999827,-999999826,-999999825,-999999824,-999999823,-999999822,-999999821,-999999820,-999999819,-999999818,-999999817,-999999816,-999999815,-999999814,-999999813,-999999812,-999999811,-999999810,-999999809,-999999808,-999999807,-999999806,-999999805,-999999804,-999999803,-999999802,-999999801,-999999800,-999999799,-999999798,-999999797,-999999796,-999999795,-999999794,-999999793,-999999792,-999999791,-999999790,-999999789,-999999788,-999999787,-999999786,-999999785,-999999784,-999999783,-999999782,-999999781,-999999780,-999999779,-999999778,-999999777,-999999776,-999999775,-999999774,-999999773,-999999772,-999999771,-999999770,-999999769,-999999768,-999999767,-999999766,-999999765,-999999764,-999999763,-999999762,-999999761,-999999760,-999999759,-999999758,-999999757,-999999756,-999999755,-999999754,-999999753,-999999752,-999999751,-999999750,-999999749,-999999748,-999999747,-999999746,-999999745,-999999744,-999999743,-999999742,-999999741,-999999740,-999999739,-999999738,-999999737,-999999736,-999999735,-999999734,-999999733,-999999732,-999999731,-999999730,-999999729,-999999728,-999999727,-999999726,-999999725,-999999724,-999999723,-999999722,-999999721,-999999720,-999999719,-999999718,-999999717,-999999716,-999999715,-999999714,-999999713,-999999712,-999999711,-999999710,-999999709,-999999708,-999999707,-999999706,-999999705,-999999704,-999999703,-999999702,-999999701,-999999700,-999999699,-999999698,-999999697,-999999696,-999999695,-999999694,-999999693,-999999692,-999999691,-999999690,-999999689,-999999688,-999999687,-999999686,-999999685,-999999684,-999999683,-999999682,-999999681,-999999680,-999999679,-999999678,-999999677,-999999676,-999999675,-999999674,-999999673,-999999672,-999999671,-999999670,-999999669,-999999668,-999999667,-999999666,-999999665,-999999664,-999999663,-999999662,-999999661,-999999660,-999999659,-999999658,-999999657,-999999656,-999999655,-999999654,-999999653,-999999652,-999999651,-999999650,-999999649,-999999648,-999999647,-999999646,-999999645,-999999644,-999999643,-999999642,-999999641,-999999640,-999999639,-999999638,-999999637,-999999636,-999999635,-999999634,-999999633,-999999632,-999999631,-999999630,-999999629,-999999628,-999999627,-999999626,-999999625,-999999624,-999999623,-999999622,-999999621,-999999620,-999999619,-999999618,-999999617,-999999616,-999999615,-999999614,-999999613,-999999612,-999999611,-999999610,-999999609,-999999608,-999999607,-999999606,-999999605,-999999604,-999999603,-999999602,-999999601,-999999600,-999999599,-999999598,-999999597,-999999596,-999999595,-999999594,-999999593,-999999592,-999999591,-999999590,-999999589,-999999588,-999999587,-999999586,-999999585,-999999584,-999999583,-999999582,-999999581,-999999580,-999999579,-999999578,-999999577,-999999576,-999999575,-999999574,-999999573,-999999572,-999999571,-999999570,-999999569,-999999568,-999999567,-999999566,-999999565,-999999564,-999999563,-999999562,-999999561,-999999560,-999999559,-999999558,-999999557,-999999556,-999999555,-999999554,-999999553,-999999552,-999999551,-999999550,-999999549,-999999548,-999999547,-999999546,-999999545,-999999544,-999999543,-999999542,-999999541,-999999540,-999999539,-999999538,-999999537,-999999536,-999999535,-999999534,-999999533,-999999532,-999999531,-999999530,-999999529,-999999528,-999999527,-999999526,-999999525,-999999524,-999999523,-999999522,-999999521,-999999520,-999999519,-999999518,-999999517,-999999516,-999999515,-999999514,-999999513,-999999512,-999999511,-999999510,-999999509,-999999508,-999999507,-999999506,-999999505,-999999504,-999999503,-999999502,-999999501,-999999500,-999999499,-999999498,-999999497,-999999496,-999999495,-999999494,-999999493,-999999492,-999999491,-999999490,-999999489,-999999488,-999999487,-999999486,-999999485,-999999484,-999999483,-999999482,-999999481,-999999480,-999999479,-999999478,-999999477,-999999476,-999999475,-999999474,-999999473,-999999472,-999999471,-999999470,-999999469,-999999468,-999999467,-999999466,-999999465,-999999464,-999999463,-999999462,-999999461,-999999460,-999999459,-999999458,-999999457,-999999456,-999999455,-999999454,-999999453,-999999452,-999999451,-999999450,-999999449,-999999448,-999999447,-999999446,-999999445,-999999444,-999999443,-999999442,-999999441,-999999440,-999999439,-999999438,-999999437,-999999436,-999999435,-999999434,-999999433,-999999432,-999999431,-999999430,-999999429,-999999428,-999999427,-999999426,-999999425,-999999424,-999999423,-999999422,-999999421,-999999420,-999999419,-999999418,-999999417,-999999416,-999999415,-999999414,-999999413,-999999412,-999999411,-999999410,-999999409,-999999408,-999999407,-999999406,-999999405,-999999404,-999999403,-999999402,-999999401,-999999400,-999999399,-999999398,-999999397,-999999396,-999999395,-999999394,-999999393,-999999392,-999999391,-999999390,-999999389,-999999388,-999999387,-999999386,-999999385,-999999384,-999999383,-999999382,-999999381,-999999380,-999999379,-999999378,-999999377,-999999376,-999999375,-999999374,-999999373,-999999372,-999999371,-999999370,-999999369,-999999368,-999999367,-999999366,-999999365,-999999364,-999999363,-999999362,-999999361,-999999360,-999999359,-999999358,-999999357,-999999356,-999999355,-999999354,-999999353,-999999352,-999999351,-999999350,-999999349,-999999348,-999999347,-999999346,-999999345,-999999344,-999999343,-999999342,-999999341,-999999340,-999999339,-999999338,-999999337,-999999336,-999999335,-999999334,-999999333,-999999332,-999999331,-999999330,-999999329,-999999328,-999999327,-999999326,-999999325,-999999324,-999999323,-999999322,-999999321,-999999320,-999999319,-999999318,-999999317,-999999316,-999999315,-999999314,-999999313,-999999312,-999999311,-999999310,-999999309,-999999308,-999999307,-999999306,-999999305,-999999304,-999999303,-999999302,-999999301,-999999300,-999999299,-999999298,-999999297,-999999296,-999999295,-999999294,-999999293,-999999292,-999999291,-999999290,-999999289,-999999288,-999999287,-999999286,-999999285,-999999284,-999999283,-999999282,-999999281,-999999280,-999999279,-999999278,-999999277,-999999276,-999999275,-999999274,-999999273,-999999272,-999999271,-999999270,-999999269,-999999268,-999999267,-999999266,-999999265,-999999264,-999999263,-999999262,-999999261,-999999260,-999999259,-999999258,-999999257,-999999256,-999999255,-999999254,-999999253,-999999252,-999999251,-999999250,-999999249,-999999248,-999999247,-999999246,-999999245,-999999244,-999999243,-999999242,-999999241,-999999240,-999999239,-999999238,-999999237,-999999236,-999999235,-999999234,-999999233,-999999232,-999999231,-999999230,-999999229,-999999228,-999999227,-999999226,-999999225,-999999224,-999999223,-999999222,-999999221,-999999220,-999999219,-999999218,-999999217,-999999216,-999999215,-999999214,-999999213,-999999212,-999999211,-999999210,-999999209,-999999208,-999999207,-999999206,-999999205,-999999204,-999999203,-999999202,-999999201,-999999200,-999999199,-999999198,-999999197,-999999196,-999999195,-999999194,-999999193,-999999192,-999999191,-999999190,-999999189,-999999188,-999999187,-999999186,-999999185,-999999184,-999999183,-999999182,-999999181,-999999180,-999999179,-999999178,-999999177,-999999176,-999999175,-999999174,-999999173,-999999172,-999999171,-999999170,-999999169,-999999168,-999999167,-999999166,-999999165,-999999164,-999999163,-999999162,-999999161,-999999160,-999999159,-999999158,-999999157,-999999156,-999999155,-999999154,-999999153,-999999152,-999999151,-999999150,-999999149,-999999148,-999999147,-999999146,-999999145,-999999144,-999999143,-999999142,-999999141,-999999140,-999999139,-999999138,-999999137,-999999136,-999999135,-999999134,-999999133,-999999132,-999999131,-999999130,-999999129,-999999128,-999999127,-999999126,-999999125,-999999124,-999999123,-999999122,-999999121,-999999120,-999999119,-999999118,-999999117,-999999116,-999999115,-999999114,-999999113,-999999112,-999999111,-999999110,-999999109,-999999108,-999999107,-999999106,-999999105,-999999104,-999999103,-999999102,-999999101,-999999100,-999999099,-999999098,-999999097,-999999096,-999999095,-999999094,-999999093,-999999092,-999999091,-999999090,-999999089,-999999088,-999999087,-999999086,-999999085,-999999084,-999999083,-999999082,-999999081,-999999080,-999999079,-999999078,-999999077,-999999076,-999999075,-999999074,-999999073,-999999072,-999999071,-999999070,-999999069,-999999068,-999999067,-999999066,-999999065,-999999064,-999999063,-999999062,-999999061,-999999060,-999999059,-999999058,-999999057,-999999056,-999999055,-999999054,-999999053,-999999052,-999999051,-999999050,-999999049,-999999048,-999999047,-999999046,-999999045,-999999044,-999999043,-999999042,-999999041,-999999040,-999999039,-999999038,-999999037,-999999036,-999999035,-999999034,-999999033,-999999032,-999999031,-999999030,-999999029,-999999028,-999999027,-999999026,-999999025,-999999024,-999999023,-999999022,-999999021,-999999020,-999999019,-999999018,-999999017,-999999016,-999999015,-999999014,-999999013,-999999012,-999999011,-999999010,-999999009,-999999008,-999999007,-999999006,-999999005,-999999004,-999999003,-999999002,-999999001,-999999000 );
Fix
The query returns the correct result.
