[jira] [Closed] (OPTIQ-292) Improve windowed aggregate return types

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

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

Julian Hyde closed OPTIQ-292.
-----------------------------


Close issues resolved in 0.8 release (2014-06-27).

> Improve windowed aggregate return types
> ---------------------------------------
>
>                 Key: OPTIQ-292
>                 URL: https://issues.apache.org/jira/browse/OPTIQ-292
>             Project: Optiq
>          Issue Type: Bug
>            Reporter: GitHub Import
>              Labels: github-import
>             Fix For: 0.8
>
>
> Optiq currently makes all windowed aggregate functions nullable, but that is invalid. In many cases they will be `NOT NULL`.
> For example:
> * `RANK() OVER w` is not nullable;
> * `FIRST_VALUE(deptno) OVER w` is nullable if and only if `deptno` is nullable; 
> * `SUM(x) OVER w` is nullable iff x is nullable or w may be empty.
> ---------------- Imported from GitHub ----------------
> Url: https://github.com/julianhyde/optiq/issues/292
> Created by: [julianhyde|https://github.com/julianhyde]
> Labels: 
> Created at: Tue May 27 21:09:38 CEST 2014
> State: open



--
This message was sent by Atlassian JIRA
(v6.2#6252)