[Maria-developers] How to know when a FUNCTION is AGGREGATE?
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 Database Workbench - developer tool for Oracle, SQL Server, PostgreSQL, MySQL, InterBase, NexusDB and Firebird.
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
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
On Wed, Jun 15, 2022 at 3:36 PM Martijn Tonies (Upscene Productions) < m.tonies@upscene.com> wrote:
Here's another one that MariaDB could fix ;)
Or anyone that can contribute.
Can you please create an issue in our bug tracker. While we'll occasionally search bugs.mysql.com, its not tracked.
participants (3)
-
Daniel Black -
Martijn Tonies (Upscene Productions) -
Sergei Golubchik