On Mon, Sep 16, 2013 at 11:14 AM, Jean-Christophe Deschamps <
[email protected]> wrote:
> Perhaps a new connection-wide "pragma freeze_now=ON;" which would freeze
> 'now' at the beginning of the next statement and unfreeze it at the next
> auto-commit or when processing a "pragma freeze_now=OFF;" would solve
> another part of the race issue.
>
There are other ways to get a consistent 'now' across an entire SQL
statement:
(1) Run "SELECT julianday('now')" separately, then bind the result into
your SQL statement in place of the 'now' strings.
(2) Enclose the date and time functions in a subquery: SELECT (SELECT
timestamp('now')), * FROM tab;
This issue is sufficiently obscure that it is not worth adding (and testing
and documenting and supporting forever) yet another pragma.
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
