[SERVER-70696] [CQF] Determine presence of left and right intervals as a logical property Created: 19/Oct/22  Updated: 29/Oct/23  Resolved: 01/Nov/22

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

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) 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-70163 [CQF] Implement RIDUnionNode Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2022-10-31
Participants:

 Description   

RIDIntersectNode currently has fields indicating if we have left and/or right intervals in its child SargableNodes. This is used to restrict the search space if we optimize under indexing target. We do not want to explore an index intersection plan where one side does not have intervals. For simplicity and compatibility with the future RIDUnionNode we should avoid using those fields to indicate the presence of predicates, and instead compute logical properties. One candidate is extending the IndexingAvailability to property to track if we have partial schema requirements which are proper intervals. The property already tracks if we have only equalities. The RIDUnion node then will not need to track of the presence of the left and right intervals directly.



 Comments   
Comment by Githook User [ 31/Oct/22 ]

Author:

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

Message: SERVER-70696 Determine presence of left and right intervals as a logical property
Branch: master
https://github.com/mongodb/mongo/commit/201497d405225041f1806d25dfed475f3ec3f7ae

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