-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
We need additional logic on the QO side to ensure that SBE does not need to worry about merging conflicting paths for arbitrary QSNs. An example query would be: ($lu = $lookup + $unwind on as)
{$lu... as: "a"}
{$lu... as: "a.b"}
If we were to do the second join first, we obviously need to be careful not to overwrite field "a.b" when we do the second join (especially if field "b" contains something!)
For now, the easy solution is to bail in such cases.
- is duplicated by
-
SERVER-112875 Tassert in JOO with pipeline with two lookups that overwrite the same “as” field
-
- Closed
-
- is related to
-
SERVER-113230 Handle conflicting as fields for join-reordering
-
- Needs Scheduling
-