[ 
https://issues.apache.org/jira/browse/CALCITE-1327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15404516#comment-15404516
 ] 

Gautam Kumar Parai edited comment on CALCITE-1327 at 8/2/16 6:14 PM:
---------------------------------------------------------------------

[~julianhyde] I agree these are related to the same issue you mentioned above. 
I have created CALCITE-1340 and assigned it to myself to address these issues. 

However, the current JIRA is targeted towards nested window aggregate issues 
which were caused by CALCITE-750 (Support for nested window aggregates). The 
current PR fixes the issues which are in the scope of this JIRA. Could you 
please review the PR? Thanks!


was (Author: gparai):
[~julianhyde] I agree these are related to the same issue you mentioned above. 
I have created CALCITE-1340 and assigned it to myself to address these issues. 

However, the current JIRA is targeted towards nested window aggregate issues 
which were caused by Calcite-750 (Support for nested window aggregates). The 
current PR fixes the issues which are in the scope of this JIRA. Could you 
please review the PR? Thanks!

> Nested aggregate windowed query fails
> -------------------------------------
>
>                 Key: CALCITE-1327
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1327
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Gautam Kumar Parai
>            Assignee: Gautam Kumar Parai
>
> Regression from CALCITE-750 Allow nested window aggregates. 
> Calcite allows illegal queries instead of raising an appropriate error. When 
> executing the following query calcite does not raise the following error.
> {code}
> select avg(sum(b)) over (partition by b) from t1;
> ERROR:  Expression 'b' is not being grouped
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to