[SERVER-81501] Encode parameter data types into QueryShapeString Created: 27/Sep/23  Updated: 19/Jan/24  Resolved: 19/Jan/24

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

Type: Task Priority: Major - P3
Reporter: Jess Balint Assignee: Ben Shteinfeld
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-81801 Recover cached SBE plans Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-10-02, QO 2023-10-16, QO 2023-10-30, QO 2023-11-13, QO 2023-11-27, QO 2023-12-11, QO 2023-12-25, QO 2024-01-08, QO 2024-01-22
Participants:

 Description   

The current QueryShapeString used in the SBE plan cache includes the `inputParamId` but not the datatype. We should include the "canonical" datatype (c.f. canonicalizeBSONType) with the parameter. This is required to cache plans with keys which guarantee correctness across canonically-equivalent types (eg double and int).



 Comments   
Comment by Githook User [ 19/Jan/24 ]

Author:

{'name': 'Ben Shteinfeld', 'email': 'ben.shteinfeld@mongodb.com', 'username': 'bshteinfeld'}

Message: SERVER-81501 Encode parameter types into cache under Bonsai (#16744)

GitOrigin-RevId: 767db988453c89fc998c502f8baf91edc9f20fb8
Branch: master
https://github.com/mongodb/mongo/commit/7ffddc880965d27452478ce18da8d88f6905a325

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