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 ba1fc8530cc Fix answer files for prepare and rangefuncs
ba1fc8530cc is described below
commit ba1fc8530cccacaf84cf695e9040a44691e5ce8a
Author: Jinbao Chen <[email protected]>
AuthorDate: Sun Dec 21 02:34:49 2025 +0800
Fix answer files for prepare and rangefuncs
---
src/test/regress/expected/prepare.out | 2 +-
src/test/regress/expected/rangefuncs.out | 22 +++++-----------------
2 files changed, 6 insertions(+), 18 deletions(-)
diff --git a/src/test/regress/expected/prepare.out
b/src/test/regress/expected/prepare.out
index b6b1a81f095..d52b3bc9fef 100644
--- a/src/test/regress/expected/prepare.out
+++ b/src/test/regress/expected/prepare.out
@@ -62,7 +62,7 @@ PREPARE q2(text) AS
EXECUTE q2('postgres');
datname | datistemplate | datallowconn
----------+---------------+--------------
- postgres | t | t
+ postgres | f | t
(1 row)
PREPARE q3(text, int, float, boolean, smallint) AS
diff --git a/src/test/regress/expected/rangefuncs.out
b/src/test/regress/expected/rangefuncs.out
index f13014902f4..9aa7a91a71f 100644
--- a/src/test/regress/expected/rangefuncs.out
+++ b/src/test/regress/expected/rangefuncs.out
@@ -2233,14 +2233,11 @@ delete from pg_depend where
returning pg_describe_object(classid, objid, objsubid) as obj,
pg_describe_object(refclassid, refobjid, refobjsubid) as ref,
deptype;
- obj | ref | deptype
---------------------------------+--------------------------------+---------
- rule _RETURN on view usersview | column moredrop of table users | n
-(1 row)
-
+ERROR: permission denied: "pg_depend" is a system catalog
alter table users drop column moredrop cascade;
+ERROR: current transaction is aborted, commands ignored until end of
transaction block
select * from usersview; -- expect clean failure
-ERROR: attribute 5 of type record has been dropped
+ERROR: current transaction is aborted, commands ignored until end of
transaction block
rollback;
alter table users alter column seq type numeric; -- fail, view has reference
ERROR: cannot alter type of a column used by a view or rule
@@ -2255,19 +2252,10 @@ delete from pg_depend where
returning pg_describe_object(classid, objid, objsubid) as obj,
pg_describe_object(refclassid, refobjid, refobjsubid) as ref,
deptype;
- obj | ref | deptype
---------------------------------+---------------------------+---------
- rule _RETURN on view usersview | column seq of table users | n
-(1 row)
-
+ERROR: permission denied: "pg_depend" is a system catalog
-- alter table users alter column seq type numeric;
select * from usersview; -- expect clean failure
- userid | seq | email | moredrop | enabled | generate_series | ordinality
---------+-----+--------+----------+---------+-----------------+------------
- id | 1 | email | 11 | t | 10 | 1
- id2 | 2 | email2 | 12 | t | 11 | 2
-(2 rows)
-
+ERROR: current transaction is aborted, commands ignored until end of
transaction block
rollback;
drop view usersview;
drop function get_first_user();
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
