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 doesn't know the difference between UDF's and psql-functions [CORE3963] #4296

Closed
firebird-automations opened this issue Oct 29, 2012 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Frank Schlottmann-Goedde (fsg)

Using the following script in isql against the employee database shows the issue:

/*
isql doesn't know the difference between UDF's and psql-functions

SQL> show functions;
ABS QR

SQL> show function abs;

Function ABS:
Function library is ib_udf
Entry point is IB_UDF_abs
Returns BY VALUE DOUBLE PRECISION
Argument 1: DOUBLE PRECISION
SQL> show function qr;

Function QR:
Function library is
Entry point is
Returns BY VALUE DOUBLE PRECISION
Argument 1: BY VALUE DOUBLE PRECISION

*/

drop function "ABS";
drop function qr;
commit;

set term^;

DECLARE EXTERNAL FUNCTION "ABS"
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';

create function qr (inp double precision) returns double precision
as
declare variable out double precision;
begin
out=inp*inp;
return out ;
end^
set term; ^
commit;
show functions;
show function abs;
show function qr;
exit;

Commits: 681695e FirebirdSQL/fbt-repository@d8a7976

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

Fix Version: 3.0.1 [ 10730 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0.1 [ 10730 ] =>

Fix Version: 4.0 Alpha 1 [ 10731 ] =>

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

2 participants