--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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
>

I just removed for the testing + addDay expects a timestamp, so I
think it is fine.

> >
> >
> > 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
> >
> >
> >
> >
> >
> >
> >
> >
> >