RE: BUG #16627: union all with partioned table yields random aggregate results

Hi, confirming it happens in 11.9 and 12.4.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, September 22, 2020 10:54 AM
To: kanaga@consumeracquisition.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16627: union all with partioned table yields random
aggregate results

PG Bug reporting form <noreply@postgresql.org> writes:
> The following bug has been logged on the website:
> Bug reference:      16627
> Logged by:          Brian Kanaga
> Email address:      kanaga@consumeracquisition.com
> PostgreSQL version: 11.4
> Operating system:   Linux
> Description:

> Hoping this is something already discovered as the amount of data to
> recreate is cumbersome.

Well, 11.4 is more than a year out of date.  Can you still reproduce this
on the current minor release (11.9)?

            regards, tom lane