On 18 Feb 2019, at 4:22pm, Arun - Siara Logics (cc) <[email protected]> wrote:
> Do you mean to say SQLite might keep function results across queries? It depends where you use it. See section 4 of <https://sqlite.org/deterministic.html> However, the documentation should prepare you for the idea that you cannot predict whether a deterministic function will be called. SQLite may not optimize out calls now, but it may do so in the future. If you don't like this idea, don't mark your function as deterministic. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
