$lookup does not work properly on time-series collections for unequal joins

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 4.9.0
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • Fully Compatible
    • ALL
    • Hide

      Take the test from https://mongodbcr.appspot.com/768010011/patch/729490070/766090038, It will no longer pass if you take out the {$_internalInhibitOptimization: {}} stage from the $lookup pipeline, the test will fail with incorrect query results.

      Show
      Take the test from https://mongodbcr.appspot.com/768010011/patch/729490070/766090038 , It will no longer pass if you take out the {$_internalInhibitOptimization: {}} stage from the $lookup pipeline, the test will fail with incorrect query results.
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      In SERVER-53619, we tested the $lookup queries against time-series collections and found a correctness bug with unequal joins. We believe this is related to some optimization work because adding a $_internalInhibitOptimization: {} stage to the $lookup pipeline will let us get the correct query result again. See Steps to Reproduce for more information about the test.

            Assignee:
            Hana Pearlman
            Reporter:
            Ethan Zhang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: