[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: |
|
||||||||
| 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: |