-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Querying
-
Query Execution
-
Fully Compatible
-
QE 2023-05-15, QE 2023-05-29, QE 2023-06-12
-
1
When I tried to run the "bestbuy_agg_query_comparison.js" benchmark (fromĀ https://github.com/10gen/workloads) with useAgg=true and with SBE mode enabled, the benchmark failed with an error message saying "Can't build exec tree for node: COUNT".
I've created a simple example that reproduces the failure:
> db.adminCommand({setParameter:1, internalQueryEnableSlotBasedExecutionEngine:true}); > db.c.insert({a: 1}) > db.c.createIndex({a: 1}) > db.c.aggregate([{$match: {a: 1}}, {$count: "count"}]).itcount();
The goal of this task is to implement support for the COUNT stage so that these kinds of queries work correctly when SBE mode is enabled.
- depends on
-
SERVER-77203 Classic Group should not use DoubleDoubleSummation for count
- Closed
- duplicates
-
SERVER-51823 Use classic engine to evaluate queries containing expressions not supported in SBE
- Closed
- is depended on by
-
SERVER-76815 Parameterize COUNT_SCAN index keys in SBE
- Closed
-
SERVER-77973 Do not gate COUNT_SCAN in SBE by featureFlagSbeFull
- Closed
- is related to
-
SERVER-51655 Investigate sys-perf benchmark performance in SBE
- Closed
-
SERVER-70617 Allow use of column indexes for count queries
- Closed