Mihailo Aleksic created SPARK-56030:
---------------------------------------

             Summary: Normalize inner Project when below Project -> Filter
                 Key: SPARK-56030
                 URL: https://issues.apache.org/jira/browse/SPARK-56030
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 4.1.1
            Reporter: Mihailo Aleksic


In this issue I propose to normalize inner Project when below Project -> 
Filter. Right now
```
SELECT a.key, b.key AS key_b
FROM t1 b
FULL JOIN t2 a USING (key)
WHERE b.key IS NULL OR a.key IS NULL
```
throws LOGICAL_PLAN_COMPARISON_MISMATCH for analyzer dual-runs and normalizing 
would fix it.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to