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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026