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