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

Aggregate stored functions

Details

    • 10.3.1-1, 10.3.1-2, 10.3.3-1

    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 stored functions (may be the newer standard does). Oracle, PostgreSQL, HSQL (may be more) all implement aggregate stored functions using their own incompatible syntax extensions. SQL Server and DB2 do not support creating new aggregate stored functions in SQL.

      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

      and possibly

      • code to invoke between groups to reset the storage
      • code to remove data from the group (useful for window functions)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14520 Custom aggregate functions work incorrectly with WITH ROLLUP clause

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24580 Aggregate stored function return always NULL in case of empty input set

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MCOL-523 support user defined aggregate functions

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-11263 Aggregate Window Functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled

          Task - A task that needs to be done. MDEV-11301 SUGGESTION: Increase the number of Aggregate Functions

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-14564 support FOR loop in stored aggregate functions

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28849 I_S tables don't tell that the stored function is AGGREGATE

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            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.

            .h2 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
            		 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.

            h2. 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
            serg Sergei Golubchik made changes -
            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.

            h2. 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
            		 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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 60114 ] MariaDB v3 [ 64604 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            colin Colin Charles made changes -
            Labels gsoc15 gsoc16
            serg Sergei Golubchik made changes -
            Labels gsoc16 gsoc15 gsoc16
            serg Sergei Golubchik made changes -
            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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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
            		 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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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
            * and possibly
            ** code to invoke between groups to reset the storage
            ** code to *remove* data from the group (useful for window functions)
            serg Sergei Golubchik made changes -
            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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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
            * and possibly
            ** code to invoke between groups to reset the storage
            ** code to *remove* data from the group (useful for window functions)
            		 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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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
            and possibly
            * code to invoke between groups to reset the storage
            * code to *remove* data from the group (useful for window functions)
            serg Sergei Golubchik made changes -
            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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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
            and possibly
            * code to invoke between groups to reset the storage
            * code to *remove* data from the group (useful for window functions)
            		 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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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

            and possibly
            * code to invoke between groups to reset the storage
            * code to *remove* data from the group (useful for window functions)
            serg Sergei Golubchik made changes -
            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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate storage functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (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

            and possibly
            * code to invoke between groups to reset the storage
            * code to *remove* data from the group (useful for window functions)
            		 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.

            h2. Syntax

            is not decided yet. SQL Standard 2003 doesn't support aggregate stored functions (may be the newer standard does). [Oracle|http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dciaggfns.htm], [PostgreSQL|http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html], [HSQL|http://hsqldb.org/doc/guide/sqlroutines-chapt.html#src_aggregate_functions] (may be more) all implement aggregate stored functions using their own incompatible syntax extensions. SQL Server and DB2 do not support creating new aggregate stored functions in SQL.

            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

            and possibly
            * code to invoke between groups to reset the storage
            * code to *remove* data from the group (useful for window functions)
            svoj Sergey Vojtovich made changes -
            Assignee Vicentiu Ciorbaru [ cvicentiu ]
            svoj Sergey Vojtovich made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            svoj Sergey Vojtovich made changes -
            Fix Version/s 10.2 [ 14601 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.2 [ 14601 ]
            varun Varun Gupta (Inactive) made changes -
            Assignee Vicentiu Ciorbaru [ cvicentiu ] Varun Gupta [ varun ]
            varun Varun Gupta (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            dthompson David Thompson (Inactive) made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.3.1-1 [ 164 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            varun Varun Gupta (Inactive) made changes -
            Assignee Varun Gupta [ varun ] Vicentiu Ciorbaru [ cvicentiu ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels gsoc15 gsoc16 10.3-beta gsoc15 gsoc16
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Link PT-57 [ 62149 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.3.1-1 [ 164 ] 10.3.1-1, 10.3.1-2 [ 164, 174 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Sprint 10.3.1-1, 10.3.1-2 [ 164, 174 ] 10.3.1-1, 10.3.1-2, 10.3.3-1 [ 164, 174, 200 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Vicentiu Ciorbaru [ cvicentiu ] Varun Gupta [ varun ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            varun Varun Gupta (Inactive) made changes -
            Fix Version/s 10.3.3 [ 22644 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            proust Christian Proust made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64604 ] MariaDB v4 [ 132581 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -

            People

              varun Varun Gupta (Inactive)
              serg Sergei Golubchik
              Votes:
              3 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.