Re: Self-join elimination drops an equality qual

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Jacob Brazeal <jacob(dot)brazeal(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Self-join elimination drops an equality qual
Date: 2026-07-26 15:41:57
Message-ID: CAPpHfdvZ-Z8C3rUuotO0N2rJtDsX9ayY=Crq9r4CZLPeSKMc-A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Jul 26, 2026 at 3:10 AM Jacob Brazeal <jacob(dot)brazeal(at)gmail(dot)com> wrote:
> Great! We can close this discussion then, I think. Thank you for looking and for your work on the other thread.

+1,
I've rechecked. The bug was caused by add_non_redundant_clauses()
interpreting clauses of same equivalence class as duplicates. The
patchset [1] removes add_non_redundant_clauses().

[1] https://www.postgresql.org/message-id/2727652.1784997994%40sss.pgh.pa.us

------
Regards,
Alexander Korotkov
Supabase

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Rui Zhao 2026-07-26 15:33:21 Re: [PATCH] Preserve replication origin OIDs in pg_upgrade