[SERVER-76544] [CQF] Fix for residual predicate selectivity estimation Created: 26/Apr/23  Updated: 29/Oct/23  Resolved: 27/Apr/23

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

Type: Bug Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Svilen Mihaylov (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-75077 Suboptimal plan selection in Bonsai Backlog
Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: QO 2023-05-01
Participants:

 Description   

When we estimate selectivity of residual predicates for a "Seek" sargable node, we apply the wrong denominator. We divide essentially by "1" instead of the group cardinality. This leads to incorrect selectivities and incorrect cost for the plan.



 Comments   
Comment by Githook User [ 27/Apr/23 ]

Author:

{'name': 'Svilen Mihaylov', 'email': 'svilen.mihaylov@mongodb.com', 'username': 'svilen-mihaylov'}

Message: SERVER-76544 [CQF] Fix for residual predicate selectivity estimation
Branch: master
https://github.com/mongodb/mongo/commit/b62a4d9aec355679098f803dd97b0fda2cf0bcdb

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