CREATE AGGREGATE FUNCTION not handled

Hello.

I found out that phpMyAdmin 5.2.2 is not handling stored aggregate functions defined as CREATE AGGREGATE FUNCTION described in :
https://mariadb.com/kb/en/stored-aggregate-functions/

I get an error if I define such function by any external mean and want to see it in phpMyAdmin.

Digging into the source code drove me inside this vendor sub-project, file src/Statements/CreateStatement.php.

I tried to add "'AGGREGATE' => 1," to the public static $OPTIONS member of the class CreateStatement into this file, line 36.

This is enough for no longer getting an error, but I suppose this is not enough for having phpMyAdmin properly handling stored aggregate functions.

Inizia da src/Statements/CreateStatement.php, in particolare dalle opzioni di CreateStatement menzionate nel report, e riproduci il caso MariaDB CREATE AGGREGATE FUNCTION descritto nell’issue. Confronta il suo comportamento con la gestione esistente di CREATE FUNCTION; il lavoro è completato quando la forma aggregata non genera più errori e viene gestita correttamente dal parser.