[jira] [Created] (CALCITE-6538) OVER (ROWS CURRENT ROW) should return a window with one row, not all rows

["Julian Hyde (Jira)" <ji...@apache.org>]

Julian Hyde created CALCITE-6538:
------------------------------------

             Summary: OVER (ROWS CURRENT ROW) should return a window with one row, not all rows
                 Key: CALCITE-6538
                 URL: https://issues.apache.org/jira/browse/CALCITE-6538
             Project: Calcite
          Issue Type: Improvement
            Reporter: Julian Hyde


{{OVER (ROWS CURRENT ROW)}} should return a window with one row, not all rows.

For example, in the following query (in {{{}winagg.iq{}}}) each {{sum_sal}} value should equal the {{sal}} value (and does on Postgres), but currently Calcite gives {{{}8275.00{}}}:
{noformat}
# Current row
select ename, sal, sum(sal) over (rows current row) as sum_sal
from emp
where job = 'MANAGER';
+-------+---------+---------+
| ENAME | SAL     | SUM_SAL |
+-------+---------+---------+
| BLAKE | 2850.00 | 8275.00 |
| CLARK | 2450.00 | 8275.00 |
| JONES | 2975.00 | 8275.00 |
+-------+---------+---------+
(3 rows)

!ok {noformat}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)