Jia Fan created SPARK-43308:
-------------------------------
Summary: Improve scalar subquery logic plan when result are literal
Key: SPARK-43308
URL: https://issues.apache.org/jira/browse/SPARK-43308
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.5.0
Reporter: Jia Fan
When use scalar subquery, sometimes we can get result before physical plan
execute.
Like `select a, (select (count(1)) is null from r where a = c group by c) from
l where a < 4`.
The result alway be false. So we can skip unnecessary aggregate.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
