[
https://issues.apache.org/jira/browse/CALCITE-6500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17868528#comment-17868528
]
Julian Hyde commented on CALCITE-6500:
--------------------------------------
[~sree.manamala], Jira has a different [markup
format|https://jira.atlassian.com/secure/WikiRendererHelpAction.jspa?section=advanced]
than GitHub. Can you please fix the formatting.
> 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)
