RE: BUG #16627: union all with partioned table yields random aggregate results - Mailing list pgsql-bugs

From Brian Kanaga
Subject RE: BUG #16627: union all with partioned table yields random aggregate results
Date
Msg-id dda61b8f42c63bd8640e283336c64539@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16627: union all with partioned table yields random aggregate results  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16627: union all with partioned table yields random aggregate results  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16627: union all with partioned table yields random aggregate results
Next
From: Tom Lane
Date:
Subject: Re: BUG #16627: union all with partioned table yields random aggregate results