AFAIU, command 'SHOW SYSTEM' shows:

name of each package followed by its procedures;
list of packages;

Currently it looks like this:

Package: RDB$BLOB_UTIL
    CANCEL_BLOB
    CLOSE_HANDLE

Package: RDB$PROFILER
    CANCEL_SESSION
    DISCARD
    FINISH_SESSION
    FLUSH
    PAUSE_SESSION
    RESUME_SESSION
    SET_FLUSH_INTERVAL

Package: RDB$TIME_ZONE_UTIL
    TRANSITIONS

Packages:
    RDB$BLOB_UTIL
    RDB$PROFILER
    RDB$TIME_ZONE_UTIL

(i've added indentation for readability)

But what about packaged functions ? They aren't shown.
Consider query:

set width obj_name 31;

select pg.rdb$package_name as pkg_name, 'packaged proc' as obj_type, sp.rdb$procedure_name as obj_name
from rdb$packages pg
left join rdb$procedures sp on pg.rdb$package_name = sp.rdb$package_name

UNION ALL

select pg.rdb$package_name, 'packaged func', sf.rdb$function_name
from rdb$packages pg
left join rdb$functions sf on pg.rdb$package_name = sf.rdb$package_name
;

PKG_NAME            OBJ_TYPE       OBJ_NAME
==================  =============  ================
. . .               . . .          . . .
RDB$TIME_ZONE_UTIL  packaged func  DATABASE_VERSION
RDB$PROFILER        packaged func  START_SESSION
RDB$BLOB_UTIL       packaged func  IS_WRITABLE
RDB$BLOB_UTIL       packaged func  NEW_BLOB
RDB$BLOB_UTIL       packaged func  OPEN_BLOB
RDB$BLOB_UTIL       packaged func  SEEK
RDB$BLOB_UTIL       packaged func  READ_DATA

None of lines marked as 'packaged func' can be found in SHOW SYSTEM output.
Is it expected ?

Uh oh!

Unify display of system procedures & packages with other system objects #7411

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions