You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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;
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
The text was updated successfully, but these errors were encountered: