pgsql: Add tests for foreign keys with case-insensitive collations

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add tests for foreign keys with case-insensitive collations
Date: 2024-11-29 07:59:11
Message-ID: E1tGvuB-0007o8-B1@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add tests for foreign keys with case-insensitive collations

Some of the behaviors of the different referential actions, such as
the difference between NO ACTION and RESTRICT are best illustrated
using a case-insensitive collation. So add some tests for that.

(What is actually being tested here is the behavior with values that
are "distinct" (binary different) but compare as equal. Another way
to do that would be with positive and negative zeroes with float
types. But this way seems nicer and more flexible.)

Discussion: https://www.postgresql.org/message-id/ea5b2777-266a-46fa-852f-6fca6ec480ad@eisentraut.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4a2dbfc6be45c4ce2d9ac53502f931e6b1d70318

Modified Files
--------------
src/test/regress/expected/collate.icu.utf8.out | 62 ++++++++++++++++++++++++++
src/test/regress/sql/collate.icu.utf8.sql | 30 +++++++++++++
2 files changed, 92 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Richard Guo 2024-11-29 08:22:52 Re: pgsql: Avoid mislabeling of lateral references when pulling up a subque
Previous Message Alexander Korotkov 2024-11-29 07:52:24 pgsql: Skip not SOAP-supported indexes while transforming an OR clause