Re: [HACKERS] float8 regression / platform report

This was applied.

On Sat, Mar 25, 2000 at 02:57:05AM +0000, Thomas Lockhart wrote:

Just a quick announcement that we've put beta3 up for download today ...

Can people start testing this beta3 and reporting on regression test
results for *all* platforms mentioned in the "supported" list at

All tests but float8 (patch attached) pass on NetBSD-1.4U/i386. I think
NetBSD just says if x<DBL_MIN, x=0, so there is no underflow warning. This
is with this morning (Sunday)'s source - I assume that's the same as beta3.
While looking at float8 tests, I think

float8-exp-three-digits.out
float8-fp-exception.out

might be out of date - simple test: comment in float8.sql is "over- and
underflow", these files have the comment without the hyphen - maybe
something else changed too?

Cheers,

Patrick

Index: resultmap
===================================================================
RCS file: /usr/local/cvsroot/pgsql/src/test/regress/resultmap,v
retrieving revision 1.14
diff -c -r1.14 resultmap
*** resultmap	2000/03/26 02:35:01	1.14
--- resultmap	2000/03/26 12:33:49
***************
*** 20,25 ****
--- 20,26 ----
float8/alpha-dec-osf=float8-fp-exception
float4/.*-qnx4=float4-exp-three-digits
float8/.*-qnx4=float8-exp-three-digits
+ float8/.*-netbsd=float8-small-is-zero
geometry/hppa=geometry-positive-zeros
geometry/.*-netbsd=geometry-positive-zeros
geometry/.*-freebsd=geometry-positive-zeros

and you want to create a file expected/float8-small-is-zero.out created by
applying the following to float8.out (ie., cp float8.out someplace first!)

*** float8.out	Sun Mar 26 13:35:22 2000
--- float8-small-is-zero.out	Sun Mar 26 13:35:22 2000
***************
*** 241,249 ****
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
ERROR:  Input '-10e400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
- ERROR:  Input '10e-400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
- ERROR:  Input '-10e-400' is out of range for float8
-- maintain external table consistency across platforms
-- delete all values and reinsert well-behaved ones
DELETE FROM FLOAT8_TBL;
--- 241,247 ----

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026