Loading...

XML

Word

Printable

JSON

The 3.1.1 version of partial indexes supports document filters composed using the following query operators:

Users should be able to create partial indexes with more complex expressions for the document filter. We should consider allowing the following:

$or
$elemMatch
$geoWithin
'false' as a value for $exists
multiple levels for $and (simple normalization, unless other logical operators introduced)
$ne and $not

Support for $in and $regex is being tracked in ~~SERVER-18884~~.

is duplicated by

SERVER-22194 partialFilterExpression error - Index with pattern {...} already exists with different options

SERVER-26405 Query planner does not consider $elemMatch criteria to select partial index

is related to

SERVER-17858 Partial indexes should support more complex queries

related to

SERVER-32540 Make partial index subset analysis consider $elemMatch object a subset of $exists

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

Assignee:: [DO NOT USE] Backlog - Query Optimization
Reporter:: J Rassi (Inactive)
Participants:: [DO NOT USE] Backlog - Query Optimization, Anas Mansouri, Asya Kamsky, Jeffrey Johnson, João França, J Rassi, Marc Knaup, Mike Zraly, Nikolay Symotiyk, Sam Peretz, Vishal Turi
Votes:: 39 Vote for this issue
Watchers:: 55 Start watching this issue