On 8/26/2015 10:52 AM, Clemens Ladisch wrote: > Domingo Alvarez Duarte wrote: >> This assumption is a bit naive : >> >>> In SQLite, this cannot happen because queries execute infinitely fast >>> (as far as the built-in date/time functions are concerned). > > Nonetheless it's true. > > <http://www.sqlite.org/releaselog/3_8_1.html> says: > | the current time (ex: julianday('now')) is always the same for multiple > | function invocations within the same sqlite3_step() call.
This only says that the time "stands still" for all the calculations necessary to produce a single row - not for the whole SELECT statement, as you seem to have previously implied. -- Igor Tandetnik