Thread

int8 bug on Alpha

Adriaan Joubert <a.joubert@albourne.com> — 2001-03-21T09:19:39Z

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