Regression test failure in regression test temp.sql - Mailing list pgsql-hackers

From Michael Paquier
Subject Regression test failure in regression test temp.sql
Date
Msg-id 20190807132422.GC15695@paquier.xyz
Whole thread Raw
Responses Re: Regression test failure in regression test temp.sql
List 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

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: SQL/JSON path: collation for comparisons, minor typos in docs
Next
From: Heikki Linnakangas
Date:
Subject: Re: stress test for parallel workers