Re: [GENERAL] Probs with float8, geometry, abstime regression tests on Linux

From: Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Probs with float8, geometry, abstime regression tests on Linux
Date: 2000-02-12 02:40:39
Message-ID: 3.0.5.32.20000212104039.00917990@pop.mecomb.po.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

O/S: Redhat 6.0 Linux 2.2.14
hardware:DELL POWEREDGE 8E. 500MHZ 512MB.
CPU0: Intel Pentium III (Katmai) stepping 03
(SMP support on kernel, but single CPU).

PG Version: Postgres 6.5.3
configure option: just used --prefix=<mypath>

Failed regression tests:
float8 .. failed
geometry .. failed
abstime .. failed

float8:
Don't get pow() and exp() out of range errors but get like 5 rows of
results instead. The README says that some platforms are different, however
I had the impression that the platform I'm using was similar to the
reference one. Should this be happening?
e.g.
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;

bad|?column?
---+--------
|0
|NaN
|NaN
|NaN
|NaN
(5 rows)

QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;

bad| ?column?
---+--------------------
| 1
|7.39912306090513e-16
| 0
| 0
| 1

geometry:
Quite a number of failures, probably the usual rounding stuff. However I
thought our Linux Pentium III system should give the same results as the
Postgres reference one (same goes for float8). Are there any
compiler/configuration options which I should be using so as to match the
reference results?

abstime:
The regression test not Y2K compliant?

SELECT '' AS four, ABSTIME_TBL.*
WHERE ABSTIME_TBL.f1 <?>
'["Apr 1 1950 00:00:00" "Dec 30 1999 23:00:00"]'::tinterval;
Expected:
four|f1
----+----------------------------
|Sun Jan 14 03:14:21 1973 PST
|Mon May 01 00:30:30 1995 PDT
|epoch
|current
(4 rows)

But nowadays current is not < Dec 30 1999 so should not appear in actual ;).

Best regards,

Link.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2000-02-12 05:20:45 Re: [GENERAL] Re:PostgreSQL and PHP
Previous Message Jeff Davis 2000-02-11 23:04:00 Re: [GENERAL] Re:PostgreSQL and PHP