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

Document porting of user defined aggregate functions (UDAF) to sql_mode=ORACLE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Documentation
    • None

    Description

      Request via email
      —
      I've ported used defined aggregate functions (UDAF) to sql_mode=ORACLE.
      Earlier UDAF did note work with sql_mode=ORACLE.

      Can you please document this?

      Syntactically, an UDAF for sql_mode=ORACLE is
      a normal PL/SQL function, with:

      1. a FETCH GROUP NEXT ROW statement

      2. an EXCEPTION WHEN NO_DATA_FOUND
      Note, SQL/PSM-style CONTINUE HANDLER can be used instead of #2 as well,
      however we probably don't want to advertise this in the manual.
      Please use Oracle's EXCEPTION in examples.

      Please find examples in tests in this commit:

      https://github.com/mariadb/server/commit/3b47587f419f70687d840c522f4a80e7762b9183

      Note, Oracle has UDAFs, but they are implemented using a
      different syntax. We'll probably implement Oracle native
      syntax for UDAFs later.

      Attachments

        Activity

          People

            KennethDyer Kenneth Dyer (Inactive)
            greenman Ian Gilfillan
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.