[SERVER-61485] Wrong SBE plan reported by explain() for rejected plans Created: 15/Nov/21 Updated: 29/Oct/23 Resolved: 05/May/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0-rc5, 6.1.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Irina Yatsenko (Inactive) | Assignee: | Denis Grebennicov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | query-director-triage | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| Backwards Compatibility: | Fully Compatible | ||||
| Operating System: | ALL | ||||
| Backport Requested: |
v6.0
|
||||
| Steps To Reproduce: | Have a collection with three indexes: {a:1}, {b:1}, {a:1, b:1}. Run explain for a query that would consider all three indexes, e.g. find({a:7, b:9}). Result: the output for rejectedPlans would look similar to the below one. Notice, that the IXSCAN stage refers to index a_1 while slotBasedPlan.stages refers to a_1_b_1 (which is the winning plan in this case). "rejectedPlans" : [ }, , , } ", |
||||
| Sprint: | QE 2021-12-13, QE 2021-12-27, QE 2022-01-10, QE 2022-04-04, QE 2022-02-07, QE 2022-02-21, QE 2022-03-07, QE 2022-03-21, QE 2022-01-24, QE 2022-04-18, QE 2022-05-02, QE 2022-05-16 | ||||
| Participants: | |||||
| Comments |
| Comment by Githook User [ 05/May/22 ] |
|
Author: {'name': 'Denis Grebennicov', 'email': 'denis.grebennicov@mongodb.com', 'username': 'denis631'}Message: |
| Comment by Githook User [ 04/May/22 ] |
|
Author: {'name': 'Denis Grebennicov', 'email': 'denis.grebennicov@mongodb.com', 'username': 'denis631'}Message: |