Add logic to bail out for join-reordering for conflicting as fields

    • 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.

            Assignee:
            Unassigned
            Reporter:
            Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: