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

no way to index the same fields with two different partial index filters

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • Query 2020-03-09, Query 2020-03-23, Query 2020-04-06, Query 2020-04-20, Query 2020-05-04
    • 48

    Description

      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.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. PYTHON-2215 Test failure - test_collection.TestCollection.test_index_filter

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-52814 queryPlanner.winningPlan.inputStage is undefined for a specific query

          • Major - P3 - Major loss of function.
          • Closed
          is documented by

          Task - A task that needs to be done. DOCS-14281 Investigate changes in SERVER-25023: no way to index the same fields with two different partial index filters

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-32733 Support same index definition but with different partial filter expressions

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-34841 Cannot create multiple indexes with the same pattern but different options

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Task - A task that needs to be done. SERVER-24239 Add support for building indices with the same key pattern but different collations

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-62636 setFeatureCompatibilityVersion 4.4 succeeds on 5.0 binVersion that has indexes with conflicting options

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-47657 Add 'unique' and 'sparse' parameters to index signature

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-47659 Add 'wildcardProjection' parameter to index signature

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-67446 Ensure consistent wildcardProjection and columnstoreProjection specs in catalog

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              bernard.gorman@mongodb.com Bernard Gorman
              asya.kamsky@mongodb.com Asya Kamsky
              Votes:
              13 Vote for this issue
              Watchers:
              31 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: