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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      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

            Assignee:
            KennethDyer Kenneth Dyer
            Reporter:
            greenman Ian Gilfillan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration