8000 Update oidjoins test to match CVS HEAD. · postgrespro/postgres_cluster@d6dfa1e · GitHub
[go: up one dir, main page]
Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Commit d6dfa1e

Browse files
tglsfdctglsfdc
committed
Update oidjoins test to match CVS HEAD.
1 parent 556dfb5 commit d6dfa1e

File tree

3 files changed

+52
-7
lines changed

3 files changed

+52
-7
lines changed

‎src/test/regress/expected/oidjoins.out

Lines changed: 17 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
2+
-- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
33
--
44
SELECT ctid, aggfnoid
55
FROM pg_catalog.pg_aggregate fk
@@ -41,6 +41,14 @@ WHERE aggtranstype != 0 AND
4141
------+--------------
4242
(0 rows)
4343

44+
SELECT ctid, amkeytype
45+
FROM pg_catalog.pg_am fk
46+
WHERE amkeytype != 0 AND
47+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amkeytype);
48+
ctid | amkeytype
49+
------+-----------
50+
(0 rows)
51+
4452
SELECT ctid, aminsert
4553
FROM pg_catalog.pg_am fk
4654
WHERE aminsert != 0 AND
@@ -921,6 +929,14 @@ WHERE typmodout != 0 AND
921929
------+-----------
922930
(0 rows)
923931

932+
SELECT ctid, typanalyze
933+
FROM pg_catalog.pg_type fk
934+
WHERE typanalyze != 0 AND
935+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
936+
ctid | typanalyze
937+
------+------------
938+
(0 rows)
939+
924940
SELECT ctid, typbasetype
925941
FROM pg_catalog.pg_type fk
926942
WHERE typbasetype != 0 AND

‎src/test/regress/sql/oidjoins.sql

Lines changed: 9 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
2+
-- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
33
--
44
SELECT ctid, aggfnoid
55
FROM pg_catalog.pg_aggregate fk
@@ -21,6 +21,10 @@ SELECT ctid, aggtranstype
2121
FROM pg_catalog.pg_aggregate fk
2222
WHERE aggtranstype != 0 AND
2323
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
24+
SELECT ctid, amkeytype
25+
FROM pg_catalog.pg_am fk
26+
WHERE amkeytype != 0 AND
27+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amkeytype);
2428
SELECT ctid, aminsert
2529
FROM pg_catalog.pg_am fk
2630
WHERE aminsert != 0 AND
@@ -461,6 +465,10 @@ SELECT ctid, typmodout
461465
FROM pg_catalog.pg_type fk
462466
WHERE typmodout != 0 AND
463467
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodout);
468+
SELECT ctid, typanalyze
469+
FROM pg_catalog.pg_type fk
470+
WHERE typanalyze != 0 AND
471+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
464472
SELECT ctid, typbasetype
465473
FROM pg_catalog.pg_type fk
466474
WHERE typbasetype != 0 AND

‎src/tools/findoidjoins/README

Lines changed: 26 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
$PostgreSQL: pgsql/src/tools/findoidjoins/README,v 1.5 2008/03/21 13:23:29 momjian Exp $
1+
$PostgreSQL: pgsql/src/tools/findoidjoins/README,v 1.6 2008/10/13 12:59:57 tgl Exp $
22

33
findoidjoins
44
============
@@ -9,10 +9,10 @@ anything but an empty database, such as template1; else it's likely to
99
be very slow.
1010

1111
Run on an empty database, it returns the system join relationships (shown
12-
below for 8.3). Note that unexpected matches may indicate bogus entries
12+
below for 8.4devel). Note that unexpected matches may indicate bogus entries
1313
in system tables --- don't accept a peculiar match without question.
1414
In particular, a field shown as joining to more than one target table is
15-
probably messed up. In 8.3, the *only* fields that should join to more
15+
probably messed up. In 8.4devel, the *only* fields that should join to more
1616
than one target are pg_description.objoid, pg_depend.objid,
1717
pg_depend.refobjid, pg_shdescription.objoid, pg_shdepend.objid, and
1818
pg_shdepend.refobjid. (Running make_oidjoins_check is an easy way to spot
@@ -31,10 +31,12 @@ revision in the patterns of cross-links between system tables.
3131
(Ideally we'd just regenerate the script as part of the regression
3232
tests themselves, but that seems too slow...)
3333

34-
NOTE: in 8.3, make_oidjoins_check produces two bogus join checks:
34+
NOTE: in 8.4devel, make_oidjoins_check produces two bogus join checks:
3535
Join pg_catalog.pg_class.relfilenode => pg_catalog.pg_class.oid
3636
Join pg_catalog.pg_database.datlastsysoid => pg_catalog.pg_database.oid
3737
These are artifacts and should not be added to the oidjoins regress test.
38+
You might also get output for pg_shdepend.refobjid and pg_shdescription.objoid,
39+
neither of which should be added.
3840

3941
---------------------------------------------------------------------------
4042

@@ -43,10 +45, 67F4 11 @@ Join pg_catalog.pg_aggregate.aggtransfn => pg_catalog.pg_proc.oid
4345
Join pg_catalog.pg_aggregate.aggfinalfn => pg_catalog.pg_proc.oid
4446
Join pg_catalog.pg_aggregate.aggsortop => pg_catalog.pg_operator.oid
4547
Join pg_catalog.pg_aggregate.aggtranstype => pg_catalog.pg_type.oid
48+
Join pg_catalog.pg_am.amkeytype => pg_catalog.pg_type.oid
4649
Join pg_catalog.pg_am.aminsert => pg_catalog.pg_proc.oid
4750
Join pg_catalog.pg_am.ambeginscan => pg_catalog.pg_proc.oid
4851
Join pg_catalog.pg_am.amgettuple => pg_catalog.pg_proc.oid
49-
Join pg_catalog.pg_am.amgetmulti => pg_catalog.pg_proc.oid
52+
Join pg_catalog.pg_am.amgetbitmap => pg_catalog.pg_proc.oid
5053
Join pg_catalog.pg_am.amrescan => pg_catalog.pg_proc.oid
5154
Join pg_catalog.pg_am.amendscan => pg_catalog.pg_proc.oid
5255
Join pg_catalog.pg_am.ammarkpos => pg_catalog.pg_proc.oid
@@ -125,6 +128,23 @@ Join pg_catalog.pg_statistic.staop3 => pg_catalog.pg_operator.oid
125128
Join pg_catalog.pg_tablespace.spcowner => pg_catalog.pg_authid.oid
126129
Join pg_catalog.pg_trigger.tgrelid => pg_catalog.pg_class.oid
127130
Join pg_catalog.pg_trigger.tgfoid => pg_catalog.pg_proc.oid
131+
Join pg_catalog.pg_ts_config.cfgnamespace => pg_catalog.pg_namespace.oid
132+
Join pg_catalog.pg_ts_config.cfgowner => pg_catalog.pg_authid.oid
133+
Join pg_catalog.pg_ts_config.cfgparser => pg_catalog.pg_ts_parser.oid
134+
Join pg_catalog.pg_ts_config_map.mapcfg => pg_catalog.pg_ts_config.oid
135+
Join pg_catalog.pg_ts_config_map.mapdict => pg_catalog.pg_ts_dict.oid
136+
Join pg_catalog.pg_ts_dict.dictnamespace => pg_catalog.pg_namespace.oid
137+
Join pg_catalog.pg_ts_dict.dictowner => pg_catalog.pg_authid.oid
138+
Join pg_catalog.pg_ts_dict.dicttemplate => pg_catalog.pg_ts_template.oid
139+
Join pg_catalog.pg_ts_parser.prsnamespace => pg_catalog.pg_namespace.oid
140+
Join pg_catalog.pg_ts_parser.prsstart => pg_catalog.pg_proc.oid
141+
Join pg_catalog.pg_ts_parser.prstoken => pg_catalog.pg_proc.oid
142+
Join pg_catalog.pg_ts_parser.prsend => pg_catalog.pg_proc.oid
143+
Join pg_catalog.pg_ts_parser.prsheadline => pg_catalog.pg_proc.oid
144+
Join pg_catalog.pg_ts_parser.prslextype => pg_catalog.pg_proc.oid
145+
Join pg_catalog.pg_ts_template.tmplnamespace => pg_catalog.pg_namespace.oid
146+
Join pg_catalog.pg_ts_template.tmplinit => pg_catalog.pg_proc.oid
147+
Join pg_catalog.pg_ts_template.tmpllexize => pg_catalog.pg_proc.oid
128148
Join pg_catalog.pg_type.typnamespace => pg_catalog.pg_namespace.oid
129149
Join pg_catalog.pg_type.typowner => pg_catalog.pg_authid.oid
130150
Join pg_catalog.pg_type.typrelid => pg_catalog.pg_class.oid
@@ -136,6 +156,7 @@ Join pg_catalog.pg_type.typreceive => pg_catalog.pg_proc.oid
136156
Join pg_catalog.pg_type.typsend => pg_catalog.pg_proc.oid
137157
Join pg_catalog.pg_type.typmodin => pg_catalog.pg_proc.oid
138158
Join pg_catalog.pg_type.typmodout => pg_catalog.pg_proc.oid
159+
Join pg_catalog.pg_type.typanalyze => pg_catalog.pg_proc.oid
139160
Join pg_catalog.pg_type.typbasetype => pg_catalog.pg_type.oid
140161

141162
---------------------------------------------------------------------------

0 commit comments

Comments
 (0)
0