On 10 October 2012 16:07, Dan Kennedy <[email protected]> wrote: > > On 10/10/2012 10:01 PM, Ryan Johnson wrote: >> >> On 10/10/2012 10:49 AM, Dan Kennedy wrote: >>> >>> The easiest workaround is probably to use a temp table to store the >>> unaggregated results of the FTS query. >> >> What about a nested query? > > Actually that will cause a problem too, as the optimizer will > flatten the sub-query.
Is there any way to tell the optimiser to use a temporary table for the sub-select rather than flattening the sub-query? Thank you both for your replies. H _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
