[SERVER-82242]  Implement QuerySolution hash and store in plan cache Created: 16/Oct/23  Updated: 09/Dec/23  Resolved: 07/Dec/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.3.0-rc0

Type: New Feature Priority: Major - P3
Reporter: Matt Boros Assignee: Matt Boros
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-83234 Allow users to hint plans using the Q... Needs Scheduling
is depended on by SERVER-82238 Add field to explain to indicate if w... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-11-27, QO 2023-12-11
Participants:

 Description   

As a prerequisite to SERVER-82238, we need a way to check if the QuerySolution that lead to a cache entry matches one that we consider during an explain. We will hash the QuerySolution, store the hash in the plan cache, and when we run explain we see which plan hash matches the cached hash.

For this ticket, we will implement the hash of the QuerySolution.



 Comments   
Comment by Githook User [ 09/Dec/23 ]

Author:

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

Message: SERVER-82242 Remove check for duplicate plans in QueryPlanner::plan

GitOrigin-RevId: ac14e5a9698aa21ee6441762f7733e5f6daaaf0d
Branch: master
https://github.com/mongodb/mongo/commit/6099c30cf9ae6f1e4f7f214b95111e95227bf092

Comment by Githook User [ 07/Dec/23 ]

Author:

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

Message: SERVER-82242 implement QuerySolution hash

GitOrigin-RevId: 4d1dd670d245ae2f4e2a7a9e735ef4b6a934c754
Branch: master
https://github.com/mongodb/mongo/commit/e20dbe32b459832b232bca3995c5f0daa8902834

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