Teach hash_ok_operator() that record_eq is only sometimes hashable.
Tom Lane <tgl@sss.pgh.pa.us>
Teach hash_ok_operator() that record_eq is only sometimes hashable. The need for this was foreseen long ago, but when record_eq actually became hashable (in commit 01e658fa7), we missed updating this spot. Per bug #17363 from Elvis Pranskevichus. Back-patch to v14 where the faulty commit came in. Discussion: https://postgr.es/m/17363-f6d42fd0d726be02@postgresql.org
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/plan/subselect.c | modified | +3 −3 |
| src/test/regress/expected/subselect.out | modified | +23 −0 |
| src/test/regress/sql/subselect.sql | modified | +10 −0 |
Discussion
- BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink 3 messages · 2022-01-11 → 2022-01-16