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

    XMLWordPrintableJSON

Details

    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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:
              2 years, 20 weeks, 6 days ago