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

collection.getIndexes() should display multikey metadata

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • 3.4.0, 3.6.0
    • Querying
    • None
    • Query

    Description

      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

      Attachments

        Activity

          People

            backlog-server-query Backlog - Query Team (Inactive)
            adamaharrison@gmail.com Adam Harrison
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: