> > select id, (select id from TestTable where id = abs(random() % 100)) > > as rndid from TestTable where id=rndid
On Thu, 13 Feb 2014 07:26:55 -0500 Richard Hipp <d...@sqlite.org> wrote: > It is undefined behavior, subject to change depending the specific > version of SQLite, compile-time options, optimization settings, and > the whim of the query planner. It should be defined. In the above query, random() should be evaluated once. In the SQL model the user provides inputs once, and the system evaluates them once. This issue seems to have a way of returning. Didn't we recently discuss it with regard to time? --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users