Just tried on Tru64 5.1 using the Compaq C compiler.  Failed the float8,
oidjoin and random tests.  

*** ./expected/float8-fp-exception.out  Thu Mar 30 02:46:00 2000
--- ./results/float8.out        Wed Nov 28 19:29:33 2001
***************
*** 237,243 ****
  
  -- test for over- and underflow 
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
! ERROR:  Input '10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Input '-10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
--- 237,243 ----
  
  -- test for over- and underflow 
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
! ERROR:  Bad float8 input format '10e400'
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Input '-10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');

OIDJOIN had this...
! psql: server closed the connection unexpectedly
!       This probably means the server terminated abnormally
!       before or while processing the request.

--- ./results/random.out        Wed Nov 28 19:33:03 2001
***************
*** 25,31 ****
    GROUP BY random HAVING count(random) > 1;
   random | count 
  --------+-------
! (0 rows)
  
  SELECT random FROM RANDOM_TBL
    WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 ----
    GROUP BY random HAVING count(random) > 1;
   random | count 
  --------+-------
!     119 |     2
! (1 row)
  
  SELECT random FROM RANDOM_TBL
    WHERE random NOT BETWEEN 80 AND 120;

======================================================================




I can post the whole regression.out file if someone needs it.

Jim




> Just donwloaded and built 7.2beta3 on Compaq Tru64 (Digital Unix) 4.0
on
> Alpha architecture and now all regression tests are passed.
> 
> test=# SELECT version();
>                             version
> ----------------------------------------------------------------
>  PostgreSQL 7.2b3 on alphaev67-dec-osf4.0g, compiled by cc -std
> 
> -- 
> Alessio F. Bragadini		alessio@albourne.com
> APL Financial Services		http://village.albourne.com
> Nicosia, Cyprus		 	phone: +357-22-755750
> 
> "It is more complicated than you think"
> 		-- The Eighth Networking Truth from RFC 1925
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
> 



Wed, 28 Nov 2001 20:35:04 -0500
"Jim Buttafuoco" <jim@buttafuoco.net>
Re: 7.2beta3 on Digital Alpha
> Just tried on Tru64 5.1 using the Compaq C compiler.  Failed the float8,
> oidjoin and random tests.

The float8 is certainly OK.

The random test fails, uh, randomly, should succeed sometimes on your
platform, so is probably OK if you try again.

But the oidjoin test is certainly broken. What optimization are you
compiling with? Does it work better if you turn optimization off??

                      - Thomas

Thu, 29 Nov 2001 03:03:03 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: 7.2beta3 on Digital Alpha
NetBSD used to fail on these tests too, until they implemented soft-float.

On Wed, 28 Nov 2001, Jim Buttafuoco wrote:

> Date: Wed, 28 Nov 2001 20:35:04 -0500
> From: Jim Buttafuoco <jim@buttafuoco.net>
> To: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] 7.2beta3 on Digital Alpha
> 
> Just tried on Tru64 5.1 using the Compaq C compiler.  Failed the float8,
> oidjoin and random tests.  
> 
> *** ./expected/float8-fp-exception.out  Thu Mar 30 02:46:00 2000
> --- ./results/float8.out        Wed Nov 28 19:29:33 2001
> ***************
> *** 237,243 ****
>   
>   -- test for over- and underflow 
>   INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
> ! ERROR:  Input '10e400' is out of range for float8
>   INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
>   ERROR:  Input '-10e400' is out of range for float8
>   INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
> --- 237,243 ----
>   
>   -- test for over- and underflow 
>   INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
> ! ERROR:  Bad float8 input format '10e400'
>   INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
>   ERROR:  Input '-10e400' is out of range for float8
>   INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
> 
> OIDJOIN had this...
> ! psql: server closed the connection unexpectedly
> !       This probably means the server terminated abnormally
> !       before or while processing the request.
> 
> --- ./results/random.out        Wed Nov 28 19:33:03 2001
> ***************
> *** 25,31 ****
>     GROUP BY random HAVING count(random) > 1;
>    random | count 
>   --------+-------
> ! (0 rows)
>   
>   SELECT random FROM RANDOM_TBL
>     WHERE random NOT BETWEEN 80 AND 120;
> --- 25,32 ----
>     GROUP BY random HAVING count(random) > 1;
>    random | count 
>   --------+-------
> !     119 |     2
> ! (1 row)
>   
>   SELECT random FROM RANDOM_TBL
>     WHERE random NOT BETWEEN 80 AND 120;
> 
> ======================================================================
> 
> 
> 
> 
> I can post the whole regression.out file if someone needs it.
> 
> Jim
> 
> 
> 
> 
> > Just donwloaded and built 7.2beta3 on Compaq Tru64 (Digital Unix) 4.0
> on
> > Alpha architecture and now all regression tests are passed.
> > 
> > test=# SELECT version();
> >                             version
> > ----------------------------------------------------------------
> >  PostgreSQL 7.2b3 on alphaev67-dec-osf4.0g, compiled by cc -std
> > 
> > -- 
> > Alessio F. Bragadini		alessio@albourne.com
> > APL Financial Services		http://village.albourne.com
> > Nicosia, Cyprus		 	phone: +357-22-755750
> > 
> > "It is more complicated than you think"
> > 		-- The Eighth Networking Truth from RFC 1925
> > 
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> > 
> > http://archives.postgresql.org
> > 
> > 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 


Wed, 28 Nov 2001 21:04:23 -0600 (CST)
"Thomas T. Thai" <tom@minnesota.com>
Re: 7.2beta3 on Digital Alpha
"Jim Buttafuoco" <jim@buttafuoco.net> writes:
> OIDJOIN had this...
> ! psql: server closed the connection unexpectedly
> !       This probably means the server terminated abnormally
> !       before or while processing the request.

This is bad.  There should be a core dump file --- can you provide
a debugger backtrace from it?

			regards, tom lane

Thu, 29 Nov 2001 00:50:50 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.2beta3 on Digital Alpha 