[SERVER-6293] Index only query fills in missing values with null - MongoDB

XML

Word

Printable

> db.bar.drop()

false

> db.bar.insert({_id:1})

> db.bar.insert({_id:2})

> db.bar.find({x:null}, {_id:1, x:1})

{ "_id" : 1 }

{ "_id" : 2 }

> db.bar.ensureIndex({x:1, _id:1})

> db.bar.find({x:null}, {_id:1, x:1})

{ "x" : null, "_id" : 1 }

{ "x" : null, "_id" : 2 }

duplicates

SERVER-23229 Projection incorrectly returns null value instead of missing field to user if projection is covered

is related to

SERVER-23229 Projection incorrectly returns null value instead of missing field to user if projection is covered

SERVER-5580 covered indexes are improperly applied when arrays do not have multiple values

SERVER-11833 Projected field order different under new query framework

SERVER-12056 hint() is not respected in find()

related to

SERVER-4529 fast count mode should not be used when matching against null

SERVER-12869 Index null values and missing values differently

(2 related to)