Re: [sqlite] SQLITE_DETERMINISTIC sticky in sqlite3_create_function?

> On Sep 12, 2017, at 12:23 PM, Nelson, Erik - 2 > wrote: > >> select user() > .54 <-- should this result be the same as the previous call to user()? Or > would it get evaluated once after each sqlite3_create_function() call? It gets evaluated whenever the

[sqlite] SQLITE_DETERMINISTIC sticky in sqlite3_create_function?

If I'm redefining a user-defined function as SQLITE_DETERMINISTIC before each query, will the function still get called for subsequent queries? For example, if I had void user_func(sqlite3_context *context, int argc, sqlite3_value **argv){ return random() } sqlite3_create_function(db,