[SERVER-79518] [CQF] Fix CE computation during implementation of SargableNode Created: 31/Jul/23  Updated: 29/Oct/23  Resolved: 01/Aug/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: 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:
Depends
is depended on by SERVER-78507 [CQF] Satisfy RemoveOrphansRequiremen... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: QO 2023-08-07
Participants:

 Description   

If the PartialSchemaRequirements in a SargableNode are a single disjunction (all atoms AND'd together), lowerPartialSchemaRequirements() silently ignores the cardinality of the first conjunct in the PSR when calculating the cardinality of newly introduced FilterNode (code here).



 Comments   
Comment by Githook User [ 02/Aug/23 ]

Author:

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

Message: SERVER-79518 Fix cardinality estimation for nodes created during
SargableNode implementation

This patch fixes a bug where we ignored the cardinality of the first
PartialSchemaRequirement in a SargableNode if the PSR is a single
disjunction.
Branch: minh.luu-no_compile_sys-perf
https://github.com/mongodb/mongo/commit/1bc1c4152851dc18996dcefe396b74fb5d8db745

Comment by Githook User [ 01/Aug/23 ]

Author:

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

Message: SERVER-79518 Fix cardinality estimation for nodes created during
SargableNode implementation

This patch fixes a bug where we ignored the cardinality of the first
PartialSchemaRequirement in a SargableNode if the PSR is a single
disjunction.
Branch: master
https://github.com/mongodb/mongo/commit/1bc1c4152851dc18996dcefe396b74fb5d8db745

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