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

Projections should not disqualify simple equality predicates from Express

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • None
    • 3
    • 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:
            Unassigned Unassigned
            Reporter:
            colin.stolley@mongodb.com Colin Stolley
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: