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

Window function defined within another window function should be invalid

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.4.0-incubating
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: