Re: int8 bug on Alpha

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>
Cc: Postgresql <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: int8 bug on Alpha
Date: 2001-03-21 11:46:12
Message-ID: 3AB89484.488FE75F@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

How are you doing the inserts? If you aren't coercing the "2" to be an
int8, then (afaik) the math will be done in int4, then upconverted. So,
can you confirm that your inserts look like:

insert into lint values ('9223372036854775807');

or

insert into lint select (int8 '2') ^ 61;

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message sourabh dixit 2001-03-21 11:50:02 Re: PostgreSQL-JDBC driver
Previous Message Peter T Mount 2001-03-21 11:26:43 Re: PostgreSQL-JDBC driver