[SPARK-43308] Improve scalar subquery logic plan when result are literal

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.5.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Jia Fan
• Created: 27/Apr/23 12:43
• Updated: 27/Apr/23 14:20

Description

When use scalar subquery, sometimes we can get result before physical plan execute. 

Like `select (select (count(1)) is null from r where a = c ) from l where a < 4`.

The result alway be false. So we can skip unnecessary aggregate.