diff options
author | Peter Eisentraut <peter@eisentraut.org> | 2023-03-10 11:00:51 +0100 |
---|---|---|
committer | Peter Eisentraut <peter@eisentraut.org> | 2023-03-10 11:18:08 +0100 |
commit | 012ee842590d7bb56f250c15e00a8611ba0ae1da (patch) | |
tree | 07cf66667f03f05f2afb7e609b1d75942a18ae62 | |
parent | cd427859745af4574d75e37ec7d427ccd2b8b24a (diff) | |
download | postgresql-012ee842590d7bb56f250c15e00a8611ba0ae1da.tar.gz |
Add a test for UCS_BASIC collation
-rw-r--r-- | src/test/regress/expected/collate.icu.utf8.out | 10 | ||||
-rw-r--r-- | src/test/regress/expected/collate.linux.utf8.out | 10 | ||||
-rw-r--r-- | src/test/regress/sql/collate.icu.utf8.sql | 5 | ||||
-rw-r--r-- | src/test/regress/sql/collate.linux.utf8.sql | 5 |
4 files changed, 30 insertions, 0 deletions
diff --git a/src/test/regress/expected/collate.icu.utf8.out b/src/test/regress/expected/collate.icu.utf8.out index 2ac707b362..f53857b46d 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 2098696ec2..6d34667ceb 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 aa95c1ec42..abf17a0767 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 0f6dd1b02e..2b787507c5 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) |