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

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