Adrián Medraño Calvo wrote: > The following SQL script shows a query selecting data from a recursive > CTE and filtering it. I expected the optimizer to apply the filter to > the recursive CTE directly, and indeed the documentation of > pushDownWhereTerms (src/select.c:3833) indicates this possibility when > various conditions are satisfied.
Rule 22 of <http://www.sqlite.org/optoverview.html#flattening> forbids subquery flattening in this case. I suspect pushDownWhereTerms() is not called at all. Regards, Clemens _______________________________________________ sqlite-users mailing list email@example.com http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users