Regression tests on intel for 6.5.2

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Regression tests on intel for 6.5.2
Date: 1999-09-27 16:02:26
Message-ID: 37EF9512.C4F67DFE@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In the course of building and testing the rpm's for 6.5.2, unexpected
results were found in the regression testing. I am curious as to what
the results for 'float8' mean (geometry also failed, but it's obvious as
to why):

> *** expected/float8.out Sat Jan 23 19:12:59 1999
> --- results/float8.out Mon Sep 27 11:01:13 1999
> ***************
> *** 189,201 ****
> QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
> ERROR: Bad float8 input format -- overflow
> QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
> ! ERROR: pow() result is out of range
> QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
> ERROR: can't take log of zero
> QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
> ERROR: can't take log of a negative number
> QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
> ! ERROR: exp() result is out of range
> QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
> ERROR: float8div: divide by zero error
> QUERY: SELECT '' AS five, FLOAT8_TBL.*;
> --- 189,217 ----
> QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
> ERROR: Bad float8 input format -- overflow
> 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 where f.f1 = '0.0' ;
> ERROR: can't take log of zero
> QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
> ERROR: can't take log of a negative number
> QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
> ! bad| ?column?
> ! ---+--------------------
> ! | 1
> ! |7.39912306090513e-16
> ! | 0
> ! | 0
> ! | 1
> ! (5 rows)
> !
> QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
> ERROR: float8div: divide by zero error
> QUERY: SELECT '' AS five, FLOAT8_TBL.*;
>
> ----------------------

TIA

Lamar Owen
WGCR Internet Radio

Browse pgsql-hackers by date

  From Date Subject
Next Message Leon 1999-09-27 16:23:14 Re: [HACKERS] Profiling?]
Previous Message Bruce Momjian 1999-09-27 15:49:12 Re: [HACKERS] double opens