Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
1
-
Other/not scored
Description
Here are some example queries
SELECT x.u016_i FROM KS2 x WHERE ANY v IN uarr_n satisfies v = 100000 END
SELECT x.u016_i FROM KS2 x WHERE ANY v IN rarr_n satisfies v = 0 END;
SELECT x.u016_i FROM KS2 x WHERE ANY v IN rarr_n satisfies v = 100000 END
SELECT x.u016_i FROM KS2 x WHERE ANY v IN rarr_n satisfies v <= 0 END
0 and 100000 are "extreme" values are not found in the arrays.
KS2 has 100000 documents, uarr_n and rarr_n each contain an array with length between 0-10 and values in range of 0-100000, not including 0 or 100000.
UPDATE STATISTICS has been run on the array:
UPDATE STATISTICS for KS2 (DISTINCT uarr_n, DISTINCT rarr_n);
Attachments
For Gerrit Dashboard: MB-40397 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
132330,2 | MB-40397 Treat 0.0 as valid selectivity from histogram | master | query-ee | Status: MERGED | +2 | +1 |
132386,2 | MB-40397 Avoid selectivity of 0.0 from calcArraySel (use MIN_SELEC instead) | master | query-ee | Status: MERGED | +2 | +1 |