On Sat, May 20, 2017 at 2:50 AM, Navrotskiy Artem <bozaro(at)yandex(dot)ru> wrote:
> This is especially unpleasant for expressions using RANK and DENSE_RANK,
> which can not simply be rewritten using LIMIT.
>
They cannot anyway, at least not DENSE_RANK with ties.
Others will have to speak to the dynamics involved with the overall current
behavior.
David J.