2010/3/21 Daniel Farina <drfarina@acm.org>:
> In the function "subquery_is_pushdown_safe", there is an immediate
> "false" returned if the subquery has a windowing function. While that
> seems true in general, are there cases where we can push down a qual
> if it is on the partitioning key? Or do NULLs or some other detail
> get in the way?
Ugh, that seems true. In similar case you can push down WHERE clause
of outer query to subquery if the qual clause match GROUP BY clause.
This is done by transforming outer WHERE -> HAVING -> inner WHERE.
However, window function querys don't have such clause as HAVING of
aggregate. If you implement that optimization, we need have kind of
implicit, homologous qual information. Sure, it's possible.
Regards,
--
Hitoshi Harada
