How Are Package Elements Stored in the System Catalog in MariaDB 11.4?
I've recently started using MariaDB 11.4 and noticed the introduction of the PACKAGE object. I understand that the routine_definition column in the INFORMATION_SCHEMA.ROUTINES table stores the entire package definition. However, this includes the complete definition as a single entry, for example:
sql PROCEDURE p1(); PROCEDURE p2(); FUNCTION f1() RETURNS INT; END
Given the package definition below:
sql DELIMITER $$
CREATE PACKAGE test.pkg1 PROCEDURE p1(); PROCEDURE p2(); FUNCTION f1() RETURNS INT; END; $$
DELIMITER ;
The routine_definition column stores it as:
sql PROCEDURE p1(); PROCEDURE p2(); FUNCTION f1() RETURNS INT; END
I'm looking for a way to list down individual procedures and functions within a package, similar to how it's managed in EDB with pg_catalog.edb_pkgelements.
Is there a specific system catalog table or a method in MariaDB 11.4 to view individual elements (procedures/functions) within a package independently?
Thank you for your assistance!
Answer Answered by Daniel Black in this comment.
There is an outstanding feature request MDEV-33395, if this is what you want please vote/watch it.
If its something different, please create a new feature request.