28.3.31 The INFORMATION_SCHEMA ROUTINE

28.3.31 The INFORMATION_SCHEMA ROUTINE_LIBRARIES Table

The ROUTINE_LIBRARIES table provides information about routines contained in JavaScript libraries supported by the MLE Component (see Section 7.5.7, “Multilingual Engine Component (MLE)”).

The ROUTINE_LIBRARIES table has the columns listed here:

ROUTINE_CATALOG
Routine catalog name. Currently, this is always def.
ROUTINE_SCHEMA
Routine schema or database.
ROUTINE_NAME
Name of the routine.
ROUTINE_TYPE
Type of routine. One of FUNCTION, PROCEDURE, or LIBRARY.
LIBRARY_CATALOG
Library catalog name. Currently, this is always def.
LIBRARY_SCHEMA
Library database or schema.
LIBRARY_NAME
Library name.
LIBRARY_VERSION
Library version.

Example:

mysql> TABLE information_schema.ROUTINE_LIBRARIES\G
*************************** 1. row ***************************
ROUTINE_CATALOG: def
 ROUTINE_SCHEMA: jslib
   ROUTINE_NAME: foo
   ROUTINE_TYPE: FUNCTION
LIBRARY_CATALOG: def
 LIBRARY_SCHEMA: jslib
   LIBRARY_NAME: lib1
LIBRARY_VERSION: NULL
*************************** 2. row ***************************
ROUTINE_CATALOG: def
 ROUTINE_SCHEMA: jslib
   ROUTINE_NAME: foo
   ROUTINE_TYPE: FUNCTION
LIBRARY_CATALOG: def
 LIBRARY_SCHEMA: jslib
   LIBRARY_NAME: lib2
LIBRARY_VERSION: NULL
2 rows in set (0.00 sec)

All stored routines importing libraries are listed in the ROUTINE_LIBRARIES table even if the referenced Library does not exist.