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

      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.)

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

              Created:
              Updated:
              Resolved:
              2 years, 32 weeks, 1 day ago