This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.