Re: CLUSTER sort on abbreviated expressions is broken

Peter Geoghegan <pg@bowt.ie>

From: Peter Geoghegan <pg@bowt.ie>

To: Thomas Munro <thomas.munro@gmail.com>

Cc: John Naylor <john.naylor@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2022-04-21T00:18:07Z

Lists: pgsql-hackers

On Tue, Apr 12, 2022 at 11:01 AM Peter Geoghegan <pg@bowt.ie> wrote:
> Attached patch fixes the issue, and includes the test case that you posted.

Pushed a similar patch just now. Backpatched to all supported branches.

-- 
Peter Geoghegan

Commits

Fix CLUSTER tuplesorts on abbreviated expressions.
- 8ab0ebb9a842 15.0 landed
- e4521841a1ee 14.3 landed
- 1272630a2497 13.7 landed
- 5487585e376d 12.11 landed
- adb2d84fc2d6 11.16 landed
- a903895b3fe4 10.21 landed
Fix tuplesort optimization for CLUSTER-on-expression.
- cc58eecc5d75 15.0 cited