Details
-
Bug
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Fully Compatible
-
ALL
-
QO 2023-01-23
Description
The query
{$match: {"chi2_int_10000000_1000" :
{ "$gt" : 4017000, "$lt" : 4018000}}}
over ce_data_100000 collection from CE accuracy tests fails with invalid cardinality estimate.
To reproduce:
0) Run data generator
1) Load CE accuracy data executing the commands from jstests/query_golden/load_data.js
2) Run the query
load("jstests/libs/ce_stats_utils.js"); |
load("jstests/libs/optimizer_utils.js"); |
load("jstests/query_golden/libs/run_queries_ce.js"); |
|
let collMeta = dbMetadata[3]; // check the collection is ce_data_100000 |
let collName = collMeta.collectionName;
|
let coll = testDB[collName];
|
let testCase = {_id: 0, pipeline: [{$match: {"chi2_int_10000000_1000" : { "$gt" : 4017000, "$lt" : 4018000} |
}}], "dtype": "int", "qtype" : "$gt"}; |
let strategy = "histogram"; |
forceCE(strategy); runAggregationWithCE(coll, testCase, strategy);
|
Attachments
Issue Links
- is related to
-
SERVER-73033 Improve sparse histogram bucket equality estimate
-
- Backlog
-