[SPARK-42936] Unresolved having at the end of analysis when using with LCA with the having clause that can be resolved directly by its child Aggregate

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Xinyi Yu
• Reporter: Xinyi Yu
• Created: 27/Mar/23 17:54
• Updated: 28/Mar/23 08:42
• Resolved: 28/Mar/23 08:42

Description

select sum(value1) as total_1, total_1
from values(1, 'name', 100, 50) AS data(id, name, value1, value2)
having total_1 > 0

SparkException: [INTERNAL_ERROR] Found the unresolved operator: 'UnresolvedHaving (total_1#353L > cast(0 as bigint)) 

To trigger the issue, the having condition need to be (can be resolved by) an attribute in the select.
Without the LCA total_1, the query works fine.