regression.diffs

application/octet-stream

Filename: regression.diffs
Type: application/octet-stream
Part: 0
Message: Re: WIP: BRIN multi-range indexes
*** /Users/mark/master/postgresql/src/test/regress/expected/oidjoins.out	2017-11-10 06:50:30.000000000 -0800
--- /Users/mark/master/postgresql/src/test/regress/results/oidjoins.out	2017-12-19 11:31:42.000000000 -0800
***************
*** 621,629 ****
  FROM	pg_catalog.pg_opclass fk
  WHERE	opcfamily != 0 AND
  	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
!  ctid | opcfamily 
! ------+-----------
! (0 rows)
  
  SELECT	ctid, opcintype
  FROM	pg_catalog.pg_opclass fk
--- 621,630 ----
  FROM	pg_catalog.pg_opclass fk
  WHERE	opcfamily != 0 AND
  	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
!   ctid  | opcfamily 
! --------+-----------
!  (1,57) |      5028
! (1 row)
  
  SELECT	ctid, opcintype
  FROM	pg_catalog.pg_opclass fk

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

*** /Users/mark/master/postgresql/src/test/regress/expected/opr_sanity.out	2017-12-19 11:28:04.000000000 -0800
--- /Users/mark/master/postgresql/src/test/regress/results/opr_sanity.out	2017-12-19 11:31:44.000000000 -0800
***************
*** 1700,1709 ****
  -- Ask access methods to validate opclasses
  -- (this replaces a lot of SQL-level checks that used to be done in this file)
  SELECT oid, opcname FROM pg_opclass WHERE NOT amvalidate(oid);
!  oid | opcname 
! -----+---------
! (0 rows)
! 
  -- **************** pg_am ****************
  -- Look for illegal values in pg_am fields
  SELECT p1.oid, p1.amname
--- 1700,1706 ----
  -- Ask access methods to validate opclasses
  -- (this replaces a lot of SQL-level checks that used to be done in this file)
  SELECT oid, opcname FROM pg_opclass WHERE NOT amvalidate(oid);
! ERROR:  cache lookup failed for operator family 5028
  -- **************** pg_am ****************
  -- Look for illegal values in pg_am fields
  SELECT p1.oid, p1.amname
***************
*** 1901,1909 ****
  WHERE NOT EXISTS(SELECT 1 FROM pg_amop AS p2
                   WHERE p2.amopfamily = p1.opcfamily
                     AND binary_coercible(p1.opcintype, p2.amoplefttype));
!  opcname | opcfamily 
! ---------+-----------
! (0 rows)
  
  -- Check that each operator listed in pg_amop has an associated opclass,
  -- that is one whose opcintype matches oprleft (possibly by coercion).
--- 1898,1907 ----
  WHERE NOT EXISTS(SELECT 1 FROM pg_amop AS p2
                   WHERE p2.amopfamily = p1.opcfamily
                     AND binary_coercible(p1.opcintype, p2.amoplefttype));
!     opcname    | opcfamily 
! ---------------+-----------
!  oid_bloom_ops |      5028
! (1 row)
  
  -- Check that each operator listed in pg_amop has an associated opclass,
  -- that is one whose opcintype matches oprleft (possibly by coercion).
***************
*** 1918,1924 ****
                     AND binary_coercible(p2.opcintype, p1.amoplefttype));
   amopfamily | amopstrategy | amopopr 
  ------------+--------------+---------
! (0 rows)
  
  -- Operators that are primary members of opclasses must be immutable (else
  -- it suggests that the index ordering isn't fixed).  Operators that are
--- 1916,1923 ----
                     AND binary_coercible(p2.opcintype, p1.amoplefttype));
   amopfamily | amopstrategy | amopopr 
  ------------+--------------+---------
!        5029 |            1 |     607
! (1 row)
  
  -- Operators that are primary members of opclasses must be immutable (else
  -- it suggests that the index ordering isn't fixed).  Operators that are

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