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(+)
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 |