Request a Demo
Home   >   mailing lists

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

From Richard Guo
Subject Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
Date
Msg-id CAMbWs48Fe5XQvVBr_a7rMy5zXb4yhGqnFOxd8MLasP7QCCxUOw@mail.gmail.com
Whole thread
In response to Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations  (Tender Wang <tndrwang@gmail.com>)
Responses Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
List pgsql-bugs
Tree view 
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

- Richard

pgsql-bugs by date:

Previous
From: Tender Wang
Date:
Subject: Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations
Next
From: Tender Wang
Date:
Subject: Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations