public inbox for [email protected]  

help / color / mirror / Atom feed
From: Tender Wang <[email protected]>
To: Richard Guo <[email protected]>
Cc: Chengpeng Yan <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
Date: Mon, 29 Jun 2026 09:53:11 +0800
Message-ID: <CAHewXNmaG=U6ZfBJsFyhQ=Bx0+HKR_be_UsGG7qvAX76QuAvbA@mail.gmail.com> (raw)
In-Reply-To: <CAMbWs48Fe5XQvVBr_a7rMy5zXb4yhGqnFOxd8MLasP7QCCxUOw@mail.gmail.com>
References: <[email protected]>
	<CAHewXNk8xt1pNepcEiCx_e6_SW_=bm1GNnU7+bPczoZJuLC5qQ@mail.gmail.com>
	<[email protected]>
	<CAHewXN=xpqkC5FKc3st1zXrixgR-8Y_NEw_08vCCoPE-dcZccA@mail.gmail.com>
	<CAMbWs48Fe5XQvVBr_a7rMy5zXb4yhGqnFOxd8MLasP7QCCxUOw@mail.gmail.com>

Richard Guo <[email protected]> 于2026年6月29日周一 09:41写道：
>
> On Mon, Jun 29, 2026 at 10:23 AM Tender Wang <[email protected]> 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






view thread (6+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
  In-Reply-To: <CAHewXNmaG=U6ZfBJsFyhQ=Bx0+HKR_be_UsGG7qvAX76QuAvbA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox