Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-38164

$or pushdown optimization does not correctly handle $not within an $elemMatch

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical - P2
    • Resolution: Fixed
    • Affects Version/s: 3.6.0, 4.0.0, 4.1.5
    • Fix Version/s: 3.6.10, 4.0.5, 4.1.7
    • Component/s: Querying
    • Labels:
    • Backwards Compatibility:
      Fully Compatible
    • Operating System:
      ALL
    • Backport Requested:
      v4.0, v3.6
    • Sprint:
      Query 2018-12-03, Query 2018-12-17
    • Case:

      Description

      For queries with an indexed $or predicate and an $elemMatch containing a $not predicate, the query planner can recognize when the indexed $or may benefit from the $elemMatch's $not predicate, but fails to propagate that information back to the $or index bounds after recognizing this.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: