Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

'SHOW SYSTEM' command: provide list of functions belonging to system packages #7475

Closed
pavel-zotov opened this issue Feb 16, 2023 · 2 comments

Comments

@pavel-zotov
Copy link

Packaged functions currently aren't shown in the output of SHOW SYSTEM (unlike packaged procedures).
It will be good if they also will be displayed there.
Currently system packages and their functions can be obtained using query:

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

PS.
Ticked was created after discussion in #7411

@AlexPeshkoff
Copy link
Member

Also unified display format for functions & procedures, made it a bit better readable when dealing with packages.

@pavel-zotov
Copy link
Author

QA: test not needed. Issue is covered by functional/basic/isql/test_02.py and test_03.py

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants