This is an automated email from the ASF dual-hosted git repository. reshke pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit 6b9df409a5d8fbb852906d255e039f90b69b0ba3 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]
