-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
None
-
Affects Version/s: 6.0.3
-
Component/s: None
-
None
-
Fully Compatible
-
ALL
-
-
QE 2023-01-23
-
120
A $match filter can be pushed past a $project into a COLLSCAN only if the $project has no impact on the filter results. For this to be true, the $match filters' paths must be a subset of the $project paths. This check seems to be broken in v6.0.
This ticket came out of rui.liu@mongodb.com's investigation of BF-27387.
This issue is only seen in v6.0 because it was fixed for 6.1.0-rc0 by a change to isIndependentOf in SERVER-67416. To fix this bug in v6.0 we can try to backport SERVER-67416. This ticket may also track work to add a js test for this bug.
v5.0 does not exhibit this bug.
- depends on
-
SERVER-67416 Always sort fieldpath string sets using custom comparator
- Closed