New isolation test insert-conflict-do-update-4 outputs rows in alternative ordering - Mailing list pgsql-hackers

From Pavel Borisov
Subject New isolation test insert-conflict-do-update-4 outputs rows in alternative ordering
Date
Msg-id CALT9ZEHcE6tpvumScYPO6pGk_ASjTjWojLkodHnk33dvRPHXVw@mail.gmail.com
Whole thread Raw
Responses Re: New isolation test insert-conflict-do-update-4 outputs rows in alternative ordering
Re: New isolation test insert-conflict-do-update-4 outputs rows in alternative ordering
List pgsql-hackers
Hi, hackers!

New isolation test insert-conflict-do-update-4 was added by commit 4b760a181ab2

Unlike the previous test (insert-conflict-do-update-3) it doesn't
contain an ordering clause, and when run on a table with a custom
access method, it outputs results in a reverse order.

It's a very minor issue, and the proposed fix is just adding the
missing ORDER BY clause.

Other insert-conflict-do-* isolation tests output just one row except
the mentioned insert-conflict-do-update-3 and
insert-conflict-do-update-4.

The patch is attached

Kind regards,
Pavel Borisov
Supabase

Attachment

pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Fix bug of clearing of waitStart in ProcWakeup()
Next
From: Andrew Dunstan
Date:
Subject: Re: Add errdetail() with PID and UID about source of termination signal