[SERVER-79853] [CQF] Generate SBE expression to hash shard key when invoking ShardFilterer Created: 08/Aug/23 Updated: 29/Oct/23 Resolved: 22/Aug/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.1.0-rc0 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Ben Shteinfeld | Assignee: | Ben Shteinfeld |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||
| Participants: | |||||||||||||
| Linked BF Score: | 145 | ||||||||||||
| Description |
|
In the enforcer and implementers which handle RemoveOrphansRequirement, we currently generate physical plans that do not consider the collation spec of the shard key. This means for shard keys like {_id: 'hashed'}, if we are performing a coll scan, we need to hash the value of _id before invoking the ShardFilterer. |
| Comments |
| Comment by Ben Shteinfeld [ 28/Sep/23 ] |
|
sanika.phanse@mongodb.com apologizes for the delay, I am just returning from OOO. This ticket should not be backported and is not related to |
| Comment by Sanika Phanse (Inactive) [ 27/Sep/23 ] |
|
Hi ben.shteinfeld@mongodb.com Any updates here? So far the feature has been backported to 7.0 and a backport to 6.0 is in-progress. |
| Comment by Sanika Phanse (Inactive) [ 18/Sep/23 ] |
|
Hi ben.shteinfeld@mongodb.com, I am backporting |
| Comment by Githook User [ 22/Aug/23 ] |
|
Author: {'name': 'Ben Shteinfeld', 'email': 'ben.shteinfeld@mongodb.com', 'username': 'bshteinfeld'}Message: When a shard key contains a hashed component, the ShardFilterer expects This patch also updates the CQF fallback mechanism to enable CQF for |