int8 bug on Alpha

From: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>
To: Postgresql <pgsql-hackers(at)postgreSQL(dot)org>
Subject: int8 bug on Alpha
Date: 2001-03-21 09:19:39
Message-ID: 3AB8722B.504FE82A@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

int8 is not handled correctly on Alpha. Inserting 2^63-1, 2^63-2 and
2^61
into

create table lint (i int8);

gives

test=# select * from lint;
i
----
-1
-2
0
(3 rows)

On linux it gives the correct values:

test=# select * from lint;
i
---------------------
9223372036854775807
9223372036854775806
2305843009213693952
(3 rows)

This is postgres 7.1b4, compiled with native cc on Tru64 4.0G. I seem to
recall running the regression tests, so perhaps this is not checked?
(just looked at int8.sql, and it is not checked.)

I'm swamped, so cannot look at it right now. If nobody else can look at
it, I will get back to it in about a fortnight.

Adriaan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 2001-03-21 09:46:23 Re: Stuck spins in current
Previous Message Peter T Mount 2001-03-21 09:16:26 Re: Final Call: RC1 about to go out the door ...