[SERVER-18884] Allow $in to be specified in partial index document filter - MongoDB Jira

XML

Word

Printable

JSON

Users should be able to specify the $in predicate operators as part of a partial index document filter.

For example:

db.collection.ensureIndex({a: 1}, {partialFilterExpression: {b: {$in: [1, 2, 3]}}});

db.collection.find({a: 1, b: 1}); // Should be able to use the above index.

duplicates

SERVER-59508 Support $or, $in and multi-level expressions in partial indexes

is related to

SERVER-55782 Allow $regex to be specified in partial index document filter

SERVER-17853 Allow more complex expressions to be specified in partial index document filter

related to

SERVER-59508 Support $or, $in and multi-level expressions in partial indexes

Participants:: Backlog - Query Optimization, Evtim Georgiev, James Wahlin, J Rassi, Katya Kamenieva