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

Chunwei Lei updated CALCITE-2729:
---------------------------------
    Description: 
Introducing WindowExpressionRules, for example:
select sum(sal) over (partition by deptno order by sal) from src where sal=5000
can be reduced to 
select sum(5000) over (partition by deptno) from src where sal=5000

  was:
Introducing WindowExpressionRules.

Select 


> Introducing WindowExpressionRules
> ---------------------------------
>
>                 Key: CALCITE-2729
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2729
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.17.0
>            Reporter: Chunwei Lei
>            Assignee: Chunwei Lei
>            Priority: Major
>             Fix For: 1.18.0
>
>
> Introducing WindowExpressionRules, for example:
> select sum(sal) over (partition by deptno order by sal) from src where 
> sal=5000
> can be reduced to 
> select sum(5000) over (partition by deptno) from src where sal=5000



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to