Fix some more hashjoin-related bugs in pg_operator. Fix
Tom Lane <tgl@sss.pgh.pa.us>
Fix some more hashjoin-related bugs in pg_operator. Fix hashjoin's hashFunc() so that it does the right thing with pass-by-value data types (the old code would always return 0 for int2 or char values, which would work but would slow things down a lot). Extend opr_sanity regress test to catch more kinds of errors.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/nodeHash.c | modified | +39 −37 |
| src/include/catalog/pg_operator.h | modified | +42 −42 |
| src/test/regress/expected/opr_sanity.out | modified | +21 −11 |
| src/test/regress/sql/opr_sanity.sql | modified | +23 −10 |