Enable hash partitioning of text arrays
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 4 Nov 2020 06:47:06 +0000 (07:47 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 4 Nov 2020 11:46:38 +0000 (12:46 +0100)
commit82d4a2a7d63e79f6a6724f366cfaa4beed6b8326
treef69d6de6fe4c8bb1edccf22dbe86857802219ebe
parent7d39586a59c6f5816a068bd38e1e4887d4c984ff
Enable hash partitioning of text arrays

hash_array_extended() needs to pass PG_GET_COLLATION() to the hash
function of the element type.  Otherwise, the hash function of a
collation-aware data type such as text will error out, since the
introduction of nondeterministic collation made hash functions require
a collation, too.

The consequence of this is that before this change, hash partitioning
using an array over text in the partition key would not work.

Reviewed-by: Heikki Linnakangas <hlinnaka@iki.fi>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://www.postgresql.org/message-id/flat/32c1fdae-95c6-5dc6-058a-a90330a3b621%40enterprisedb.com
src/backend/utils/adt/arrayfuncs.c
src/test/regress/expected/collate.icu.utf8.out
src/test/regress/sql/collate.icu.utf8.sql