[Firebird-test] Memory Usage Test

[Joga S. <jog...@in...>]

Can somebody do this test for me? There seems to be some memory leak in the
udf 'addDay'(fbudf comes with firebird). If I call the Stored
Procedure given below in a loop, memory usage of firebird (using top
command in linux) crosses 100MB in a few minutes. When I comment the
statement calling 'addDay', there is no memory increase.



JS

-------------------------------------
SET TERM !!;

CREATE OR ALTER PROCEDURE testget_maxdate RETURNS (retval int)
AS
declare date_in timestamp;
declare ret_in timestamp;
begin
date_in=current_timestamp;
ret_in=addday(date_in,1);
-- ret_in=addday(cast(date_in as date),1);
-- ret_in=addmillisecond(addday(cast(date_in as date),1),-1);
retval=1;
SUSPEND;
end !!

SET TERM ; !!