[CALCITE-888] Overlay window loses PARTITION BY list

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 17/Sep/15 19:04
• Updated: 27/Feb/24 22:24
• Resolved: 18/Sep/15 17:37

Description

Having parenthesis around window would produce wrong result. For example,

select empno, sum(empno) over (w), count(*) over w
from emp
window w as (partition by empno order by empno)

Notice that the second select item has parenthesis in the window clause. This query would generate a wrong plan:

LogicalProject(EMPNO=[$0], $1=[$9], $2=[$10])
  LogicalWindow(window#0=[window(partition {} order by [0] range between UNBOUNDED PRECEDING and CURRENT ROW aggs [SUM($0)])], window#1=[window(partition {0} order by [0] range between UNBOUNDED PRECEDING and CURRENT ROW aggs [COUNT()])])
    LogicalTableScan(table=[[CATALOG, SALES, EMP]])

where we have two windows in the LogicalWindow.