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

Push into column scan filters in the form of {supported} AND {$not: {supported}} on the same path

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
    • Fully Compatible
    • QE 2022-10-17, QE 2022-10-31, QE 2022-11-14, QE 2022-11-28, QE 2022-12-12, QE 2022-12-26, QE 2023-01-09

      We can only push down expressions that would return "false" on missing paths and we make the decision per term of a logical expression. We should allow the user to take advantage of the CSI in more cases by explicitly limiting the filters with {$exists: true}.

            Assignee:
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Reporter:
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: