[jira] [Commented] (CALCITE-800) Window function defined within another window function should be invalid

[Sean Hsuan-Yi Chu (JIRA)]

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

Sean Hsuan-Yi Chu commented on CALCITE-800:
-------------------------------------------

Thanks for the pointers!

> Window function defined within another window function should be invalid
> ------------------------------------------------------------------------
>
>                 Key: CALCITE-800
>                 URL: https://issues.apache.org/jira/browse/CALCITE-800
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Julian Hyde
>             Fix For: 1.4.0-incubating
>
>
> 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)