[
https://issues.apache.org/jira/browse/CALCITE-7100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18089043#comment-18089043
]
Yu Xu commented on CALCITE-7100:
--------------------------------
I take it first.
> Invalid unparse for OVER() in OracleDialect
> -------------------------------------------
>
> Key: CALCITE-7100
> URL: https://issues.apache.org/jira/browse/CALCITE-7100
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Assignee: Yu Xu
> Priority: Major
>
>
> The SQL:
> {code:java}
> select sum(count(*)) over() from EMPLOYEE;
> {code}
> The Calcite generate the Oracle Dialect SQL is:
> {code:java}
> select sum(count(*)) over(RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED
> FOLLOWING) from EMPLOYEE; {code}
> Which throws exception in Oracle:
> {code:java}
> ORA-30485: missing ORDER BY expression in the window specification {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
