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

Improve windowed aggregate return types

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8
    • Component/s: None
    • Labels:

      Description

      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 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
      Labels:
      Created at: Tue May 27 21:09:38 CEST 2014
      State: open

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              github-import GitHub Import
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: