[SERVER-79924] Use an accurate 'isCount' flag to encode a CanonicalQuery for SBE plan cache Created: 11/Aug/23 Updated: 16/Nov/23 Resolved: 07/Nov/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.3.0-rc0, 7.0.5 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ruoxin Xu | Assignee: | Matt Boros |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| 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: |
v7.1, v7.0
|
||||||||||||||||||||
| Sprint: | QO 2023-09-04, QE 2023-10-02, QE 2023-10-16, QE 2023-10-30, QE 2023-11-13 | ||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Linked BF Score: | 3 | ||||||||||||||||||||
| Description |
|
Currently the SBE plan cache key encoding uses isCountLike which is inaccurate. Queries with _isCountLike being true don't necessary use COUNT_SCAN plan. This could cause a IXSCAN plan and a COUNT_SCAN plan share a same SBE plan cache key. |
| Comments |
| Comment by Githook User [ 11/Nov/23 ] |
|
Author: {'name': 'Matthew Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}Message: |
| Comment by Githook User [ 10/Nov/23 ] |
|
Author: {'name': 'Matthew Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}Message: |
| Comment by Githook User [ 18/Oct/23 ] |
|
Author: {'name': 'Matt Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}Message: |