1 files changed, 108 insertions, 0 deletions
diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out
index c02d51d0a0c..f044006daad 100644
--- a/src/test/regress/expected/opr_sanity.out
+++ b/src/test/regress/expected/opr_sanity.out
@@ -6,6 +6,114 @@ oid|proname
 ---+-------
 (0 rows)
 
+QUERY: SELECT p1.oid, p1.proname, p2.oid, p2.proname
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.proname = p2.proname AND
+    p1.pronargs = p2.pronargs AND
+    p1.proargtypes = p2.proargtypes;
+oid|proname|oid|proname
+---+-------+---+-------
+(0 rows)
+
+QUERY: SELECT p1.oid, p1.proname, p2.oid, p2.proname
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proisinh != p2.proisinh OR
+     p1.proistrusted != p2.proistrusted OR
+     p1.proiscachable != p2.proiscachable OR
+     p1.pronargs != p2.pronargs OR
+     p1.proretset != p2.proretset);
+oid|proname|oid|proname
+---+-------+---+-------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.prorettype, p2.prorettype
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.prorettype < p2.prorettype);
+prorettype|prorettype
+----------+----------
+        18|        25
+        25|      1043
+(2 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[0], p2.proargtypes[0]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[0] < p2.proargtypes[0]);
+proargtypes|proargtypes
+-----------+-----------
+         25|       1043
+       1042|       1043
+(2 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[1], p2.proargtypes[1]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[1] < p2.proargtypes[1]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[2], p2.proargtypes[2]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[2] < p2.proargtypes[2]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[3], p2.proargtypes[3]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[3] < p2.proargtypes[3]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[4], p2.proargtypes[4]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[4] < p2.proargtypes[4]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[5], p2.proargtypes[5]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[5] < p2.proargtypes[5]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[6], p2.proargtypes[6]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[6] < p2.proargtypes[6]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
+QUERY: SELECT DISTINCT p1.proargtypes[7], p2.proargtypes[7]
+FROM pg_proc AS p1, pg_proc AS p2
+WHERE p1.oid != p2.oid AND
+    p1.prosrc = p2.prosrc AND p1.prolang = 11 AND p2.prolang = 11 AND
+    (p1.proargtypes[7] < p2.proargtypes[7]);
+proargtypes|proargtypes
+-----------+-----------
+(0 rows)
+
 QUERY: SELECT p1.oid, p1.oprname
 FROM pg_operator as p1
 WHERE (p1.oprkind != 'b' AND p1.oprkind != 'l' AND p1.oprkind != 'r') OR