[SERVER-60710] indexFilterSet is always False with verbosity of "executionStats" or above Created: 14/Oct/21 Updated: 29/Oct/23 Resolved: 30/Mar/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ronan Merrick | Assignee: | Anton Korshunov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
|||||||||||||
| Backwards Compatibility: | Fully Compatible | |||||||||||||
| Operating System: | ALL | |||||||||||||
| Steps To Reproduce: | For example:
Create an index filter for one of the indexes:
Run the following query:
The index is used but indexFilterSet is false in the explain() output Clear the index filter:
Create a filter for a different index:
Now re-run the query. The index is used, but indexFilterSet is false |
|||||||||||||
| Sprint: | QE 2021-11-15, QE 2021-11-29, QE 2021-12-13, QE 2021-12-27, QE 2022-01-10, QO 2022-03-07, QO 2022-03-21, QE 2022-01-24, QO 2022-04-04 | |||||||||||||
| Participants: | ||||||||||||||
| Description |
|
In the documentation for Index Filters ,it says:
However in practice, this doesn't seem to indicate whether an index filter is being used and seems to remain false. (Tested on v4.4.9 and v5.0.2) |
| Comments |
| Comment by Githook User [ 29/Mar/22 ] |
|
Author: {'name': 'Anton Korshunov', 'email': 'anton.korshunov@mongodb.com', 'username': 'antkorsh'}Message: |
| Comment by Kyle Suarez [ 01/Feb/22 ] |
|
Sorry for losing track of this ticket – moving it back into the queue for re-triage. |