On 10 October 2012 16:07, Dan Kennedy <danielk1...@gmail.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
