From: hubert depesz lubaczewski <depesz@depesz.com>
To: David Rowley <dgrowleyml@gmail.com>
Cc: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: Re: UNION removes almost all rows (not duplicates) - in fresh build of pg17!
Date: Tue, 21 May 2024 12:38:51 +0200
Message-ID: <Zkx5u5kqtDcipxel@depesz.com> (raw)
In-Reply-To: <CAApHDvpDQh1NcL7nAsd3YAKj4vgORwesB3GYuNPnEXXRfA2g4w@mail.gmail.com>
References: <Zktzf926vslR35Fv@depesz.com>
<CAApHDvpDQh1NcL7nAsd3YAKj4vgORwesB3GYuNPnEXXRfA2g4w@mail.gmail.com>
On Tue, May 21, 2024 at 09:54:25AM +1200, David Rowley wrote:
> Thanks for the report.
> It looks like it's a very simple fix. The problem is I wasn't setting
> groupList when the grouping_is_sortable() returned false. In the
> prior version, make_union_unique() always set that.
> The attached should apply cleanly up to d2a04470a.
Hi,
tested, and can confirm that applying this patch on top of
d2a04470aa6401c1938cc107e0b2c56c22a2321f solved the problem.
Best regards,
depesz
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: depesz@depesz.com, dgrowleyml@gmail.com
Subject: Re: UNION removes almost all rows (not duplicates) - in fresh build of pg17!
In-Reply-To: <Zkx5u5kqtDcipxel@depesz.com>
* 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