Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-6511

Index suggestions in "Indexes" tab missing sparse keys

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 1.38.0
    • Affects Version/s: 1.35.0
    • Component/s: Indexes, UI / UX
    • None
    • Environment:
      mac 12.6.2
    • 5
    • Iteration Citipati, Iteration Dreadnoughtus
    • Not Needed

      Problem Statement/Rationale

      What is going wrong? What action would you like the Engineering team to take?

      Please be sure to attach relevant logs with any sensitive data redacted.

      Using Compass Schema Analyzer on the Movies database, "metacritic" key exists in sampling. However, this doesn't show up in autocomplete while creating an index in "Indexes" tab nor being able to select it.

      The checkbox for creating a sparse index exists, but the field to use it on doesn't seem possible.

      https://jira.mongodb.org/browse/COMPASS-1963

      Steps to Reproduce

      How could an engineer replicate the issue you’re reporting?

      Create a sparse index on "metacritic" score in movie database.

      Expected Results

      What do you expect to happen?

      "metacritic" to appear in dropdown if Schema Analyzer was able to discover it. or being able to type it

      A sparse index to be created

      Actual Results

      What do you observe is happening?

      No "metacritic" in autocomplete

      An error is generated if I type "metacritic" and add a checkbox to create a sparse index

      Additional Notes

      Any additional information that may be useful to include.

        1. Screen Shot 2023-02-09 at 1.12.18 PM.png
          96 kB
          Felicia Hsieh
        2. Screen Shot 2023-02-09 at 1.12.38 PM.png
          195 kB
          Felicia Hsieh
        3. Screen Shot 2023-02-09 at 1.18.27 PM.png
          185 kB
          Felicia Hsieh
        4. Screen Shot 2023-02-09 at 1.21.02 PM.png
          71 kB
          Felicia Hsieh

            Assignee:
            alena.khineika@mongodb.com Alena Khineika
            Reporter:
            felicia.hsieh@mongodb.com Felicia Hsieh
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: