Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-17853

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Backlog
    • Major - P3
    • Resolution: Unresolved
    • None
    • None
    • Index Maintenance, Querying
    • Query Optimization

    Description

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

      • $exists (true only)
      • $gt, $gte, $lt, $lte
      • $eq
      • $type
      • $and (top-level only)

      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.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-22194 partialFilterExpression error - Index with pattern {...} already exists with different options

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-26405 Query planner does not consider $elemMatch criteria to select partial index

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-17858 Partial indexes should support more complex queries

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-32540 Make partial index subset analysis consider $elemMatch object a subset of $exists

          • Major - P3 - Major loss of function.
          • Backlog

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-18884 Allow $in to be specified in partial index document filter

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              Votes:
              37 Vote for this issue
              Watchers:
              52 Start watching this issue

              Dates

                Created:
                Updated: