Fix broken hash function hashbpcharextended().
Jeff Davis <jdavis@postgresql.org>
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/eb83d0ac7b299eb08f9b900dd08a5a0c5d90e517.camel@j-davis.com Reviewed-by: Richard Guo, Tom Lane
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/varchar.c | modified | +1 −1 |
Discussion
- hashing bpchar for nondeterministic collations is broken 6 messages · 2022-12-01 → 2022-12-02