[SERVER-73423] CLUSTERED_IXSCAN with sort generates two duplicate plans Created: 27/Jan/23 Updated: 29/Oct/23 Resolved: 16/Feb/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.0.0-rc0, 6.3.0-rc1, 6.0.7 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Alyssa Clark | Assignee: | Ivan Fefer |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | quick-tech-debt | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||||||
| Backport Requested: |
v6.3, v6.0
|
||||||||||||||||||||||||
| Sprint: | QE 2023-02-20 | ||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Description |
|
When we have a query on a clustered collection that both filters and sorts on the clustered index key, we generate two of the same plan. First time: Then again here: This doesn’t cause incorrect results because both plans are correct, but it will make us cache plans and do multi planning in situations where we otherwise wouldn’t have to.
|
| Comments |
| Comment by Githook User [ 24/May/23 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: (cherry picked from commit 89b0377ea5c62e5a72469d6072aaa146a700b2b6) |
| Comment by Githook User [ 20/Feb/23 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: |
| Comment by Githook User [ 16/Feb/23 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: |
| Comment by Ivan Fefer [ 15/Feb/23 ] |
|
Looks like it is caused by my changes. Should be easy to fix. |
| Comment by Ana Meza [ 14/Feb/23 ] |
|
Passing to the QE backlog - ivan.fefer@mongodb.com would you mind looking at this please |
| Comment by Alyssa Clark [ 30/Jan/23 ] |
|
This issue didn't exist until |
| Comment by Kyle Suarez [ 27/Jan/23 ] |
|
alyssa.wagenmaker@mongodb.com, do we know if we need to request backport for this? (Presumably to 6.0?) |