[
https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sree Charan Manamala updated CALCITE-6500:
------------------------------------------
Description:
A query like
{code:java}
SELECT
row_number() over (partition by aggr(col1) order by col2) as c
FROM table
{code}
works fine.
where as
{code:java}
SELECT
row_number() over w as c
FROM table
WINDOW w as (partition by aggr(col1) order by col2)
{code}
throws
agg.lookupAggregates for call aggr(`table`.`col1`))
java.lang.NullPointerException
```
was:
A query like
```
SELECT
row_number() over (partition by aggr(col1) order by col2) as c
FROM table
```
works fine.
where as
```
SELECT
row_number() over w as c
FROM table
WINDOW w as (partition by aggr(col1) order by col2)
```
throws
```
agg.lookupAggregates for call aggr(`table`.`col1`))
java.lang.NullPointerException
```
> Aggregation inside Window clause nodes fails when the query is written with a
> different syntax
> ----------------------------------------------------------------------------------------------
>
> Key: CALCITE-6500
> URL: https://issues.apache.org/jira/browse/CALCITE-6500
> Project: Calcite
> Issue Type: Bug
> Reporter: Sree Charan Manamala
> Priority: Minor
>
> A query like
>
> {code:java}
> SELECT
> row_number() over (partition by aggr(col1) order by col2) as c
> FROM table
> {code}
> works fine.
> where as
>
> {code:java}
> SELECT
> row_number() over w as c
> FROM table
> WINDOW w as (partition by aggr(col1) order by col2)
> {code}
>
> throws
>
> agg.lookupAggregates for call aggr(`table`.`col1`))
> java.lang.NullPointerException
> ```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
