Details

      Description

      From SQL standard here is the general format of LEAD and LAG:

      <window function> ::=
        <lead or lag function> OVER <window name or specification>
      
      <lead or lag function> ::=
        <lead or lag> ( <lead or lag extent>
        [ , <offset> [ , <default expression> ] ] )
        [ <null treatment> ]
      
      <lead or lag> ::=
        LEAD | LAG
      
      <lead or lag extent> ::=
        <value expression>
      
      <offset> ::=
        <exact numeric literal>
      
      <default expression> ::=
        <value expression>
      

      The following won't be supported until CALCITE-337 is resolved:

      <null treatment> ::=
        RESPECT NULLS | IGNORE NULLS
      

      As part of this JIRA task only the following syntax will be supported:

      <lead or lag function> ::=
        <lead or lag> ( <lead or lag extent> )
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                adeneche Deneche A. Hakim
                Reporter:
                adeneche Deneche A. Hakim
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: