Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-888

Overlay window loses PARTITION BY list

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.5.0
    • None
    • None

    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.

      Attachments

        Activity

          People

            julianhyde Julian Hyde
            seanhychu Sean Hsuan-Yi Chu
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: