Movatterモバイル変換

[0]ホーム
URL:

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

 Sign up
Appearance settings

Commitdeec80e

Browse files
committed
Fix query checking consistency of table amhandlers in opr_sanity.sql
As written, the query checked for an access method of type 's', which isnot an AM type supported in the core code.Error introduced by8586bf7. As this query is not checking what itshould, backpatch all the way down.Reviewed-by: Aleksander AlekseevDiscussion:https://postgr.es/m/ZVxJkAJrKbfHETiy@paquier.xyzBackpatch-through: 12
1 parent4f8d3c5 commitdeec80e

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

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

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1848,7 +1848,7 @@ WHERE p2.oid = p1.amhandler AND p1.amtype = 'i' AND
18481848
-- Check for table amhandler functions with the wrong signature
18491849
SELECT p1.oid, p1.amname, p2.oid, p2.proname
18501850
FROM pg_am AS p1, pg_proc AS p2
1851-
WHERE p2.oid = p1.amhandler AND p1.amtype = 's' AND
1851+
WHERE p2.oid = p1.amhandler AND p1.amtype = 't' AND
18521852
(p2.prorettype != 'table_am_handler'::regtype
18531853
OR p2.proretset
18541854
OR p2.pronargs != 1

‎src/test/regress/sql/opr_sanity.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1213,7 +1213,7 @@ WHERE p2.oid = p1.amhandler AND p1.amtype = 'i' AND
12131213

12141214
SELECTp1.oid,p1.amname,p2.oid,p2.proname
12151215
FROM pg_amAS p1, pg_procAS p2
1216-
WHEREp2.oid=p1.amhandlerANDp1.amtype='s'AND
1216+
WHEREp2.oid=p1.amhandlerANDp1.amtype='t'AND
12171217
(p2.prorettype!='table_am_handler'::regtype
12181218
ORp2.proretset
12191219
ORp2.pronargs!=1

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp