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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, September 22, 2020 10:54 AM
To: kanaga(at)consumeracquisition(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16627: union all with partioned table yields random
aggregate results

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> The following bug has been logged on the website:
> Bug reference: 16627
> Logged by: Brian Kanaga
> Email address: kanaga(at)consumeracquisition(dot)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