Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-14281

Investigate changes in SERVER-25023: no way to index the same fields with two different partial index filters

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.7.0
    • Component/s: manual, Server
    • Labels:
      None
    • Last comment by Customer:
      true
    • Story Points:
      3
    • Sprint:
      ServerDocs2020: Mar16 - Mar23, ServerDocs2020: Mar23 - Mar30, ServerDocs2020: Mar30 - Apr06, ServerDocs2020: Apr6 - Apr13, ServerDocs2020: Apr13 - Apr20

      Description

      Description

      Downstream Change Summary

      As of this change, users can now create multiple partial indexes on the same key pattern so long as the partialFilterExpression fields do not express equivalent filters.

      Description of Linked Ticket

      If I have a large data set, I might want to create several indexes on it, each index covering only a subset of the full set of documents. Currently that's not allowed because we don't allow same pattern with different options, and filter is part of the options.

      Scope of changes

      Review and update the partial index restrictions in accordance with this new behavior. https://docs.mongodb.com/manual/core/index-partial/#restrictions

      Impact to Other Docs

      MVP (Work and Date)

      Resources (Scope or Design Docs, Invision, etc.)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ian.fogelman Ian Fogelman
              Reporter:
              backlog-server-pm Backlog - Core Eng Program Management Team
              Participants:
              Last commenter:
              Ian Fogelman Ian Fogelman
              Docs Reviewer:
              Joseph Dougherty Joseph Dougherty
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since reply:
                5 weeks, 2 days ago
                Date of 1st Reply: