agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Cc: 2320415112@qq.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19710: Incorrect DELETE result after LEFT JOIN optimization
Date: Mon, 21 Sep 2026 09:49:42 -0400
Message-ID: <635522.1789998582@sss.pgh.pa.us> (raw)
In-Reply-To: <CAJTYsWWsRMbCPZyLYK7ywjPh3h0THNyj44kGo2F8Mib-OZGeYA@mail.gmail.com>
References: <19710-08547ac48c09de62@postgresql.org>
<CAJTYsWWsRMbCPZyLYK7ywjPh3h0THNyj44kGo2F8Mib-OZGeYA@mail.gmail.com>
Ayush Tiwari <ayushtiwari.slg01@gmail.com> writes:
> On Mon, 21 Sept 2026 at 12:05, PG Bug reporting form <noreply@postgresql.org>
> wrote:
>> On PostgreSQL 17.10, a `DELETE` statement containing an `EXISTS` subquery
>> with two `LEFT JOIN`s deletes a row even though the subquery predicate is
>> false.
> AFAICS this has been fixed[1] and will be part of next minor versions.
Yeah, this example is pretty nearly a duplicate of bug #19560 [1],
which prompted that rewrite.
regards, tom lane
[1] https://www.postgresql.org/message-id/19560-54cd7ede78d5e355%40postgresql.org
view thread (3+ messages)
Message-ID: <635522.1789998582@sss.pgh.pa.us>
Permalink: ../635522.1789998582@sss.pgh.pa.us/
Also on: postgresql.org/message-id/635522.1789998582@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, ayushtiwari.slg01@gmail.com, 2320415112@qq.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19710: Incorrect DELETE result after LEFT JOIN optimization
In-Reply-To: <635522.1789998582@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox