Horton

Re: hashing bpchar for nondeterministic collations is broken

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es
From: Jeff Davis <pgsql@j-davis.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Guo <guofenglinux@gmail.com>, pgsql-bugs@postgresql.org
Date: 2022-12-02T22:04:30Z
Lists: pgsql-bugs 
On Fri, 2022-12-02 at 16:49 -0500, Tom Lane wrote:
> Yeah.  Also, do we have this issue with hash indexes?

No, it appears that hash indexes only call hashbpchar, which doesn't
have the bug.

Extended hash functions seem to only be used in hash partitioning, and
other extended hash functions.

Regards,
	Jeff Davis

Commits

  1. Fix broken hash function hashbpcharextended().