Re: float8 regression / platform report - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: float8 regression / platform report
Date
Msg-id 200006120300.XAA24111@candle.pha.pa.us
Whole thread Raw
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Fix for RENAME
Next
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE DROP COLUMN