-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: 3.1.7
-
Component/s: Index Maintenance, Querying
-
None
-
Query Optimization
-
(copied to CRM)
As of 3.1.7, a partialFilterExpression of {field: {$type: 'number'}} only supports the following queries:
{field: {$type: 'number'}} {field: {$type: 'number'}, anotherField: ...}
An improvement could be made to answer the following class of queries:
// Comparison operations involving numbers {field: 10} {field: {$lt: 20}} {field: {$in: [30, 40, 50]}} // $type queries for double, int, and long. {field: {$type: 'int'}} {field: {$type: 1}}
- is related to
-
SERVER-29445 Support additional queries with partial indexes when type is string
- Backlog
-
SERVER-18819 Allow $type to support type values as string names
- Closed
-
SERVER-19243 Allow $type to support "number" as type value
- Closed