Re: CLUSTER sort on abbreviated expressions is broken

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CLUSTER sort on abbreviated expressions is broken
Date: 2022-04-03 22:04:04
Message-ID: CA+hUKGL7OUwdHx5zj19ADKejNN7uOTSKcaadqeOVV9oeMVNGGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Apr 3, 2022 at 8:22 PM John Naylor <john(dot)naylor(at)enterprisedb(dot)com> wrote:
> On Sun, Apr 3, 2022 at 11:05 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> > Independently of a problem with a recent commit, it seems that
> > $SUBJECT in all releases (well, I only tested as far back as 11).
>
> I can confirm the problem on v10 as well.

Thanks for confirming. I got as far as seeing that the two calls to
FormIndexDatum() are producing garbage in {l,r}_index_values, in the
loop at the end of comparetup_cluster(), but I'll have to come back to
this after some other stuff.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joseph Koshakow 2022-04-03 22:19:54 Re: Fix overflow in DecodeInterval
Previous Message Tomas Vondra 2022-04-03 21:40:43 Re: logical decoding and replication of sequences