← Back to team overview

maria-developers team mailing list archive

Re: 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
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx

Follow ups