maria-developers team mailing list archive

["Martijn Tonies \(Upscene Productions\)" <m.tonies@xxxxxxxxxxx>]

Hello Sergei,

Thank you for confirming this and adding it to the tracker ;)

As a tool developer, this is the things I look for when attempting to 
recreate the CREATE statements from the available meta data.

Here's another one that MariaDB could fix ;)
https://bugs.mysql.com/bug.php?id=11082

With regards,

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

Database Workbench - developer tool for Oracle, SQL Server, PostgreSQL, 
MySQL, InterBase, NexusDB and Firebird.

-----Original Message----- 
From: Sergei Golubchik
Sent: Wednesday, June 15, 2022 2:21 PM
To: Martijn Tonies (Upscene Productions)
Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
Subject: 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@xxxxxxxxxxx