Re: [Maria-developers] How to know when a FUNCTION is AGGREGATE?

Hi, Martijn, It seems there is no way to distinguish, short of parsing the routine body looking for 'fetch group next row'. I've reported it as a bug, https://jira.mariadb.org/browse/MDEV-28849 On Jun 15, Martijn Tonies (Upscene Productions) wrote:

Hi all,

Since MariaDB 10.3, you can use an AGGREGATE stored function.

https://mariadb.com/kb/en/stored-aggregate-functions/

When examining the meta data, how does one distinguish between aggregate and normal stored functions?

Can’t find anything in the information_schema about this.

With regards,

Martijn Tonies Upscene Productions https://www.upscene.com

Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org