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
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 -------
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 LinuxHi 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?
----------
0Is 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 -------