[sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Stephan Beal
Hi, all, Regarding SQLITE_DETERMINISTIC: http://www.sqlite.org/c3ref/create_function.html does specifying that flag guaranty that sqlite3 will only call my "deterministic" function one time during any given SQL statement, or must my function actually guaranty that deterministic behaviour itself?

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Richard Hipp
On Mon, Feb 17, 2014 at 11:47 AM, Stephan Beal wrote: > Hi, all, > > Regarding SQLITE_DETERMINISTIC: > > http://www.sqlite.org/c3ref/create_function.html > > does specifying that flag guaranty that sqlite3 will only call my > "deterministic" function one time during any given SQL statement, or mus

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread RSmith
On 2014/02/17 18:47, Stephan Beal wrote: Hi, all, Regarding SQLITE_DETERMINISTIC: http://www.sqlite.org/c3ref/create_function.html does specifying that flag guaranty that sqlite3 will only call my "deterministic" function one time during any given SQL statement, or must my function actually g

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Stephan Beal
On Mon, Feb 17, 2014 at 6:23 PM, RSmith wrote: > The flag is telling SQLite that your function will behave > determinsitcally, i.e. it won't change the output for the same inputs > within a single query. > i figured so, just wanted to be sure. > SQLite then uses this information to "maybe" cac