Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations - Mailing list pgsql-bugs

Richard Guo <guofenglinux@gmail.com> 于2026年6月29日周一 09:41写道：
>
> On Mon, Jun 29, 2026 at 10:23 AM Tender Wang <tndrwang@gmail.com> wrote:
> > The correct result is the most important thing. So I agree with you.
> > The fix seems obvious: we should refuse quals pushed down to the
> > subquery if the quals contain a nondeterministic partition clause var.
>
> This class of bug is currently being discussed and addressed on thread
> [1].  I suggest we consolidate the discussion there to avoid
> duplicating effort.
>
> [1] https://postgr.es/m/CAMbWs49dHFVVwx9MjYmvUrZu0L4vZTbGVyhj3T2SsWgS1Bzhzg@mail.gmail.com
>

I had noticed the thread [1] before writing a patch to fix this issue.
But I thought it was a different problem at that time.
We can shift our gaze to the thread [1]. It seems it handles all kinds
of collation problems.



--
Thanks,
Tender Wang