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

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 4.7.0
    • manual, Server
    • None
    • 3
    • ServerDocs2020: Mar16 - Mar23, ServerDocs2020: Mar23 - Mar30, ServerDocs2020: Mar30 - Apr06, ServerDocs2020: Apr6 - Apr13, ServerDocs2020: Apr13 - Apr20
    • true

    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

              ian.fogelman@mongodb.com Ian Fogelman
              backlog-server-pm Backlog - Core Eng Program Management Team
              Ian Fogelman Ian Fogelman
              Joseph Dougherty Joseph Dougherty
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                47 weeks, 4 days ago