This is an automated email from the ASF dual-hosted git repository.
reshke pushed a commit to branch backport_cve
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/backport_cve by this push:
new 57a2a77c266 Backport adaptations
57a2a77c266 is described below
commit 57a2a77c266083a0f53754580783a50d46f1d1a7
Author: Kirill Reshke <[email protected]>
AuthorDate: Fri Aug 14 23:42:43 2026 +0500
Backport adaptations
---
src/test/regress/expected/rangetypes_optimizer.out | 15 +++++++++++++++
1 file changed, 15 insertions(+)
diff --git a/src/test/regress/expected/rangetypes_optimizer.out
b/src/test/regress/expected/rangetypes_optimizer.out
index 65b38d385a7..6c434170aa6 100644
--- a/src/test/regress/expected/rangetypes_optimizer.out
+++ b/src/test/regress/expected/rangetypes_optimizer.out
@@ -1553,6 +1553,21 @@ ERROR: range lower bound must be less than or equal to
range upper bound
LINE 1: select '[2010-01-01 01:00:00 -08, 2010-01-01 02:00:00 -05)':...
^
set timezone to default;
+-- CREATE TYPE AS RANGE checks for USAGE on subtype
+CREATE ROLE regress_subtype;
+CREATE TYPE mytype AS (a INT, b INT);
+REVOKE USAGE ON TYPE mytype FROM PUBLIC;
+SET ROLE regress_subtype;
+CREATE TYPE myrange AS RANGE (subtype = mytype);
+ERROR: permission denied for type mytype
+RESET ROLE;
+GRANT USAGE ON TYPE mytype TO regress_subtype;
+SET ROLE regress_subtype;
+CREATE TYPE myrange AS RANGE (subtype = mytype);
+RESET ROLE;
+DROP TYPE mytype CASCADE;
+NOTICE: drop cascades to type myrange
+DROP ROLE regress_subtype;
--
-- Test user-defined range of floats
-- (type float8range was already made in test_setup.sql)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
