[SPARK-48146] Fix error with aggregate function in With child

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Kelvin Jiang
• Reporter: Kelvin Jiang
• Created: 06/May/24 19:15
• Updated: 10/May/24 17:49
• Resolved: 10/May/24 14:39

Description

Right now, if we have an aggregate function in the child of a With expression, we fail an assertion. However, queries like this used to work:

select
    id between cast(max(id between 1 and 2) as int) and id
from range(10)
group by id

Issue Links

• links to: GitHub Pull Request #46443