Add tests for foreign keys with case-insensitive collations
authorPeter Eisentraut <peter@eisentraut.org>
Fri, 29 Nov 2024 07:52:27 +0000 (08:52 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Fri, 29 Nov 2024 07:52:55 +0000 (08:52 +0100)
commit4a2dbfc6be45c4ce2d9ac53502f931e6b1d70318
tree7a7c5e81d4ddcab265850fb480affe6dedfbbd36
parent5bba0546eecb32f4ff9388815727304823940ef6
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
src/test/regress/expected/collate.icu.utf8.out
src/test/regress/sql/collate.icu.utf8.sql