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 <> forbids
subquery flattening in this case.  I suspect pushDownWhereTerms() is not
called at all.

sqlite-users mailing list

Reply via email to