On 15 Sep 2013, at 12:58pm, Yuriy Kaminskiy <yum...@gmail.com> wrote:
> Wow. Are you *REALLY* arguing that > SELECT * FROM t WHERE CURRENT_TIME <> CURRENT_TIME; > that randomly (!) returning rows any less broken than > SELECT * FROM t WHERE 2*2 <> 4; > also randomly returning rows? I was, because the word 'current' means 'now' and 'now' changes with time. However, Kees found a reference in the SQL standard that defines CURRENT_TIME, and shows that it doesn't really mean 'CURRENT' _TIME, it means something more like STATEMENT_TIME and must be constant throughout any one particular statement. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users