← 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
> 
Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx


Follow ups

References