Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: Tuple-valued datums on Alpha (was Re: 7.1 on DEC/Alpha)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brent Verner <brent(at)rcfile(dot)org>
Cc: Ryan Kirkpatrick <rkirkpat(at)rkirkpat(dot)net>, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: Tuple-valued datums on Alpha (was Re: 7.1 on DEC/Alpha)
Date: 2000-12-27 23:44:42
Message-ID: 25121.977960682@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Brent Verner <brent(at)rcfile(dot)org> writes:
>   INSERT INTO OID_TBL(f1) VALUES ('-1040');
> + ERROR:  oidin: error reading "-1040": Error 0 occurred.

Hm.  I thought I'd fixed that.  Are you up to date on
src/backend/utils/adt/oid.c ?  Current CVS has rev 1.42.

  
> *** ./expected/float8-fp-exception.out	Thu Mar 30 02:46:00 2000
> --- ./results/float8.out	Wed Dec 27 18:27:15 2000
> ***************
> *** 214,220 ****
>      SET f1 = FLOAT8_TBL.f1 * '-1'
>      WHERE FLOAT8_TBL.f1 > '0.0';
>   SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
> ! ERROR:  floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero
>   SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
>   ERROR:  pow() result is out of range
>   SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
> --- 214,220 ----
>      SET f1 = FLOAT8_TBL.f1 * '-1'
>      WHERE FLOAT8_TBL.f1 > '0.0';
>   SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
> ! ERROR:  Bad float8 input format -- overflow
>   SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
>   ERROR:  pow() result is out of range
>   SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;

It would appear that Alpha no longer needs the special
float8-fp-exception.out comparison file.  Try removing the line

	float8/alpha.*-dec-osf=float8-fp-exception

from src/test/regress/resultmap.

The geometry diffs also look like Alpha may be more nearly in sync with
the rest of the world than it used to be.  Do any of the other geometry
comparison files match what you are getting as results/geometry.out?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Brent VernerDate: 2000-12-28 00:38:05
Subject: Re: [HACKERS] Re: Tuple-valued datums on Alpha (was Re: 7.1 on DEC/Alpha)
Previous:From: Tatsuo IshiiDate: 2000-12-27 23:36:41
Subject: Re: About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING"

pgsql-patches by date

Next:From: Brent VernerDate: 2000-12-28 00:38:05
Subject: Re: [HACKERS] Re: Tuple-valued datums on Alpha (was Re: 7.1 on DEC/Alpha)
Previous:From: Tatsuo IshiiDate: 2000-12-27 23:36:41
Subject: Re: About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group