This is an automated email from the ASF dual-hosted git repository.
chenjinbao1989 pushed a commit to branch cbdb-postgres-merge
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/cbdb-postgres-merge by this
push:
new 684d051dd8e Fix answer file for gp_owner_permission
684d051dd8e is described below
commit 684d051dd8e47e278548a188ef0bc1beca715b79
Author: Jinbao Chen <[email protected]>
AuthorDate: Thu Jan 1 20:55:30 2026 +0800
Fix answer file for gp_owner_permission
---
src/test/regress/expected/gp_owner_permission.out | 11 ++++-------
src/test/regress/sql/gp_owner_permission.sql | 2 +-
2 files changed, 5 insertions(+), 8 deletions(-)
diff --git a/src/test/regress/expected/gp_owner_permission.out
b/src/test/regress/expected/gp_owner_permission.out
index 7140b53cff5..8ad97f50f68 100644
--- a/src/test/regress/expected/gp_owner_permission.out
+++ b/src/test/regress/expected/gp_owner_permission.out
@@ -10,25 +10,22 @@ SET role = test2;
CREATE database reindexdb2;
\c reindexdb2
BEGIN;
-SET role = test1;
+SET role = test2;
CREATE TABLE mytab1_heap(a int, b int);
CREATE INDEX idx_mytab1_heap ON mytab1_heap(b);
INSERT INTO mytab1_heap SELECT a , a - 10 FROM generate_series(1,100) a;
DELETE FROM mytab1_heap WHERE a % 4 = 0;
REVOKE ALL PRIVILEGES ON mytab1_heap FROM test2;
-NOTICE: no privileges could be revoked
CREATE TABLE mytab1_ao(a int, b int) WITH (appendonly = TRUE);
CREATE INDEX idx_mytab1_ao ON mytab1_ao(b);
INSERT INTO mytab1_ao SELECT a , a - 10 FROM generate_series(1,100) a;
DELETE FROM mytab1_ao WHERE a % 4 = 0;
REVOKE ALL PRIVILEGES ON mytab1_ao FROM test2;
-NOTICE: no privileges could be revoked
CREATE TABLE mytab1_aoco(a int, b int) WITH (appendonly = TRUE, orientation =
COLUMN);
CREATE INDEX idx_mytab1_aoco ON mytab1_aoco(b);
INSERT INTO mytab1_aoco SELECT a , a - 10 FROM generate_series(1,100) a;
DELETE FROM mytab1_aoco WHERE a % 4 = 0;
REVOKE ALL PRIVILEGES ON mytab1_aoco FROM test2;
-NOTICE: no privileges could be revoked
COMMIT;
SET role = test2;
SET client_min_messages=WARNING;
@@ -36,18 +33,18 @@ REINDEX DATABASE reindexdb2;
select usename as user_for_reindex_heap from pg_stat_operations where objname
= 'idx_mytab1_heap' and subtype = 'REINDEX' ;
user_for_reindex_heap
-----------------------
- test1
+ test2
(1 row)
select usename as user_for_reindex_ao from pg_stat_operations where objname =
'idx_mytab1_ao' and subtype = 'REINDEX' ;
user_for_reindex_ao
---------------------
- test1
+ test2
(1 row)
select usename as user_for_reindex_aoco from pg_stat_operations where objname
= 'idx_mytab1_aoco' and subtype = 'REINDEX' ;
user_for_reindex_aoco
-----------------------
- test1
+ test2
(1 row)
diff --git a/src/test/regress/sql/gp_owner_permission.sql
b/src/test/regress/sql/gp_owner_permission.sql
index 07b2fa75e9e..16a2c0305c3 100644
--- a/src/test/regress/sql/gp_owner_permission.sql
+++ b/src/test/regress/sql/gp_owner_permission.sql
@@ -12,7 +12,7 @@ CREATE database reindexdb2;
\c reindexdb2
BEGIN;
-SET role = test1;
+SET role = test2;
CREATE TABLE mytab1_heap(a int, b int);
CREATE INDEX idx_mytab1_heap ON mytab1_heap(b);
INSERT INTO mytab1_heap SELECT a , a - 10 FROM generate_series(1,100) a;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
