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

Query's projection does not obey partial inclusion or exclusion of _id

    • Minor Change
    • ALL
    • Query 2019-11-04
    • None
    • 0
    • None
    • None
    • None
    • None
    • None
    • None

      > db.a.find()
      { "_id" : { "a" : 1, "b" : 1 }, "v" : 123 }
      { "_id" : { "a" : 1, "b" : 2 }, "v" : 345 }
      { "_id" : { "a" : 2, "b" : 2 }, "v" : 222 }
      { "_id" : { "a" : 2, "b" : 1 }, "v" : 567 }
      > db.a.find({}, {'_id.a':1})  // Should only include "_id.a".
      { "_id" : { "a" : 1, "b" : 1 } }
      { "_id" : { "a" : 1, "b" : 2 } }
      { "_id" : { "a" : 2, "b" : 2 } }
      { "_id" : { "a" : 2, "b" : 1 } }
      > db.a.find({}, { '_id.b':0})  // Should exclude "_id.b".
      { "_id" : { "a" : 1, "b" : 1 }, "v" : 123 }
      { "_id" : { "a" : 1, "b" : 2 }, "v" : 345 }
      { "_id" : { "a" : 2, "b" : 2 }, "v" : 222 }
      { "_id" : { "a" : 2, "b" : 1 }, "v" : 567 }
      

            Assignee:
            ian.boros@mongodb.com Ian Boros
            Reporter:
            mathias@mongodb.com Mathias Stearn
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: