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

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

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Indexing, Querying
    • Labels:

      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

            Activity

              People

              Assignee:
              backlog-query-optimization Backlog - Query Optimization
              Reporter:
              rassi J Rassi
              Participants:
              Votes:
              30 Vote for this issue
              Watchers:
              43 Start watching this issue

                Dates

                Created:
                Updated: