-
Type:
New Feature
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
-
Fully Compatible
-
QE 2024-04-29, QE 2024-05-13, QE 2024-05-27, QE 2024-06-10, QE 2024-06-24
-
None
-
None
-
None
-
None
-
None
-
None
-
None
We've caught some bugs by running random combinations of pre-written agg pipeline stages and comparing results with different knobs and feature flags. These pipeline stages are simple, to contrast with the complicated stages that the other fuzzers create. This will find the "glaring" issues more efficiently compared to other fuzzers
Issues found:
SERVER-88932 (plan cache bug)
SERVER-87961 (TS rewrite bug)
SERVER-88072 (TS bucket unpacker)
SERVER-87523 (SBE stage builder)
SERVER-88418 (block processing $group accumulator)
SERVER-89061 (plan cache key)
SERVER-90476 (wildcard indexes)
SERVER-90833 (TS bounded sorter)
SERVER-90995 (TS dependency tracking)
SERVER-91405 (agg stage optimizations, specifically for $project)
SERVER-91573 (agg stage optimization, for $match and $addFields)
SERVER-91757 (hashed indexes)
SERVER-91784 ($addFields $project issue, CA candidate)
SERVER-92824 (pipeline rewrite)
SERVER-93874 (block-processing/TS buckets bug)
SERVER-94017 (bounded sorter/TS bucket bug)
SERVER-94207 (TS correctness)
SERVER-99768 (bounded sorter/wildcard indexes)
SERVER-99889 (hashed indexes in SBE)
SERVER-100299 ($limit not obeyed, CA candidate)
SERVER-101007 ($elemMatch)
SERVER-101257 (rooted $or query, distinct scan logic tassert)
SERVER-101260 (SBE $elemMatch correctness issue)
SERVER-101271 (time-series/block-processing nondeterministic correctness issue)
SERVER-101795 (times-series nested $elemMatch)
SERVER-102075 (distinct scan/isCached explain field)
SERVER-102229 (sbe/time-series server crash)
SERVER-102825 (partial index/plan cache correctness issue)
SERVER-103724 (sharding/doc source rewrite issue)
SERVER-103774 (sharding/wildcard index correctness)
SERVER-104101 (SBE hash intersection)
- is depended on by
-
SERVER-91110 Add project coalescing query property tests
-
- Closed
-
- is related to
-
SERVER-99889 Covering hashed index on fields that share path prefix can return incorrect results in SBE
-
- Open
-
-
SERVER-101260 $elemMatch with dotted field compared to null returns incorrect results when using SBE
-
- Open
-
-
SERVER-101795 Timeseries query with nested $elemMatch incorrectly uasserts
-
- Backlog
-
-
SERVER-101007 $or followed by always false $elemMatch can fail pipeline optimization
-
- In Progress
-
-
SERVER-87523 $match on meta followed by block-based group can trip tassert
-
- Closed
-
-
SERVER-87961 Time series $group rewrite may produce incorrect results when a preceding $project stage projects out accessed fields
-
- Closed
-
-
SERVER-88072 Timeseries query errors instead of producing a correct response
-
- Closed
-
-
SERVER-88418 Block $top/bottom doesn't break ties with _id correctly
-
- Closed
-
-
SERVER-88932 Running a query that uses the plan cache can tassert
-
- Closed
-
-
SERVER-89061 Queries where agg pipeline is pushed to SBE may multiplan every time
-
- Closed
-
-
SERVER-90476 Query using wildcard index can return incorrect results when comparing to null on non-existent field
-
- Closed
-
-
SERVER-90833 Fix incorrect bounded sort optimization when time field is renamed by $addFields
-
- Closed
-
-
SERVER-90995 Shadowing metaField should not be considered as a "computed" meta field
-
- Closed
-
-
SERVER-91405 $project coalescing can incorrectly cause queries to error
-
- Closed
-
-
SERVER-91573 $match pushed before $addFields can lead to incorrect results
-
- Closed
-
-
SERVER-91757 Hashed index used to cover nested field can return wrong results
-
- Closed
-
-
SERVER-91784 $project-$addFields on arrays can produce incorrect results
-
- Closed
-
-
SERVER-92824 $addFields-$match rewrite on dotted path can produce incorrect results
-
- Closed
-
-
SERVER-93874 $group on time-series collections can produce rounded results due to bucket control rounding
-
- Closed
-
-
SERVER-94017 Bounded sorter can incorrectly uassert for pre-1970 dates
-
- Closed
-
-
SERVER-94207 Time-series $match on dates before 1970 can miss documents
-
- Closed
-
-
SERVER-100299 sort-skip-limit may return more documents than limit specifies
-
- Closed
-
-
SERVER-101271 Timeseries query can erroneously include excluded fields after including the meta field
-
- Closed
-
-
SERVER-102825 Queries using partial indexes with $or filter can return incorrect results when cache entry exists
-
- Closed
-
-
SERVER-99768 Queries on a timeseries collection with a wildcard index can incorrectly uassert
-
- Investigating
-
-
SERVER-102075 "isCached" in explain can be true for more than one plan when using distinct scan
-
- Investigating
-
-
SERVER-103724 $sort-$project query on a sharded collection can assert on merging node
-
- Investigating
-
-
SERVER-103774 Disallow compound wildcard indexes from being used as a shard key index
-
- Needs Scheduling
-
-
SERVER-104101 SBE hash intersection can miss documents
-
- Needs Scheduling
-
-
SERVER-91404 Randomize property tester in waterfall
-
- Closed
-
-
SERVER-94718 Create a property-based test to assert that hinting all indexes returns the same results
-
- Closed
-
- related to
-
SERVER-87523 $match on meta followed by block-based group can trip tassert
-
- Closed
-
-
SERVER-87961 Time series $group rewrite may produce incorrect results when a preceding $project stage projects out accessed fields
-
- Closed
-
-
SERVER-88072 Timeseries query errors instead of producing a correct response
-
- Closed
-
-
SERVER-88418 Block $top/bottom doesn't break ties with _id correctly
-
- Closed
-
-
SERVER-88932 Running a query that uses the plan cache can tassert
-
- Closed
-
-
SERVER-89061 Queries where agg pipeline is pushed to SBE may multiplan every time
-
- Closed
-
-
SERVER-90476 Query using wildcard index can return incorrect results when comparing to null on non-existent field
-
- Closed
-
-
SERVER-90833 Fix incorrect bounded sort optimization when time field is renamed by $addFields
-
- Closed
-
-
SERVER-89033 Create plan cache targeted fuzzer-like test
-
- Closed
-
-
SERVER-91164 Expand core PBT model to cover more queries
-
- Closed
-