-
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
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)
- is depended on by
-
SERVER-91110 Add project coalescing query property tests
- Closed
- is related to
-
SERVER-91404 Randomize property tester in waterfall
- Open
-
SERVER-94718 Create a property-based test to assert that all plan rejected plans return the same results as the winning plan
- Open
- 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 query property tester to cover more queries
- Open