Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
3.1.7
-
None
-
Query Optimization
-
(copied to CRM)
Description
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}}
|
Attachments
Issue Links
- 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
-