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(at)postgresql(dot)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