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

Aggregate stored functions

        Details

          Description

          With CREATE FUNCTION one can create functions in SQL, but this syntax doesn't allow one to create an aggregate function (like SUM, AVG, etc). This task is to add support for aggregate stored functions.

          Syntax

          is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). Oracle, PostgreSQL, HSQL (may be more) all implement aggregate stored functions using their own incompatible syntax extensions.

          The syntax should at least allow for

          • the code to return the function value
          • the code to be called per row in a group, it accumulates data, does not return a value
          • storage that is preserved between calls within a group

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    serg Sergei Golubchik
                  • Votes:
                    3 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated: