Thread

Re: int8 bug on Alpha

Adriaan Joubert <a.joubert@albourne.com> — 2001-03-21T13:10:55Z

Thomas Lockhart wrote:
> 
> > 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');

OK, that was it. I  inserted without quotes. If I insert the quotes it
works. So why does it work correctly on linux without quotes?

and 

 insert into lint values ('9223372036854775807'::int8);

works, but

 insert into lint values (9223372036854775807::int8);

doesn't. I guess in the second case it converts it to an int4 and then
recasts to an int8?

Cheers,

Adriaan