> Can somebody do this test? 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.
>

why do you not cast date_in as a date in the first addday run?
Alan

>
>
> 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 ; !!
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>