[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:
Backports
Depends
Related
related to SERVER-77973 Do not gate COUNT_SCAN in SBE by feat... Closed
related to SERVER-71485 Better naming for CanonicalQuery::isC... Closed
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: SERVER-79924 Pass correct value of isCountLike attribute to subqueries
Branch: v7.1
https://github.com/mongodb/mongo/commit/dd51e3dbc3d6e9f763389e4a8fad9298bc985af3

Comment by Githook User [ 10/Nov/23 ]

Author:

{'name': 'Matthew Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}

Message: SERVER-79924 Pass correct value of isCountLike attribute to subqueries
Branch: v7.0
https://github.com/mongodb/mongo/commit/6e8496f6ef57c5cd64117043eb5ddba6cb70ad41

Comment by Githook User [ 18/Oct/23 ]

Author:

{'name': 'Matt Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}

Message: SERVER-79924 Pass correct value of isCountLike attribute to subqueries
Branch: master
https://github.com/mongodb/mongo/commit/ba3bd37dd13015025ca53a3cfe1328e411ab5840

Generated at Thu Feb 08 06:42:15 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.