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

ISQL: change results of SHOW FUNC command like they are in SHOW PROC one [CORE4499] #4818

Closed
firebird-automations opened this issue Jul 24, 2014 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Compare results of SHOW PROC vs SHOW FUNC in ISQL:

SQL> set term ^; create or alter procedure p01(x int) returns (z int) as begin z=x*2; suspend; end^
SQL> set term ;^
SQL> commit;
SQL> show proc p01;
Procedure text:

begin z=x*2; suspend; end

Parameters:
X INPUT INTEGER
Z OUTPUT INTEGER

=== vs ===

SQL> set term ^; create or alter function f01(x int) returns int as begin return x*2; end^
SQL> set term ;^
SQL> commit;
SQL> show function f01;

Function F01:
Function library is
Entry point is
Returns BY VALUE
Argument 1: BY VALUE

Is it possible to display results for `SHOW FUNC` command in such manner as for `SHOW PROC` ? (i.e. show body and in-out arguments just like in SHOW PROC)

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

priority: Major [ 3 ] => Minor [ 4 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @mrotteveel

As this should also work for UDF with an external library, where information like Entry point etc is important, I think the current information should still be displayed if it is a UDF with an external library.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

What version are you using?

This should be done for a not so short time.

SQL> show function f01!
Function text:

begin return x*2; end

Parameters:
OUTPUT INTEGER
X INPUT INTEGER

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Currently I'm using LI-T3.0.0.31250.
And - yes, now SHOW FUNC <F> command works fine.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

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

1 participant