sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

CREATE AGGREGATE FUNCTION not handled

Open GingkoFr opened this issue 7 months ago • 0 comments

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.

GingkoFr avatar Jun 10 '25 18:06 GingkoFr