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.
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 |