collection.getIndexes() should display multikey metadata

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: 3.4.0, 3.6.0
    • Component/s: Querying
    • None
    • Query
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      MongoDB 3.6 introduces compatibility changes regarding the ability of a multikey index to be used in sorting (https://jira.mongodb.org/browse/SERVER-15086). To summarize:

      In MongoDB 3.6:

      • A version 1 (or earlier) multikey index (MongoDB 3.2 and earlier) cannot be used to sort
      • A version 2 multikey index (MongoDB 3.4, 3.6) can be used to sort, provided that the sort field is not an array.

      Given the performance implications, and that the indexes already contain this information, collection.getIndexes() should:

      • Display the index metadata identifying if an index is multikey
      • If a `v: 2`, show the path level multikey data for any multikey indexes

            Assignee:
            Backlog - Query Team (Inactive)
            Reporter:
            Adam Harrison
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: