postgres
diff --git a/‎src/test/regress/expected/collate.icu.utf8.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/collate.icu.utf8.out
+10Lines changed: 10 additions & 0 deletions b/‎src/test/regress/expected/collate.icu.utf8.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/collate.icu.utf8.out
+10Lines changed: 10 additions & 0 deletions
diff --git a/‎src/test/regress/expected/collate.linux.utf8.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/collate.linux.utf8.out
+10Lines changed: 10 additions & 0 deletions b/‎src/test/regress/expected/collate.linux.utf8.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/collate.linux.utf8.out
+10Lines changed: 10 additions & 0 deletions
diff --git a/‎src/test/regress/sql/collate.icu.utf8.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/collate.icu.utf8.sql
+5Lines changed: 5 additions & 0 deletions b/‎src/test/regress/sql/collate.icu.utf8.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/collate.icu.utf8.sql
+5Lines changed: 5 additions & 0 deletions
diff --git a/‎src/test/regress/sql/collate.linux.utf8.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/collate.linux.utf8.sql
+5Lines changed: 5 additions & 0 deletions b/‎src/test/regress/sql/collate.linux.utf8.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/collate.linux.utf8.sql
+5Lines changed: 5 additions & 0 deletions
@@ -1141,6 +1141,16 @@ select textrange_en_us('A','Z') @> 'b'::text;
 
 drop type textrange_c;
 drop type textrange_en_us;
+-- standard collations
+SELECT * FROM collate_test2 ORDER BY b COLLATE UCS_BASIC;
+ a |  b  
+---+-----
+ 4 | ABC
+ 1 | abc
+ 3 | bbc
+ 2 | äbc
+(4 rows)
+
 -- test ICU collation customization
 -- test the attributes handled by icu_set_collation_attributes()
 CREATE COLLATION testcoll_ignore_accents (provider = icu, locale = '@colStrength=primary;colCaseLevel=yes');
 
@@ -1154,6 +1154,16 @@ select textrange_en_us('A','Z') @> 'b'::text;
 
 drop type textrange_c;
 drop type textrange_en_us;
+-- standard collations
+SELECT * FROM collate_test2 ORDER BY b COLLATE UCS_BASIC;
+ a |  b  
+---+-----
+ 4 | ABC
+ 1 | abc
+ 3 | bbc
+ 2 | äbc
+(4 rows)
+
 -- nondeterministic collations
 -- (not supported with libc provider)
 CREATE COLLATION ctest_det (locale = 'en_US.utf8', deterministic = true);
 
@@ -444,6 +444,11 @@ drop type textrange_c;
 drop type textrange_en_us;
 
 
+-- standard collations
+
+SELECT * FROM collate_test2 ORDER BY b COLLATE UCS_BASIC;
+
+
 -- test ICU collation customization
 
 -- test the attributes handled by icu_set_collation_attributes()
 
@@ -447,6 +447,11 @@ drop type textrange_c;
 drop type textrange_en_us;
 
 
+-- standard collations
+
+SELECT * FROM collate_test2 ORDER BY b COLLATE UCS_BASIC;
+
+
 -- nondeterministic collations
 -- (not supported with libc provider)