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.