Re: v17 Possible Union All Bug

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: v17 Possible Union All Bug
Date: 2024-01-27 00:19:13
Message-ID: CAApHDvoJ21egQX=Mf015PBVY_9AoPhrdw-3Xpxr+Re_UjvnFTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, 27 Jan 2024 at 11:33, David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> Simply commenting out the ORDER BY clause in the string_agg causes the correct result to appear, even with the UNION ALL present. 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2024-01-27 00:36:22 Re: v17 Possible Union All Bug
Previous Message David G. Johnston 2024-01-26 22:32:56 Re: v17 Possible Union All Bug