postgres.git / summary / log / commit / refs
commit 012ee842590d7bb56f250c15e00a8611ba0ae1da
Author: Peter Eisentraut <peter@eisentraut.org>
Date: Fri Mar 10 10:00:51 2023 +0000
First released in: 16.0
Add a test for UCS_BASIC collation
src/test/regress/expected/collate.icu.utf8.out | 10 ++++++++++
src/test/regress/expected/collate.linux.utf8.out | 10 ++++++++++
src/test/regress/sql/collate.icu.utf8.sql | 5 +++++
src/test/regress/sql/collate.linux.utf8.sql | 5 +++++
4 files changed, 30 insertions(+)
diff --git a/src/test/regress/expected/collate.icu.utf8.out b/src/test/regress/expected/collate.icu.utf8.out
index 2ac707b3628..f53857b46dd 100644
--- a/src/test/regress/expected/collate.icu.utf8.out
+++ b/src/test/regress/expected/collate.icu.utf8.out
@@ -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');
diff --git a/src/test/regress/expected/collate.linux.utf8.out b/src/test/regress/expected/collate.linux.utf8.out
index 2098696ec25..6d34667cebc 100644
--- a/src/test/regress/expected/collate.linux.utf8.out
+++ b/src/test/regress/expected/collate.linux.utf8.out
@@ -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);
diff --git a/src/test/regress/sql/collate.icu.utf8.sql b/src/test/regress/sql/collate.icu.utf8.sql
index aa95c1ec420..abf17a0767a 100644
--- a/src/test/regress/sql/collate.icu.utf8.sql
+++ b/src/test/regress/sql/collate.icu.utf8.sql
@@ -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()
diff --git a/src/test/regress/sql/collate.linux.utf8.sql b/src/test/regress/sql/collate.linux.utf8.sql
index 0f6dd1b02e2..2b787507c55 100644
--- a/src/test/regress/sql/collate.linux.utf8.sql
+++ b/src/test/regress/sql/collate.linux.utf8.sql
@@ -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)
[parent: cd427859745a]