I think the OP meant to write: "If the expression is an aggregate expression, it is evaluated across all rows in the group. Otherwise, it is evaluated against a single arbitrarily chosen row from within the group. "
Is there a way I could programmatically determine that a query is going to use an arbitrarily chosen row from within the group at query prepare time? Adam On Fri, Nov 27, 2015 at 8:46 AM, Keith Medcalf <kmedcalf at dessus.com> wrote: > > >> Is there a way I could programatically determine that a query is non- >> deterministic at query prepare time? > > What do you mean, non-deterministic? The result is deterministic in all > cases. > > It may be complicated and/or difficult for you to compute, but it is always > deterministic. The result is generated by running an unchanging algorithm on > unchanging data. If there is no random inputs and the computer hardware is > not broken, then the results are entirely determined by the algorithm > executed and the state of the data upon which it is operating. > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- -------------- VerifEye Technologies Inc. 151 Whitehall Dr. Unit 2 Markham, ON L3R 9T1