Hello Clemens, thank you for your answer.
> On 2. Mar 2018, at 11:19, Clemens Ladisch <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
