sparse indexes break $exists query

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: 2.0.2
    • Component/s: Index Maintenance, Querying
    • None
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Adding a sparse index breaks $exists queries on that field.

      Sample console session:

      use bug
// switched to db bug
db.bug.insert({a: 1})
db.bug.ensureIndex({b: 1}, {sparse: true})
db.bug.find({b: {$exists: false}})
// no result!
db.bug.find({b: {$exists: false}}).hint({$natural: 1})
// { "_id" : ObjectId("4f0c337f3715b68266d07790"), "a" : 1 }

            Assignee:
            Unassigned
            Reporter:
            Colin Howe
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: