Fix broken hash function hashbpcharextended(). Ignore trailing spaces for non-deterministic collations when hashing.
The previous behavior could lead to tuples falling into the wrong partitions when hash partitioning is combined with the BPCHAR type and a non-deterministic collation. Fortunately, it did not affect hash indexes, because hash indexes do not use extended hash functions. Decline to backpatch, per discussion. Discussion: https://postgr.es/m/[email protected] Reviewed-by: Richard Guo, Tom Lane Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/7ac0f8d384a4633c6652ae1f6bba40d42d21ec18 Modified Files -------------- src/backend/utils/adt/varchar.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
