Re: Function Volatility Stable vs Immutable

On Mon, Jun 24, 2019 at 7:31 PM Igal @ Lucee.org <igal(at)lucee(dot)org> wrote:

> If a function select data from a table, and the rows in the table may
> change, would that function qualify for Immutable or does it have to be
> Stable? I'm asking because according to the docs [1]: "An IMMUTABLE
> function cannot modify the database and is guaranteed to return the same
> results given the same arguments forever".
>
> So for the same arguments, the result would change only if the data in
> the table changes. Does that mean that it violates the "forever" clause
> and therefore can be only marked as Stable and not Immutable?
>

Yes

Forever means beyond the lifetime of a single transaction and thus it is
possible for the changing of the table contents to impact the return value
of the function.

David J.