Re: Wrong results from self-join elimination with inheritance and ONLY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tender Wang <tndrwang(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Subject: Re: Wrong results from self-join elimination with inheritance and ONLY
Date: 2026-10-14 20:39:10
Message-ID: 1629810.1792010350@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tender Wang <tndrwang(at)gmail(dot)com> writes:
> I found a wrong-result case in self-join elimination involving an
> inheritance scan and an ONLY scan.

Pushed, thanks for the report.

(I left out the proposed regression tests, which seemed much too
heavyweight for a one-line change.)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2026-10-14 20:46:33 Re: updates for handling optional argument in system functions
Previous Message Masahiko Sawada 2026-10-14 20:31:09 Re: Parallel vacuum: avoid dangling shared memory pointers