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]