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

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.3.6
    • Component/s: Aggregation Framework
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible
    • Operating System:
      ALL
    • Sprint:
      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

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

              Dates

              Created:
              Updated:
              Resolved: