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

Поиск
Список
Период
Сортировка
От Todd A. Cook
Тема Re: BUG #14990: hashint4() <> hashint8() for small negative values,causing hash joins to fail
Дата
Msg-id d6748962-723a-6f5e-48b9-c77ce4fd21f8@blackducksoftware.com
обсуждение исходный текст
Ответ на Re: BUG #14990: hashint4() <> hashint8() for small negative values, causing hash joins to fail  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tony Finch
Дата:
Сообщение: psql cannot read client SSL private key from a pipe
Следующее
От: "Todd A. Cook"
Дата:
Сообщение: Re: BUG #14990: hashint4() <> hashint8() for small negative values,causing hash joins to fail