Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-70696

[CQF] Determine presence of left and right intervals as a logical property

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • QO 2022-10-31

      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.

            Assignee:
            matt.boros@mongodb.com Matt Boros
            Reporter:
            svilen.mihaylov@mongodb.com Svilen Mihaylov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: