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

Text index is ignored if run explain plan for a query covered by an index

    • Type: Icon: Bug Bug
    • Resolution: Declined
    • Priority: Icon: Major - P3 Major - P3
    • 1.26.0
    • Affects Version/s: 1.26.0
    • Component/s: Explain
    • None
    • Not Needed

      Problem Description

      Steps to Reproduce

      1. Open any collection
      2. Go to Indexes tab
      3. Create text index on any string field
      4. Go to the Explain Plan tab
      5. Write some query that uses field with just created index on it
      6. click Explain

      Expected Results

      "Index Keys Examined:<number of documents>"

       "Query used the following index: <text index name>

      Actual Results

      "Index Keys Examined:0"

      "No index available for this query." is displayed 

        1. Screenshot 2021-02-25 15-02-36.png
          910 kB
          Olena Protsiuk
        2. image-2021-03-03-10-30-41-035.png
          50 kB
          Massimiliano Marcon

            Assignee:
            Unassigned Unassigned
            Reporter:
            olena.protsiuk@mongodb.com Olena Protsiuk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: