Re: UNION removes almost all rows (not duplicates) - in fresh build of pg17!

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: pgsql-bugs mailing list <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: UNION removes almost all rows (not duplicates) - in fresh build of pg17!
Date: 2024-05-21 10:38:51
Message-ID: Zkx5u5kqtDcipxel@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-05-21 11:44:47 BUG #18473: Problems deployment postgresql for windows
Previous Message Japin Li 2024-05-21 10:32:12 Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption