Fix misc_sanity test to accept SHARED_DEPENDENCY_INITACL entries.

tglsfdc · tglsfdc · commit 01aa88f71208 · 2024-06-14T15:29:09.000-04:00
Oversight in 5342874. We missed this up to now because the core regression tests create no such entries (at least up to this test), so the only way to see the failure is to do "make installcheck" in an installation where some other DB has such entries. I happened to do that just now ...
diff --git a/src/test/regress/expected/misc_sanity.out b/src/test/regress/expected/misc_sanity.out
@@ -26,7 +26,7 @@ SELECT *
 FROM pg_shdepend as d1
 WHERE refclassid = 0 OR refobjid = 0 OR
       classid = 0 OR objid = 0 OR
-      deptype NOT IN ('a', 'o', 'r', 't');
+      deptype NOT IN ('a', 'i', 'o', 'r', 't');
  dbid | classid | objid | objsubid | refclassid | refobjid | deptype 
 ------+---------+-------+----------+------------+----------+---------
 (0 rows)
diff --git a/src/test/regress/sql/misc_sanity.sql b/src/test/regress/sql/misc_sanity.sql
@@ -30,7 +30,7 @@ SELECT *
 FROM pg_shdepend as d1
 WHERE refclassid = 0 OR refobjid = 0 OR
       classid = 0 OR objid = 0 OR
-      deptype NOT IN ('a', 'o', 'r', 't');
+      deptype NOT IN ('a', 'i', 'o', 'r', 't');
 
 
 -- **************** pg_class ****************
