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

Pushing $match inside $lookup which has an $unwind filters out all documents including those that should match

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 3.3.6
    • Affects Version/s: None
    • Component/s: Aggregation Framework
    • Labels:
      None
    • Fully Compatible
    • ALL
    • Query 14 (05/13/16)

      Testing filter getting pushed into find during $lookup I created a case where no results are being returned rather than matching subset of results that only happens on Mac OS X build.

      I think we also are pushing $match into $lookup in spite an unwind which creates different results than lack of optimization would.

      Will put reproducer in comment to make it readable.

            Assignee:
            benjamin.murphy Benjamin Murphy
            Reporter:
            asya.kamsky@mongodb.com Asya Kamsky
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: