float4/float8 regression failure on Alpha Linux

Started by Jim Buttafuocoabout 21 years ago3 messages
#1Jim Buttafuoco
jim@contactbda.com

Hi all,

I am getting a regression failure on float8 (and float4) when running on Debian Sarge on Alpha (gcc 3.3.4). Postgres
is a HEAD checkout from yesterday.

test=# select version();
version
-------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta4 on alpha-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-13)
(1 row)

--This test sould give an error
SELECT 'Infinity'::float8 + 100.0;
?column?
----------
0

Is this a problem with my system, Alpha's or postgres.
Thanks
Jim

#2Jim Buttafuoco
jim@contactbda.com
In reply to: Jim Buttafuoco (#1)
Fw: float4/float8 regression failure on Alpha Linux

I am still having this problem with the latest CSV snapshot. Is anyone else running on an Alpha. Can any of the
hackers point me to where in the code this might be failing?

Thanks
Jim

---------- Forwarded Message -----------
From: "Jim Buttafuoco" <jim@contactbda.com>
To: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Sun, 31 Oct 2004 07:09:32 -0500
Subject: float4/float8 regression failure on Alpha Linux

Hi all,

I am getting a regression failure on float8 (and float4) when running on Debian Sarge on Alpha (gcc 3.3.4). Postgres
is a HEAD checkout from yesterday.

test=# select version();
version
-------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta4 on alpha-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-13)
(1 row)

--This test sould give an error
SELECT 'Infinity'::float8 + 100.0;
?column?
----------
0

Is this a problem with my system, Alpha's or postgres.
Thanks
Jim
------- End of Forwarded Message -------

#3Jim Buttafuoco
jim@contactbda.com
In reply to: Jim Buttafuoco (#2)
Re: Fw: float4/float8 regression failure on Alpha Linux

just to follow up.

On i386/mipsel/mips I get the following for pow(10,309)

ERROR: result is out of range

on alpha, I get 3.09434604738258e-308

---------- Original Message -----------
From: "Jim Buttafuoco" <jim@contactbda.com>
To: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Wed, 3 Nov 2004 08:44:02 -0500
Subject: [HACKERS] Fw: float4/float8 regression failure on Alpha Linux

I am still having this problem with the latest CSV snapshot. Is anyone else running on an Alpha. Can any of
the hackers point me to where in the code this might be failing?

Thanks
Jim

---------- Forwarded Message -----------
From: "Jim Buttafuoco" <jim@contactbda.com>
To: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Sun, 31 Oct 2004 07:09:32 -0500
Subject: float4/float8 regression failure on Alpha Linux

Hi all,

I am getting a regression failure on float8 (and float4) when running on Debian Sarge on Alpha (gcc 3.3.4).
Postgres is a HEAD checkout from yesterday.

test=# select version();
version
-------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta4 on alpha-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-13)
(1 row)

--This test sould give an error
SELECT 'Infinity'::float8 + 100.0;
?column?
----------
0

Is this a problem with my system, Alpha's or postgres.
Thanks
Jim
------- End of Forwarded Message -------

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

------- End of Original Message -------