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

Commit9d9ece4

Browse files
committed
Fix test case fromb0c5b21.
I'd not checked that this iteration of the test actually workedwith a bootstrap superuser not named 'postgres'. It didn't,because the coercion rules for CASE caused us to try to castthe 'postgres' literal to regrole. Mea culpa.Per buildfarm (via Alexander Korotkov)Discussion:https://postgr.es/m/CAPpHfdsV=iTvH6B858hnH1bLgewYH6cdTnO_eOOw9EOa8kehkA@mail.gmail.com
1 parentb0c5b21 commit9d9ece4

File tree

2 files changed

+8
-8
lines changed

2 files changed

+8
-8
lines changed

‎src/test/modules/test_pg_dump/expected/test_pg_dump.out

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -65,9 +65,9 @@ GRANT USAGE ON TYPE test_pg_dump_e1 TO regress_dump_test_role;
6565
-- Substitute for current user's name to keep test output consistent
6666
SELECT s.obj,
6767
CASE WHEN a.grantor::regrole::name = current_user THEN 'postgres'
68-
ELSE a.grantor::regrole END,
68+
ELSE a.grantor::regrole::name END,
6969
CASE WHEN a.grantee::regrole::name = current_user THEN 'postgres'
70-
ELSE a.grantee::regrole END,
70+
ELSE a.grantee::regrole::name END,
7171
a.privilege_type, a.is_grantable
7272
FROM
7373
(SELECT pg_describe_object(classoid,objoid,objsubid) AS obj, initprivs
@@ -202,9 +202,9 @@ DROP OWNED BY regress_dump_test_role RESTRICT;
202202
-- Substitute for current user's name to keep test output consistent
203203
SELECT s.obj,
204204
CASE WHEN a.grantor::regrole::name = current_user THEN 'postgres'
205-
ELSE a.grantor::regrole END,
205+
ELSE a.grantor::regrole::name END,
206206
CASE WHEN a.grantee::regrole::name = current_user THEN 'postgres'
207-
ELSE a.grantee::regrole END,
207+
ELSE a.grantee::regrole::name END,
208208
a.privilege_type, a.is_grantable
209209
FROM
210210
(SELECT pg_describe_object(classoid,objoid,objsubid) AS obj, initprivs

‎src/test/modules/test_pg_dump/sql/test_pg_dump.sql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -78,9 +78,9 @@ GRANT USAGE ON TYPE test_pg_dump_e1 TO regress_dump_test_role;
7878
-- Substitute for current user's name to keep test output consistent
7979
SELECTs.obj,
8080
CASE WHENa.grantor::regrole::name=current_user THEN'postgres'
81-
ELSEa.grantor::regrole END,
81+
ELSEa.grantor::regrole::name END,
8282
CASE WHENa.grantee::regrole::name=current_user THEN'postgres'
83-
ELSEa.grantee::regrole END,
83+
ELSEa.grantee::regrole::name END,
8484
a.privilege_type,a.is_grantable
8585
FROM
8686
(SELECT pg_describe_object(classoid,objoid,objsubid)AS obj, initprivs
@@ -130,9 +130,9 @@ DROP OWNED BY regress_dump_test_role RESTRICT;
130130
-- Substitute for current user's name to keep test output consistent
131131
SELECTs.obj,
132132
CASE WHENa.grantor::regrole::name=current_user THEN'postgres'
133-
ELSEa.grantor::regrole END,
133+
ELSEa.grantor::regrole::name END,
134134
CASE WHENa.grantee::regrole::name=current_user THEN'postgres'
135-
ELSEa.grantee::regrole END,
135+
ELSEa.grantee::regrole::name END,
136136
a.privilege_type,a.is_grantable
137137
FROM
138138
(SELECT pg_describe_object(classoid,objoid,objsubid)AS obj, initprivs

0 commit comments

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