The 'type_sanity' and 'domain' regression tests seem to fail with CVS
HEAD. Here's the diff:

*** ./expected/type_sanity.out	Sun Aug  4 15:48:11 2002
--- ./results/type_sanity.out	Tue Aug 20 01:32:35 2002
***************
*** 16,22 ****
  SELECT p1.oid, p1.typname
  FROM pg_type as p1
  WHERE (p1.typlen <= 0 AND p1.typlen != -1) OR
!     (p1.typtype != 'b' AND p1.typtype != 'c' AND p1.typtype != 'p') OR
      NOT p1.typisdefined OR
      (p1.typalign != 'c' AND p1.typalign != 's' AND
       p1.typalign != 'i' AND p1.typalign != 'd') OR
--- 16,22 ----
  SELECT p1.oid, p1.typname
  FROM pg_type as p1
  WHERE (p1.typlen <= 0 AND p1.typlen != -1) OR
!     p1.typtype not in('b', 'c', 'd', 'p') OR
      NOT p1.typisdefined OR
      (p1.typalign != 'c' AND p1.typalign != 's' AND
       p1.typalign != 'i' AND p1.typalign != 'd') OR
***************
*** 60,66 ****
  -- NOTE: as of 7.3, this check finds SET, smgr, and unknown.
  SELECT p1.oid, p1.typname
  FROM pg_type as p1
! WHERE p1.typtype = 'b' AND p1.typname NOT LIKE '\\_%' AND NOT EXISTS
      (SELECT 1 FROM pg_type as p2
       WHERE p2.typname = ('_' || p1.typname)::name AND
             p2.typelem = p1.oid);
--- 60,66 ----
  -- NOTE: as of 7.3, this check finds SET, smgr, and unknown.
  SELECT p1.oid, p1.typname
  FROM pg_type as p1
! WHERE p1.typtype in ('b','d') AND p1.typname NOT LIKE '\\_%' AND NOT EXISTS
      (SELECT 1 FROM pg_type as p2
       WHERE p2.typname = ('_' || p1.typname)::name AND
             p2.typelem = p1.oid);

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

*** ./expected/domain.out	Fri Jul 12 14:43:19 2002
--- ./results/domain.out	Tue Aug 20 01:32:57 2002
***************
*** 143,154 ****
              ( col1 ddef1
              , col2 ddef2
              , col3 ddef3
!             , col4 ddef4
              , col5 ddef1 NOT NULL DEFAULT NULL
              , col6 ddef2 DEFAULT '88'
              , col7 ddef4 DEFAULT 8000
  		, col8 ddef5
              );
  insert into defaulttest default values;
  insert into defaulttest default values;
  insert into defaulttest default values;
--- 143,155 ----
              ( col1 ddef1
              , col2 ddef2
              , col3 ddef3
!             , col4 ddef4 PRIMARY KEY
              , col5 ddef1 NOT NULL DEFAULT NULL
              , col6 ddef2 DEFAULT '88'
              , col7 ddef4 DEFAULT 8000
              , col8 ddef5
              );
+ NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'defaulttest_pkey' for table 'defaulttest'
  insert into defaulttest default values;
  insert into defaulttest default values;
  insert into defaulttest default values;

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

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC


20 Aug 2002 01:37:52 -0400
Neil Conway <neilc@samurai.com>
regression test failures in CVS HEAD
Looks like the expected files weren't updated.

Probably my fault, but the tests themselves are fine.

On Tue, 2002-08-20 at 01:37, Neil Conway wrote:
> The 'type_sanity' and 'domain' regression tests seem to fail with CVS
> HEAD. Here's the diff:
> 
> *** ./expected/type_sanity.out	Sun Aug  4 15:48:11 2002
> --- ./results/type_sanity.out	Tue Aug 20 01:32:35 2002
> ***************
> *** 16,22 ****
>   SELECT p1.oid, p1.typname
>   FROM pg_type as p1
>   WHERE (p1.typlen <= 0 AND p1.typlen != -1) OR
> !     (p1.typtype != 'b' AND p1.typtype != 'c' AND p1.typtype != 'p') OR
>       NOT p1.typisdefined OR
>       (p1.typalign != 'c' AND p1.typalign != 's' AND
>        p1.typalign != 'i' AND p1.typalign != 'd') OR
> --- 16,22 ----
>   SELECT p1.oid, p1.typname
>   FROM pg_type as p1
>   WHERE (p1.typlen <= 0 AND p1.typlen != -1) OR
> !     p1.typtype not in('b', 'c', 'd', 'p') OR
>       NOT p1.typisdefined OR
>       (p1.typalign != 'c' AND p1.typalign != 's' AND
>        p1.typalign != 'i' AND p1.typalign != 'd') OR
> ***************
> *** 60,66 ****
>   -- NOTE: as of 7.3, this check finds SET, smgr, and unknown.
>   SELECT p1.oid, p1.typname
>   FROM pg_type as p1
> ! WHERE p1.typtype = 'b' AND p1.typname NOT LIKE '\\_%' AND NOT EXISTS
>       (SELECT 1 FROM pg_type as p2
>        WHERE p2.typname = ('_' || p1.typname)::name AND
>              p2.typelem = p1.oid);
> --- 60,66 ----
>   -- NOTE: as of 7.3, this check finds SET, smgr, and unknown.
>   SELECT p1.oid, p1.typname
>   FROM pg_type as p1
> ! WHERE p1.typtype in ('b','d') AND p1.typname NOT LIKE '\\_%' AND NOT EXISTS
>       (SELECT 1 FROM pg_type as p2
>        WHERE p2.typname = ('_' || p1.typname)::name AND
>              p2.typelem = p1.oid);
> 
> ======================================================================
> 
> *** ./expected/domain.out	Fri Jul 12 14:43:19 2002
> --- ./results/domain.out	Tue Aug 20 01:32:57 2002
> ***************
> *** 143,154 ****
>               ( col1 ddef1
>               , col2 ddef2
>               , col3 ddef3
> !             , col4 ddef4
>               , col5 ddef1 NOT NULL DEFAULT NULL
>               , col6 ddef2 DEFAULT '88'
>               , col7 ddef4 DEFAULT 8000
>   		, col8 ddef5
>               );
>   insert into defaulttest default values;
>   insert into defaulttest default values;
>   insert into defaulttest default values;
> --- 143,155 ----
>               ( col1 ddef1
>               , col2 ddef2
>               , col3 ddef3
> !             , col4 ddef4 PRIMARY KEY
>               , col5 ddef1 NOT NULL DEFAULT NULL
>               , col6 ddef2 DEFAULT '88'
>               , col7 ddef4 DEFAULT 8000
>               , col8 ddef5
>               );
> + NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'defaulttest_pkey' for table 'defaulttest'
>   insert into defaulttest default values;
>   insert into defaulttest default values;
>   insert into defaulttest default values;
> 
> ======================================================================
> 
> Cheers,
> 
> Neil
> 
> -- 
> Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 



20 Aug 2002 08:05:45 -0400
Rod Taylor <rbt@zort.ca>
Re: regression test failures in CVS HEAD