Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9724

Window functions: Frame Exclusion support

    Details

      Description

      SQL standard supports EXCLUDE clause within window frame definition.

      We currently have it in sql_yacc.yy. The statement is parsed, but ignored:

      opt_window_frame_clause:
                /* empty */ {}
              | window_frame_units window_frame_extent opt_window_frame_exclusion
      

      opt_window_frame_exclusion:
                /* empty */ { $$= Window_frame::EXCL_NONE; }
              | EXCLUDE_SYM CURRENT_SYM ROW_SYM
                { $$= Window_frame::EXCL_CURRENT_ROW; }
              | EXCLUDE_SYM GROUP_SYM
                { $$= Window_frame::EXCL_GROUP; }
              | EXCLUDE_SYM TIES_SYM
                { $$= Window_frame::EXCL_TIES; }
              | EXCLUDE_SYM NO_SYM OTHERS_SYM
                { $$= Window_frame::EXCL_NONE; }
              ;      
      

      The question is - should we implement frame exclusion? It doesn't seem to be supported by anybody:

      If we decide not to support Frame Exclusion, we should disable it in the parser so that it doesn't confuse anybody.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: