Re: reconsider_full_join_clause fails to consider if COALESCE() arguments are NULL-preserving

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: reconsider_full_join_clause fails to consider if COALESCE() arguments are NULL-preserving
Date: 2026-11-12 12:57:38
Message-ID: 3b2e6e6e-57ab-4160-bc73-43159bd20112@vondra.me
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/12/26 11:28, Tomas Vondra wrote:
>
> ...
>
> I suppose an expression walker that does not descend into PlaceHolderVar
> nodes (with phlevelsup = 0) would make this work correctly.
>
Here's v3 doing it that way.

--
Tomas Vondra

Attachment Content-Type Size
v3-15-0001-Fix-FULL-JOIN-constant-propagation-with-non-st.patch text/x-patch 13.2 KB
v3-master-0001-Fix-FULL-JOIN-constant-propagation-with-no.patch text/x-patch 12.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Jan Nidzwetzki 2026-11-12 12:22:38 Re: improving handling of FPIs during recovery prefetching