postgrespro.git / summary / log / commit / refs

commit    836f634522d2f07efdec2f41d63b582aac95e546
Author:   Andres Freund <andres@anarazel.de>
Date:     Wed Mar 06 19:06:01 2019 +0000

    Fix collation dependency in test introduced in 8586bf7ed8.
    
    Per buildfarm.


 src/test/regress/expected/create_am.out | 4 ++--
 src/test/regress/sql/create_am.sql      | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/test/regress/expected/create_am.out b/src/test/regress/expected/create_am.out
index 8a63cedb56..cf8b0ff91b 100644
--- a/src/test/regress/expected/create_am.out
+++ b/src/test/regress/expected/create_am.out
@@ -173,7 +173,7 @@ SELECT
         (SELECT 'toast for ' || relname::regclass FROM pg_class pcm WHERE pcm.reltoastrelid = pc.oid)
     ELSE
         relname::regclass::text
-    END AS relname
+    END COLLATE "C" AS relname
 FROM pg_class AS pc,
     pg_am AS pa
 WHERE pa.oid = pc.relam
@@ -183,8 +183,8 @@ ORDER BY 3, 1, 2;
 ---------+--------+----------------------------------
  r       | heap2  | tableam_parted_b_heap2
  r       | heap2  | tableam_parted_d_heap2
- r       | heap2  | tableam_tblas_heap2
  r       | heap2  | tableam_tbl_heap2
+ r       | heap2  | tableam_tblas_heap2
  m       | heap2  | tableam_tblmv_heap2
  t       | heap2  | toast for tableam_parted_b_heap2
  t       | heap2  | toast for tableam_parted_d_heap2
diff --git a/src/test/regress/sql/create_am.sql b/src/test/regress/sql/create_am.sql
index 516401ddfe..9d7778fdfe 100644
--- a/src/test/regress/sql/create_am.sql
+++ b/src/test/regress/sql/create_am.sql
@@ -123,7 +123,7 @@ SELECT
         (SELECT 'toast for ' || relname::regclass FROM pg_class pcm WHERE pcm.reltoastrelid = pc.oid)
     ELSE
         relname::regclass::text
-    END AS relname
+    END COLLATE "C" AS relname
 FROM pg_class AS pc,
     pg_am AS pa
 WHERE pa.oid = pc.relam


[parent: 3b925e905de3]