You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/07/25 05:27:20 UTC
[jira] [Updated] (CALCITE-1327) Nested aggregate windowed query
fails
[ https://issues.apache.org/jira/browse/CALCITE-1327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-1327:
---------------------------------
Description:
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}
was:
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}
> 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)