[SERVER-54673] $lookup does not work properly on time-series collections for unequal joins Created: 19/Feb/21  Updated: 29/Oct/23  Resolved: 03/Mar/21

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 4.9.0

Type: Bug Priority: Major - P3
Reporter: Ethan Zhang (Inactive) Assignee: Hana Pearlman
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Operating System: ALL
Steps To Reproduce:

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.

Participants:

 Description   

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.



 Comments   
Comment by Hana Pearlman [ 03/Mar/21 ]

This bug is fixed by SERVER-54864.

Generated at Thu Feb 08 05:34:10 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.