Re: new int8 test still has problems - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: new int8 test still has problems
Date
Msg-id 48E90E50.7050306@gmx.net
Whole thread Raw
In response to new int8 test still has problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: new int8 test still has problems
List pgsql-hackers
Tom Lane wrote:
> The buildfarm is showing still other "interesting" behaviors.
> I'm not really interested in having umpteen expected int8 files
> to deal with all the strange corner cases that might be seen
> on different platforms.  Please just remove all the edge-case
> tests.

Yeah, it's probably not worth bother too much with them.  I have removed 
the problem cases.

This result from AIX/PPC can't be good, however:

***************
*** 684,690 ****  select '9223372036854775800'::int8 * '100'::int4;  ERROR:  bigint out of range  select
'-9223372036854775808'::int8/ '-1'::int4;
 
! ERROR:  bigint out of range  select '100'::int4 + '9223372036854775800'::int8;  ERROR:  bigint out of range  select
'-100'::int4- '9223372036854775800'::int8;
 
--- 688,698 ----  select '9223372036854775800'::int8 * '100'::int4;  ERROR:  bigint out of range  select
'-9223372036854775808'::int8/ '-1'::int4;
 
!  ?column?
! ----------
!         0
! (1 row)
!  select '100'::int4 + '9223372036854775800'::int8;  ERROR:  bigint out of range  select '-100'::int4 -
'9223372036854775800'::int8;


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Subtransaction commits and Hot Standby
Next
From: Tom Lane
Date:
Subject: Re: new int8 test still has problems