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

Sean Hsuan-Yi Chu updated CALCITE-800:
--------------------------------------
    Description: 
For instance,
{code}
select sum(deptno) over (order by 
sum(deptno) over(order by deptno)) 
from emp
{code}

This is an invalid query. However, it passes the validation.

  was:
For instance,
{code}
select sum(deptno) over (order by 
sum() over(order by deptno)) 
from emp
{code}

This is an invalid query. However, it passes the validation.


> Window function defined within another window function should be blocked at 
> parsing
> -----------------------------------------------------------------------------------
>
>                 Key: CALCITE-800
>                 URL: https://issues.apache.org/jira/browse/CALCITE-800
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Sean Hsuan-Yi Chu
>
> For instance,
> {code}
> select sum(deptno) over (order by 
> sum(deptno) over(order by deptno)) 
> from emp
> {code}
> This is an invalid query. However, it passes the validation.



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

Reply via email to