8.0.0rc1 on hppa2.0w-hp-hpux11.00

gmake check result


template1=# select version();
                                    version
-------------------------------------------------------------------------------
 PostgreSQL 8.0.0rc1 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc (GCC)
3.3.1
(1 row)

1 of 96 tests failed

test stats                ... FAILED

Please find attached

src/test/regress/regression.out
src/test/regress/regression.diffs

BTW, as mentioned the other day I had to do configure as

configure LIBS="-ltermcap" ...

>From my previous mail

I have successfully compiled and installed 7.4.5 yesterday.
After doing 'make' I saw the line "Ready to install".
template1=# select version();
                                  version
--------------------------------------------------------
 PostgreSQL 7.4.5 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc (GCC)
3.3.1
(1 row)

But when I started psql it immediately core dumped with
libreadline.sl.5 Unresolved external: tgetent

I did a search on the mailing list archives and got 63 hits on
'tgetent',
dating from 1997 to 2004, all having the same problem,
the missing '-ltermcap' in LIBS in src/Makefile.global.

After distclean and doing configure LIBS="-ltermcap" ...
and make again it finally worked.

In http://archives.postgresql.org/pgsql-bugs/2001-09/msg00023.php
Peter Eisentraut writes
> LIBS = -lz -lresolv -lcompat -lm -lutil -ltermcap -lreadline

That's a good fix.

The current CVS tip also works around this problem.

But the 7.4.5 src/Makefile.global still has this:
LIBS = -lz -lreadline -lPW -lgen -lBSD -ldld -lnsl -lm

So it appears this fix must have been lost anywhere.

And it is not fixed in 8.0.0rc1.
8.0.0rc1 src/Makefile.global still has this:
LIBS = -lz -lreadline -lPW -lgen -lBSD -ldld -lnsl -lm

Regards, Christoph*** ./expected/stats.out    Sat Nov  1 04:18:20 2003
--- ./results/stats.out    Wed Dec 15 13:57:14 2004
***************
*** 8,14 ****
  SHOW stats_start_collector;  -- must be on
   stats_start_collector
  -----------------------
!  on
  (1 row)

  -- save counters
--- 8,14 ----
  SHOW stats_start_collector;  -- must be on
   stats_start_collector
  -----------------------
!  off
  (1 row)

  -- save counters
***************
*** 62,68 ****
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  t        | t        | t        | t
  (1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
--- 62,68 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  f        | f        | f        | f
  (1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
***************
*** 71,77 ****
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column?
  ----------+----------
!  t        | t
  (1 row)

  -- clean up
--- 71,77 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column?
  ----------+----------
!  f        | f
  (1 row)

  -- clean up

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

parallel group (13 tests):  boolean char varchar name text int2 int8 int4 oid float4 float8 bit numeric
     boolean              ... ok
     char                 ... ok
     name                 ... ok
     varchar              ... ok
     text                 ... ok
     int2                 ... ok
     int4                 ... ok
     int8                 ... ok
     oid                  ... ok
     float4               ... ok
     float8               ... ok
     bit                  ... ok
     numeric              ... ok
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  point box lseg path polygon circle timetz date time comments inet tinterval reltime
intervalabstime timestamp timestamptz type_sanity oidjoins opr_sanity 
     point                ... ok
     lseg                 ... ok
     box                  ... ok
     path                 ... ok
     polygon              ... ok
     circle               ... ok
     date                 ... ok
     time                 ... ok
     timetz               ... ok
     timestamp            ... ok
     timestamptz          ... ok
     interval             ... ok
     abstime              ... ok
     reltime              ... ok
     tinterval            ... ok
     inet                 ... ok
     comments             ... ok
     oidjoins             ... ok
     type_sanity          ... ok
     opr_sanity           ... ok
test geometry             ... ok
test horology             ... ok
test insert               ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_operator create_aggregate triggers vacuum constraints inherit create_misc
     constraints          ... ok
     triggers             ... ok
     create_misc          ... ok
     create_aggregate     ... ok
     create_operator      ... ok
     inherit              ... ok
     vacuum               ... ok
parallel group (2 tests):  create_view create_index
     create_index         ... ok
     create_view          ... ok
test sanity_check         ... ok
test errors               ... ok
test select               ... ok
parallel group (18 tests):  select_into select_distinct_on select_implicit select_having union case select_distinct
updaterandom arrays transactions join aggregates hash_index namespace portals btree_index subselect 
     select_into          ... ok
     select_distinct      ... ok
     select_distinct_on   ... ok
     select_implicit      ... ok
     select_having        ... ok
     subselect            ... ok
     union                ... ok
     case                 ... ok
     join                 ... ok
     aggregates           ... ok
     transactions         ... ok
     random               ... ok
     portals              ... ok
     arrays               ... ok
     btree_index          ... ok
     hash_index           ... ok
     update               ... ok
     namespace            ... ok
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 cluster select_views rules foreign_key
     select_views         ... ok
     portals_p2           ... ok
     rules                ... ok
     foreign_key          ... ok
     cluster              ... ok
parallel group (14 tests):  limit copy2 temp truncate sequence domain polymorphism conversion prepare rangefuncs
rowtypeswithout_oid alter_table plpgsql 
     limit                ... ok
     plpgsql              ... ok
     copy2                ... ok
     temp                 ... ok
     domain               ... ok
     rangefuncs           ... ok
     prepare              ... ok
     without_oid          ... ok
     conversion           ... ok
     truncate             ... ok
     alter_table          ... ok
     sequence             ... ok
     polymorphism         ... ok
     rowtypes             ... ok
test stats                ... FAILED
test tablespace           ... ok