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

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

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 4.9.0
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
      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.

      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@mongodb.com Hana Pearlman
            Reporter:
            ethan.zhang@mongodb.com Ethan Zhang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: