Re: [PG19] Wrong results from NOT NULL-based expression simplification

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Guofenglinux <guofenglinux(at)gmail(dot)com>
Subject: Re: [PG19] Wrong results from NOT NULL-based expression simplification
Date: 2026-10-07 15:41:19
Message-ID: CAAKRu_aFbZLHJMR4ggaM-i9a1A9uX19SARFsLrSCUa39wsbmQQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 5, 2026 at 11:28 PM shihao zhong <zhong950419(at)gmail(dot)com> wrote:
>
> I used Opus to analyze the new features in PG19, and it found five
> queries that work on 18 and break on 19 and master. Each item has a
> script and a patch with its number.

Seems like there are a number of issues in this thread but so far I
see only one open item for the whole thing. Should there be more than
one open item?

- Melanie

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Geier 2026-10-07 15:41:53 Re: [PROPOSAL] Expand OR clauses in joins to UNION ALL paths
Previous Message Nathan Bossart 2026-10-07 15:40:38 Re: REPACK (CONCURRENTLY) can't complete after ~105M concurrent updates/deletes