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

Window function defined within another window function should be invalid

    XMLWordPrintableJSON

    Details

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

      Description

      For instance,

      select sum(deptno) over (order by 
sum(deptno) over(order by deptno)) 
from emp

      This is an invalid query. However, it passes the validation.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-806 ROW_NUMBER should emit distinct values

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                seanhychu Sean Hsuan-Yi Chu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: