SERVER-60191 Disable $group pushdown to SBE when $match with $or exists

1 files changed, 8 insertions, 1 deletions

diff --git a/src/mongo/db/pipeline/pipeline_d.cpp b/src/mongo/db/pipeline/pipeline_d.cpp
index ef13b96077f..56e0bcff2cf 100644
--- a/src/mongo/db/pipeline/pipeline_d.cpp
+++ b/src/mongo/db/pipeline/pipeline_d.cpp
@@ -109,6 +109,7 @@ namespace {
  *       collection. This case is necessary because we don't currently support extending the
  *       QuerySolution with the 'postMultiPlan' QuerySolutionNode when the PlanCache is involved in
  *       the query. This will be resolved when SERVER-58429 is complete.
+ *    3. $match stage does not have $or and thus, does not need subplanning.
  */
 std::vector<std::unique_ptr<InnerPipelineStageInterface>> extractSbeCompatibleGroupsForPushdown(
     const intrusive_ptr<ExpressionContext>& expCtx,
@@ -119,6 +120,12 @@ std::vector<std::unique_ptr<InnerPipelineStageInterface>> extractSbeCompatibleGr
     // which requires stages to be wrapped in an interface.
     std::vector<std::unique_ptr<InnerPipelineStageInterface>> groupsForPushdown;
 
+    // In case that we have a top $or for $match stage, it triggers the tripwire assertion 5842500
+    // because subplanning does not expect that the base query has pushed down $group stage(s) but
+    // it does when $group stage exist in pipeline.
+    // TODO SERVER-60197: Remove this check after supporting this scenario.
+    auto queryNeedsSubplanning = cq->getQueryObj().hasField("$or");
+
     // This handles the case of unionWith against an unknown collection.
     if (collection == nullptr) {
         return {};
@@ -135,7 +142,7 @@ std::vector<std::unique_ptr<InnerPipelineStageInterface>> extractSbeCompatibleGr
     if (!feature_flags::gFeatureFlagSBEGroupPushdown.isEnabled(
             serverGlobalParams.featureCompatibility) ||
         !cq->getEnableSlotBasedExecutionEngine() || expCtx->allowDiskUse || isSharded ||
-        !isSingleIndex) {
+        !isSingleIndex || queryNeedsSubplanning) {
         return {};
     }