Hello Clemens, thank you for your answer.
> On 2. Mar 2018, at 11:19, Clemens Ladisch <clem...@ladisch.de> wrote: > > Rule 22 of <http://www.sqlite.org/optoverview.html#flattening> forbids > subquery flattening in this case. I suspect pushDownWhereTerms() is not > called at all. Although this is definitely over my level of understanding of SQLite optimization, I can affirm that `pushDownWhereTerms` is invoked exactly once for the above query (checked with a debugger). It aborts as soon as it detects that the subquery is recursive, and rightly so (see Dan’s answer). Thank you, Adrián. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users