Support additional queries with $type=number partial indexes

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: 3.1.7
    • Component/s: Index Maintenance, Querying
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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}}

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Max Hirschhorn
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: