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

[CQF] Satisfy RemoveOrphansRequirement in ScanNode implementer

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Query Optimization
    • Fully Compatible

      In many cases, plans will have a SargableNode which will satisfy RemoveOrphansRequirement (SERVER-78507). However, plans without sargable predicates (or an empty query) may result in a full collection scan with a ScanNode without a SargableNode. This means we need ScanNode to be able to satisfy RemoveOrphansRequirement.

      We could rely the existing enforcer for RemoveOrphansRequirement to generate a physical alternative, but this won't take advantage of the ability to push down top-level field projections into the physical scan.

      We should take care to test dotted field paths.

            Assignee:
            richard.hausman@mongodb.com Richard Hausman (Inactive)
            Reporter:
            ben.shteinfeld@mongodb.com Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: