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

From: "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14990: hashint4() <> hashint8() for small negative values, causing hash joins to fail
Date: 2017-12-21 17:53:57
Message-ID: c6c93c9e-286c-8f33-e2f8-36772bbcfb36@blackducksoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

This is looking like a make failure of some sort. I did

git reset --hard
make clean
make

but I just now did

make clean
find . -name '*.?o' -print0 | xargs -0 rm
make

and now I get the same results as you.

-- todd

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2017-12-21 21:18:05 Re: BUG #14986: -2147483648 is minimum value of integer but -2147483648::integer fails (out of range).
Previous Message Todd A. Cook 2017-12-21 17:43:18 Re: BUG #14990: hashint4() <> hashint8() for small negative values, causing hash joins to fail