Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tender Wang <tndrwang(at)gmail(dot)com>
Cc: Chengpeng Yan <chengpeng_yan(at)outlook(dot)com>, "imchifan(at)163(dot)com" <imchifan(at)163(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
Date: 2026-06-29 01:41:07
Message-ID: CAMbWs48Fe5XQvVBr_a7rMy5zXb4yhGqnFOxd8MLasP7QCCxUOw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jun 29, 2026 at 10:23 AM Tender Wang <tndrwang(at)gmail(dot)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

- Richard

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tender Wang 2026-06-29 01:53:11 Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
Previous Message Tender Wang 2026-06-29 01:22:49 Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations