[jira] [Resolved] (SPARK-48146) Fix error with aggregate function in With child

["Wenchen Fan (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-48146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenchen Fan resolved SPARK-48146.
---------------------------------
    Fix Version/s: 4.0.0
       Resolution: Fixed

Issue resolved by pull request 46443
[https://github.com/apache/spark/pull/46443]

> Fix error with aggregate function in With child
> -----------------------------------------------
>
>                 Key: SPARK-48146
>                 URL: https://issues.apache.org/jira/browse/SPARK-48146
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: Kelvin Jiang
>            Assignee: Kelvin Jiang
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>
> 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:
> {code:sql}
> select
>     id between cast(max(id between 1 and 2) as int) and id
> from range(10)
> group by id
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org