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@lists.launchpad.net 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@mariadb.org