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 secur...@mariadb.org
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
