Regression test failure in regression test temp.sql

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Regression test failure in regression test temp.sql
Date: 2019-08-07 13:24:22
Message-ID: 20190807132422.GC15695@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

While browsing the buildfarm failures, I have found this problem on
anole for the test temp:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=anole&dt=2019-08-07%2006%3A39%3A35
select relname from pg_class where relname like 'temp_parted_oncommit_test%';
relname
----------------------------
- temp_parted_oncommit_test
temp_parted_oncommit_test1
(2 rows)

drop table temp_parted_oncommit_test;
--- 276,283 ----
select relname from pg_class where relname like 'temp_parted_oncommit_test%';
relname
----------------------------
temp_parted_oncommit_test1
+ temp_parted_oncommit_test
(2 rows)

This could be solved just with an ORDER BY as per the attached. Any
objections?

Thanks,
--
Michael

Attachment Content-Type Size
temp-partition-test.patch text/x-diff 1.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2019-08-07 13:30:46 Re: stress test for parallel workers
Previous Message Alexander Korotkov 2019-08-07 13:11:44 Re: SQL/JSON path: collation for comparisons, minor typos in docs