[SPARK-42044] Fix wrong error message for `MUST_AGGREGATE_CORRELATED_SCALAR_SUBQUERY`

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Haejoon Lee
• Reporter: Haejoon Lee
• Created: 13/Jan/23 03:01
• Updated: 24/Jan/23 14:01
• Resolved: 24/Jan/23 14:01

Description

The current error message

"Correlated scalar subqueries in the GROUP BY clause must also be in the aggregate expressions<treeNode>"

is incorrect since it's not related with group by clause.

We should fix it.

Issue Links

• links to: [Github] Pull Request #39543 (itholic)
• links to: [Github] Pull Request #39543 (itholic)