[SERVER-66558] $sort does not rewrite to bounded sort when multiple index options are available Created: 18/May/22 Updated: 29/Oct/23 Resolved: 01/Jun/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0-rc9, 6.1.0-rc0, 5.0.16 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Matt Boros | Assignee: | Sam Mercier |
| 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 | ||||
| Backport Requested: |
v6.0, v5.0
|
||||
| Sprint: | QO 2022-05-16, QO 2022-05-30, QO 2022-06-13 | ||||
| Participants: | |||||
| Description |
|
This rewrite also does not happen when the plan cache is used.
The issue appears to be here, where we need to handle a multiplan stage and a plan cache stage. Ideally part of this fix would be to write a test to make sure the rewrite occurs when it comes from the plan cache and from a multiplan stage. |
| Comments |
| Comment by Githook User [ 21/Feb/23 ] |
|
Author: {'name': 'samontea', 'email': 'merciers.merciers@gmail.com', 'username': 'samontea'}Message: |
| Comment by Githook User [ 31/May/22 ] |
|
Author: {'name': 'samontea', 'email': 'merciers.merciers@gmail.com', 'username': 'samontea'}Message: |
| Comment by Githook User [ 31/May/22 ] |
|
Author: {'name': 'samontea', 'email': 'merciers.merciers@gmail.com', 'username': 'samontea'}Message: |