Projections should not disqualify simple equality predicates from Express

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • Fully Compatible
    • QE 2025-07-07, QE 2025-07-21, QE 2025-08-04, QE 2025-08-18
    • 0
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The following does not use EXPRESS_IX_SCAN:

      db.bar.insertOne({_id: 1, a: 1, b: 2})
db.bar.createIndex({a: 1}, {unique: true})
db.bar.find({a:1}, {b:1})

      isEqualityExpressEligibleQuery() disqualifies queries if they contain any projection at all, which seems unnecessary. Simple projections should be permitted, just as they are for _id predicates.

              Assignee:
              Ivan Fefer
              Reporter:
              Colin Stolley
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: