On Wed, Oct 4, 2017 at 12:29 PM, Richard Hipp <d...@sqlite.org> wrote:
> > This restriction on the query flattener causes your example > query above to do what you want. > If subquery-flattening needs to be disabled explicitly, is using "LIMIT -1 OFFSET 0 " the recommended way? > SQLite version 3.21.0 adds new restrictions on the query flattener > which allows the application to control whether expensive functions > (or subqueries) are run before or after sorting. > Is 'expensive' going to be a flag in fourth parameter to create_function like SQLITE_DETERMINISTIC is? Thanks, SK _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users