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

Window function defined within another window function should be invalid

          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: