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

From Todd A. Cook
Subject Re: BUG #14990: hashint4() <> hashint8() for small negative values,causing hash joins to fail
Date
Msg-id c6c93c9e-286c-8f33-e2f8-36772bbcfb36@blackducksoftware.com
Whole thread Raw
In response to Re: BUG #14990: hashint4() <> hashint8() for small negative values, causing hash joins to fail  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?

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


pgsql-bugs by date:

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