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

Window functions Range defaults to CURRENT ROW

    Details

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

      Description

      If you provide a window function without any RANGE, the default lower bound and upper bound seems to be set to CURRENT ROW, where I think it should unbounded preceding and current row.

      However, even if this is implementation specific what the default value is, you cannot tell if the original query didn't provide it since the default was given in Optiq.

      ---------------- Imported from GitHub ----------------
      Url: https://github.com/julianhyde/optiq/issues/284
      Created by: tnachen
      Labels:
      Created at: Sun May 18 13:40:12 CEST 2014
      State: closed

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: