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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 3.3.6
    • Aggregation Framework
    • None
    • Fully Compatible
    • ALL
    • Query 14 (05/13/16)

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: