[COMPASS-4675] Text index is ignored if run explain plan for a query covered by an index Created: 25/Feb/21  Updated: 25/Aug/23  Resolved: 03/Mar/21

Status: Closed
Project: Compass
Component/s: Explain
Affects Version/s: 1.26.0
Fix Version/s: 1.26.0

Type: Bug Priority: Major - P3
Reporter: Olena Protsiuk (Inactive) Assignee: Unassigned
Resolution: Declined Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screenshot 2021-02-25 15-02-36.png     PNG File image-2021-03-03-10-30-41-035.png    
Documentation Changes: Not Needed

 Description   

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 



 Comments   
Comment by Massimiliano Marcon [ 03/Mar/21 ]

Queries that use text indexes don't look like conventional queries. Text indexes actually work as expected. See screenshot below.

Generated at Wed Feb 07 22:37:07 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.