Re: new int8 test still has problems

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: new int8 test still has problems
Date: 2008-10-05 18:58:24
Message-ID: 48E90E50.7050306@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-05 19:04:22 Re: new int8 test still has problems
Previous Message Alvaro Herrera 2008-10-05 18:51:10 Re: Subtransaction commits and Hot Standby