> On Sep 12, 2017, at 12:58 PM, Warren Young <war...@etr-usa.com> wrote: > > Could it be *extended* to mean what you want? Of course, but that means > you’re asking for a feature, not reporting a bug.
I never claimed to be reporting a bug! The subject line refers to this as an "optimization", and in the initial message I said "it would be a noticeable speedup". I pointed out the SQLITE_DETERMINISTIC flag because it already gives the query optimizer the information it would need to detect that a function call is pure and can safely be factored out. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users