[COMPASS-4754] Explain Plan is not returning any results on $or queries Created: 13/Apr/21  Updated: 09/Aug/22

Status: Open
Project: Compass
Component/s: Explain
Affects Version/s: 1.26.1
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Carlos Castro Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2021-04-13-15-51-46-784.png     PNG File image-2021-04-13-15-52-37-042.png     PNG File image-2021-04-13-15-53-40-338.png    

 Description   

Problem Description

Explain Plan is not returning any data:

The Documents table is showing the correct result:

When running .explain() on the shell I get the correct result:

I've tried restarting Compass multiple times and I am getting the same result.

I am connecting to an Atlas cluster.

 

 



 Comments   
Comment by Abhinav Duggal (Inactive) [ 13/Apr/21 ]

I am facing the same issue. I initially found this in a customer engagement running a Windows 10 machine and Compass 1.26.0 (further details in the same Slack Thread that Carlos mentions in the previous comment). I am now facing this on Compass downloaded locally on my company-provided Macbook Pro as well. It was running Compass 1.26.0. I have also upgraded it to the latest version (1.26.1) and it still doesn't work.

Comment by Carlos Castro [ 13/Apr/21 ]

I've found a thread on Slack with this same issue and it looks like this happens for "$or" queries only - just tried without the "$or" and it works as expected

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