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

Commit266e771

Browse files
committed
Fix entirely broken permissions test in new alter_operator regression test.
Not only did this test fail to test what it was supposed to test, but itleft a user definition lying around, which caused subsequent runs of theregression tests to fail.
1 parenta04bb65 commit266e771

File tree

2 files changed

+7
-10
lines changed

2 files changed

+7
-10
lines changed

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

Lines changed: 4 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -66,11 +66,10 @@ ERROR: operator attribute "negator" can not be changed
6666
-- Test permission check. Must be owner to ALTER OPERATOR.
6767
--
6868
CREATE USER regtest_alter_user;
69-
SET SESSION AUTHORIZATION regtest_alter_user_user;
70-
ERROR: role "regtest_alter_user_user" does not exist
69+
SET SESSION AUTHORIZATION regtest_alter_user;
7170
ALTER OPERATOR === (boolean, boolean) SET (RESTRICT = NONE);
72-
RESET SESSION AUTHORIZATION;
71+
ERROR: must be owner of operator ===
7372
-- Clean up
74-
DROP USER regression_alter_user;
75-
ERROR: role "regression_alter_user" does not exist
73+
RESET SESSION AUTHORIZATION;
74+
DROP USER regtest_alter_user;
7675
DROP OPERATOR === (boolean, boolean);

‎src/test/regress/sql/alter_operator.sql

Lines changed: 3 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -48,17 +48,15 @@ ALTER OPERATOR === (boolean, boolean) SET (JOIN = non_existent_func);
4848
ALTEROPERATOR=== (boolean,boolean)SET (COMMUTATOR=!==);
4949
ALTEROPERATOR=== (boolean,boolean)SET (NEGATOR=!==);
5050

51-
5251
--
5352
-- Test permission check. Must be owner to ALTER OPERATOR.
5453
--
5554
CREATEUSERregtest_alter_user;
56-
SET SESSION AUTHORIZATIONregtest_alter_user_user;
55+
SET SESSION AUTHORIZATIONregtest_alter_user;
5756

5857
ALTEROPERATOR=== (boolean,boolean)SET (RESTRICT= NONE);
5958

60-
RESET SESSION AUTHORIZATION;
61-
6259
-- Clean up
63-
DROPUSER regression_alter_user;
60+
RESET SESSION AUTHORIZATION;
61+
DROPUSER regtest_alter_user;
6462
DROPOPERATOR=== (boolean,boolean);

0 commit comments

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