Postgres Pro
Downloads
Home   >   mailing lists

Re: v17 Possible Union All Bug - Mailing list pgsql-bugs

From David Rowley
Subject Re: v17 Possible Union All Bug
Date
Msg-id CAApHDvoJ21egQX=Mf015PBVY_9AoPhrdw-3Xpxr+Re_UjvnFTQ@mail.gmail.com
Whole thread Raw
In response to Re: v17 Possible Union All Bug  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: v17 Possible Union All Bug  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-bugs
Tree view 
On Sat, 27 Jan 2024 at 11:33, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> Simply commenting out the ORDER BY clause in the string_agg causes the correct result to appear, even with the UNION
ALLpresent.  Removing the union all and leaving the order by likewise still produces the correct result.
 

Are the results correct if you SET enable_presorted_aggregate=0;?

David

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: v17 Possible Union All Bug
Next
From: David Rowley
Date:
Subject: Re: v17 Possible Union All Bug