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
======================================================================