leborchuk commented on PR #1637:
URL: https://github.com/apache/cloudberry/pull/1637#issuecomment-4127702109
stats_ext test with gporca enabled failed with
```
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/__w/cloudberry/cloudberry/src/test/regress/expected/stats_ext_optimizer.out
/__w/cloudberry/cloudberry/src/test/regress/results/stats_ext.out
---
/__w/cloudberry/cloudberry/src/test/regress/expected/stats_ext_optimizer.out
2026-03-24 12:26:47.306277668 +0000
+++ /__w/cloudberry/cloudberry/src/test/regress/results/stats_ext.out
2026-03-24 12:26:47.387277789 +0000
@@ -3276,6 +3276,23 @@
s_expr | {secret}
(2 rows)
+-- CREATE STATISTICS checks for CREATE on the schema
+RESET SESSION AUTHORIZATION;
+CREATE SCHEMA sts_sch1 CREATE TABLE sts_sch1.tbl (a INT, b INT);
+GRANT USAGE ON SCHEMA sts_sch1 TO regress_stats_user1;
+ALTER TABLE sts_sch1.tbl OWNER TO regress_stats_user1;
+SET SESSION AUTHORIZATION regress_stats_user1;
+CREATE STATISTICS sts_sch1.fail ON a, b FROM sts_sch1.tbl;
+ERROR: permission denied for schema sts_sch1
+RESET SESSION AUTHORIZATION;
+GRANT CREATE ON SCHEMA sts_sch1 TO regress_stats_user1;
+SET SESSION AUTHORIZATION regress_stats_user1;
+CREATE STATISTICS sts_sch1.pass ON a, b FROM sts_sch1.tbl;
+-- re-creating statistics via ALTER TABLE bypasses checks for CREATE on
schema
+RESET SESSION AUTHORIZATION;
+REVOKE CREATE ON SCHEMA sts_sch1 FROM regress_stats_user1;
+SET SESSION AUTHORIZATION regress_stats_user1;
+ALTER TABLE sts_sch1.tbl ALTER COLUMN a TYPE SMALLINT;
-- Tidy up
DROP OPERATOR <<< (int, int);
DROP FUNCTION op_leak(int, int);
@@ -3285,6 +3302,8 @@
DETAIL: drop cascades to table tststats.priv_test_tbl
NOTICE: drop cascades to 2 other objects
drop cascades to view tststats.priv_test_view
+DROP SCHEMA sts_sch1 CASCADE;
+NOTICE: drop cascades to table sts_sch1.tbl
DROP USER regress_stats_user1;
-- test analyze with extended statistics
CREATE TABLE tbl_issue1293 (col1 int, col2 int);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
