Re: int8 bug on Alpha - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: int8 bug on Alpha
Date
Msg-id 3AB89484.488FE75F@alumni.caltech.edu
Whole thread Raw
In response to int8 bug on Alpha  (Adriaan Joubert <a.joubert@albourne.com>)
List 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


pgsql-hackers by date:

Previous
From: "sourabh dixit"
Date:
Subject: Re: PostgreSQL-JDBC driver
Next
From: Adriaan Joubert
Date:
Subject: Re: int8 bug on Alpha