Re: BUG #14990: hashint4() <> hashint8() for small negative values,causing hash joins to fail

On 12/21/17 12:31, Tom Lane wrote:
> =?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
>> However, for small-magnitude negative numbers, hashint8() and hashint4() do
>> not produce the same results:
> 
> Hm, it works as expected for me.  What compiler and compile options
> did you use?

$ gcc --version
gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16)


CONFIGURE = '--prefix=/home/tac/tmp/pg10' '--with-icu' '--with-perl' '--with-python' '--with-tcl'
'--with-tclconfig=/usr/lib64''--with-openssl' '--with-pam' '--with-gssapi' '--with-includes=/usr/include'
'--with-libraries=/usr/lib64''--enable-nls' '--enable-dtrace' '--with-uuid=e2fs' '--with-libxml' '--with-libxslt'
'--with-ldap''--with-selinux' '--with-systemd' '--with-system-tzdata=/usr/share/zoneinfo' '--enable-debug'
 
CC = gcc
CPPFLAGS = -DFRONTEND -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute-Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O2
 
CFLAGS_SL = -fPIC
LDFLAGS = -L../../src/common -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/home/tac/tmp/pg10/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lselinux -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt
-lcrypt-ldl -lm
 
VERSION = PostgreSQL 10.1

Also, I built from HEAD (as of yesterday afternoon) on REL_10_STABLE.

-- todd