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

Window function defined within another window function should be invalid

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              seanhychu Sean Hsuan-Yi Chu

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment