Support correlated outer reference in EXISTS-over-UNNEST subquery

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Unknown
    • None
    • Affects Version/s: None
    • Component/s: Query
    • None
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      When an EXISTS-over-UNNEST subquery body references a field from the outer entity (e.g. WHERE EXISTS (FROM c.lineItems li WHERE li.qty > c.minQty)), the current translator throws FeatureNotSupportedException because $elemMatch cannot reference outer document fields directly.

      Supporting this shape requires translating to $expr with $anyElementTrue+$map, a structurally different MQL form from the simple $elemMatch used for non-correlated EXISTS-over-UNNEST.

            Assignee:
            Unassigned
            Reporter:
            Jeffrey Yemin
            None
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: