From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: mtakahar@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18465: Wrong results from SELECT DISTINCT MIN in scalar subquery using HashAggregate
Date: Sat, 18 May 2024 12:56:44 -0400
Message-ID: <2787680.1716051404@sss.pgh.pa.us> (raw)
In-Reply-To: <20240518141801.cobd5aup2pnogeo2@ddolgov.remote.csb>
References: <18465-2fae927718976b22@postgresql.org>
<20240518141801.cobd5aup2pnogeo2@ddolgov.remote.csb>
Dmitry Dolgov <9erthalion6@gmail.com> writes:
> Thanks, I could reproduce this in v15 and v16. Interestingly enough it
> was fixed in d0d44049d1, but looks like due to lack of error reports the
> fix was applied only on the main branch. I assume this one makes it
> necessary to back-patch the fix.
Hah. Nothing like fixing a bug that you know is there but you can't
demonstrate it ;-). I confirm the problem appears in d0d44049d1^
(and at least as far back as v12), but not in d0d44049d1 or HEAD.
So yeah, add test case and back-patch.
Many thanks for the test case!
regards, tom lane
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, 9erthalion6@gmail.com, mtakahar@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18465: Wrong results from SELECT DISTINCT MIN in scalar subquery using HashAggregate
In-Reply-To: <2787680.1716051404@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox