Re: DISTINCT aggregate crashes when ORDER BY repeats its argument

On Fri, 6 Nov 2026 at 06:22, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com> wrote:
> This crashes the backend on master:
>
> CREATE TABLE t (x text);
> INSERT INTO t VALUES ('a'), ('a'), ('b');
> SELECT array_agg(DISTINCT x ORDER BY x USING ~<~, x USING <)
> FROM t;

Thanks. I've gone over that and added a test for multiple ORDER BY
columns without DISTINCT. Adjusted a few comments, made the required
adjustments for v14 and v15, and pushed.

David