After experiencing so many problems with 7.3.2, I decided to test
7.4-snapshot. It failed only on one test, instead of 17.

NetBSD-1.6 / Alpha (64-bit)
Postgresql-7.4-snapshot-2003-03-24

The error I'm getting is:

  ! ERROR:  datumGetSize: Invalid typLen 0

That error caused many problems in 7.3.2. I sent an email about this but
it must be stuck in the queue because it had an attachment of 234k.

---------------------------
*** ./expected/opr_sanity.out   Tue Jan 28 16:13:41 2003
--- ./results/opr_sanity.out    Wed Mar 26 22:08:17 2003
***************
*** 46,55 ****
      p1.proname = p2.proname AND
      p1.pronargs = p2.pronargs AND
      p1.proargtypes = p2.proargtypes;
!  oid | proname | oid | proname
! -----+---------+-----+---------
! (0 rows)
!
  -- Considering only built-in procs (prolang = 12), look for multiple
uses
  -- of the same internal function (ie, matching prosrc fields).  It's OK
to
  -- have several entries with different pronames for the same internal
function,
--- 46,52 ----
      p1.proname = p2.proname AND
      p1.pronargs = p2.pronargs AND
      p1.proargtypes = p2.proargtypes;
! ERROR:  datumGetSize: Invalid typLen 0
  -- Considering only built-in procs (prolang = 12), look for multiple
uses
  -- of the same internal function (ie, matching prosrc fields).  It's OK
to
  -- have several entries with different pronames for the same internal
function,
***************
*** 276,285 ****
      p1.oprkind = p2.oprkind AND
      p1.oprleft = p2.oprleft AND
      p1.oprright = p2.oprright;
!  oid | oprcode | oid | oprcode
! -----+---------+-----+---------
! (0 rows)
!
  -- Look for commutative operators that don't commute.
  -- DEFINITIONAL NOTE: If A.oprcom = B, then x A y has the same result as
y B x.
  -- We expect that B will always say that B.oprcom = A as well; that's
not
--- 273,279 ----
      p1.oprkind = p2.oprkind AND
      p1.oprleft = p2.oprleft AND
      p1.oprright = p2.oprright;
! ERROR:  datumGetSize: Invalid typLen 0
  -- Look for commutative operators that don't commute.
  -- DEFINITIONAL NOTE: If A.oprcom = B, then x A y has the same result as
y B x.
  -- We expect that B will always say that B.oprcom = A as well; that's
not

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

--
Thomas


Wed, 26 Mar 2003 22:18:10 -0600 (CST)
"Thomas T. Thai" <tom@minnesota.com>
7.4-snapshot regression: ERROR:  datumGetSize: Invalid typLen 0