tuhaihe opened a new issue, #103: URL: https://github.com/apache/cloudberry-backup/issues/103
See: https://github.com/apache/cloudberry-backup/actions/runs/27329506659/job/80744763961?pr=102 Integration test: ``` Will run 549 of 552 specs •S••••••••••• ------------------------------ • [FAILED] [0.009 seconds] backup integration create statement tests PrintRoleMembershipStatements [It] grants a role without ADMIN OPTION /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_create_test.go:418 [FAILED] GRANT usergroup TO testuser GRANTED BY testrole; Expected <*pgconn.PgError | 0xc0002d3590>: ERROR: permission denied to grant privileges as role "testrole" (SQLSTATE 42501) { Severity: "ERROR", Code: "42501", Message: "permission denied to grant privileges as role \"testrole\"", Detail: "The grantor must have the ADMIN option on role \"usergroup\".", Hint: "", Position: 0, InternalPosition: 0, InternalQuery: "", Where: "", SchemaName: "", TableName: "", ColumnName: "", DataTypeName: "", ConstraintName: "", File: "user.c", Line: 3854, Routine: "check_role_grantor", } to be nil In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 @ 06/11/26 00:41:47.232 ------------------------------ ••S•••••••••••••••••••••• ------------------------------ P [PENDING] backup integration tests GetExternalTableDefinitions returns a slice for a complex external table definition TEXT format delimiter /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/predata_externals_queries_test.go:124 ------------------------------ •••••••••••••••••••S•• ------------------------------ • [FAILED] [0.008 seconds] backup integration tests GetRoleMembers [It] returns a role WITH ADMIN OPTION /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_queries_test.go:531 [FAILED] GRANT usergroup TO testuser WITH ADMIN OPTION GRANTED BY testrole Expected <*pgconn.PgError | 0xc0003600f0>: ERROR: permission denied to grant privileges as role "testrole" (SQLSTATE 42501) { Severity: "ERROR", Code: "42501", Message: "permission denied to grant privileges as role \"testrole\"", Detail: "The grantor must have the ADMIN option on role \"usergroup\".", Hint: "", Position: 0, InternalPosition: 0, InternalQuery: "", Where: "", SchemaName: "", TableName: "", ColumnName: "", DataTypeName: "", ConstraintName: "", File: "user.c", Line: 3854, Routine: "check_role_grantor", } to be nil In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 @ 06/11/26 00:41:48.277 ------------------------------ ••••••••••••••••••••••S••••••S•••••••••••••••••••••••••••••••••••••••••••••••••S••••••••••S ------------------------------ • [FAILED] [0.009 seconds] backup integration create statement tests PrintRoleMembershipStatements [It] grants a role WITH ADMIN OPTION /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_create_test.go:435 [FAILED] GRANT usergroup TO testuser WITH ADMIN OPTION GRANTED BY testrole; Expected <*pgconn.PgError | 0xc0004b7950>: ERROR: permission denied to grant privileges as role "testrole" (SQLSTATE 42501) { Severity: "ERROR", Code: "42501", Message: "permission denied to grant privileges as role \"testrole\"", Detail: "The grantor must have the ADMIN option on role \"usergroup\".", Hint: "", Position: 0, InternalPosition: 0, InternalQuery: "", Where: "", SchemaName: "", TableName: "", ColumnName: "", DataTypeName: "", ConstraintName: "", File: "user.c", Line: 3854, Routine: "check_role_grantor", } to be nil In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 @ 06/11/26 00:41:50.693 ------------------------------ •••••••••••• ------------------------------ • [FAILED] [0.021 seconds] backup integration tests GetRoleMembers [It] returns properly quoted roles in GRANT statement /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_queries_test.go:545 [FAILED] Expected structs to match but: Mismatch on field Grantor Expected <string>: gpadmin to equal <string>: \"1testrole\" In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:108 @ 06/11/26 00:41:51.138 ------------------------------ •••••••••••• ------------------------------ • [FAILED] [0.018 seconds] backup integration tests GetRoleMembers [It] handles dropped granter /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_queries_test.go:567 [FAILED] GRANT testdropgranter_role TO testdropgranter_member GRANTED BY testdropgranter_granter Expected <*pgconn.PgError | 0xc0005b4000>: ERROR: permission denied to grant privileges as role "testdropgranter_granter" (SQLSTATE 42501) { Severity: "ERROR", Code: "42501", Message: "permission denied to grant privileges as role \"testdropgranter_granter\"", Detail: "The grantor must have the ADMIN option on role \"testdropgranter_role\".", Hint: "", Position: 0, InternalPosition: 0, InternalQuery: "", Where: "", SchemaName: "", TableName: "", ColumnName: "", DataTypeName: "", ConstraintName: "", File: "user.c", Line: 3854, Routine: "check_role_grantor", } to be nil In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 @ 06/11/26 00:41:51.716 ------------------------------ ••••••S••••••••••••••••S••••••••••••••••S•• ------------------------------ • [FAILED] [0.048 seconds] backup integration create statement tests PrintCreateDummyViewStatement and PrintCreatePostdataViewStatements [It] creates postdata views that replace dummy views /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/postdata_create_test.go:396 [FAILED] Expected structs to match but: Mismatch on field Definition.String Expected <string>: "...LECT key, ..." to equal | <string>: "...LECT view_b..." In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:113 @ 06/11/26 00:41:53.709 ------------------------------ •••••••••••••••S••••••••••••••••••••S•••••••••••••••••••••••••••••••S• •••••••••••S••••••••••••••S•••••••••••••••••••••••••••••••••••••••••••• ------------------------------ ↺ [FLAKEY TEST - TOOK 2 ATTEMPTS TO PASS] [0.080 seconds] backup integration tests BackupDataForAllTables backs up multiple tables with valid data /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/data_backup_test.go:58 ------------------------------ • [FAILED] [0.019 seconds] backup integration tests GetRoleMembers [It] handles implicit cast of oid to text /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_queries_test.go:581 [FAILED] Expected structs to match but: Mismatch on field Grantor Expected <string>: gpadmin to equal <string>: testrole In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:108 @ 06/11/26 00:41:56.899 ------------------------------ ••S ------------------------------ P [PENDING] backup integration create statement tests PrintCreateFunctionStatement Tests for GPDB 7 creates a function with TRANSFORM FOR TYPE /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/predata_functions_create_test.go:225 ------------------------------ •••••••••••••••••••••••••SS•••••••••••••••••••••••••••••S•S••••••••••••••••••••••••••••••••S •••••••••••••••••••••••S••••• ••••••S••••••S••••S• ••••••••••••••• ------------------------------ P [PENDING] backup integration tests GetPartitionDefinitions returns a value for a partition definition for a table with a negative partition value /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/predata_table_defs_queries_test.go:402 ------------------------------ ••••••• ------------------------------ • [FAILED] [0.011 seconds] backup integration tests GetRoleMembers [It] returns a role without ADMIN OPTION /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/integration/metadata_globals_queries_test.go:517 [FAILED] Expected structs to match but: Mismatch on field Grantor Expected <string>: gpadmin to equal <string>: testrole In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:108 @ 06/11/26 00:42:02.912 ------------------------------ ••••••••••••••• Summarizing 8 Failures: [FAIL] backup integration create statement tests PrintRoleMembershipStatements [It] grants a role without ADMIN OPTION /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 [FAIL] backup integration tests GetRoleMembers [It] returns a role WITH ADMIN OPTION /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 [FAIL] backup integration create statement tests PrintRoleMembershipStatements [It] grants a role WITH ADMIN OPTION /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 [FAIL] backup integration tests GetRoleMembers [It] returns properly quoted roles in GRANT statement /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:108 [FAIL] backup integration tests GetRoleMembers [It] handles dropped granter /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/testhelper/functions.go:99 [FAIL] backup integration create statement tests PrintCreateDummyViewStatement and PrintCreatePostdataViewStatements [It] creates postdata views that replace dummy views /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:113 [FAIL] backup integration tests GetRoleMembers [It] handles implicit cast of oid to text /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:108 [FAIL] backup integration tests GetRoleMembers [It] returns a role without ADMIN OPTION /home/gpadmin/go/pkg/mod/github.com/apache/[email protected]/structmatcher/structmatcher.go:108 Ran 524 of 552 Specs in 22.927 seconds FAIL! -- 516 Passed | 8 Failed | 1 Flaked | 3 Pending | 25 Skipped --- FAIL: TestQueries (22.94s) FAIL Ginkgo ran 1 suite in 30.878719786s Test Suite Failed make: *** [Makefile:82: integration] Error 1 ``` End_to_end test: ``` Will run 222 of 222 specs •S•••••••••••••••••••S•••••••••S••••••• ------------------------------ • [FAILED] [1.470 seconds] backup and restore end to end tests Flag combinations Edge case tests [It] Restores views that depend on a constraint by printing a dummy view /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/end_to_end/end_to_end_suite_test.go:2036 [FAILED] Expected <string>: SET client_encoding = 'UTF8'; ALTER RESOURCE QUEUE pg_default WITH (ACTIVE_STATEMENTS=20); ALTER RESOURCE GROUP admin_group SET CPU_MAX_PERCENT 1; ALTER RESOURCE GROUP admin_group SET CPU_WEIGHT 100; ALTER RESOURCE GROUP default_group SET CPU_MAX_PERCENT 1; ALTER RESOURCE GROUP default_group SET CPU_WEIGHT 100; ALTER RESOURCE GROUP system_group SET CPU_MAX_PERCENT 1; ALTER RESOURCE GROUP system_group SET CPU_WEIGHT 100; ALTER RESOURCE GROUP default_group SET CPU_WEIGHT 100; ALTER RESOURCE GROUP default_group SET CONCURRENCY 20; ALTER RESOURCE GROUP default_group SET CPU_MAX_PERCENT 20; ALTER RESOURCE GROUP admin_group SET CPU_WEIGHT 100; ALTER RESOURCE GROUP admin_group SET CONCURRENCY 10; ALTER RESOURCE GROUP admin_group SET CPU_MAX_PERCENT 10; ALTER RESOURCE GROUP system_group SET CPU_WEIGHT 100; ALTER RESOURCE GROUP system_group SET CONCURRENCY 0; ALTER RESOURCE GROUP system_group SET CPU_MAX_PERCENT 10; CREATE ROLE gpadmin; ALTER ROLE gpadmin WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION PASSWORD 'SCRAM-SHA-256$4096:ToQ4Ykhinvku/wRqro8cUg==$2c1yPVYcOcVnIMlHu3t6HG5cEt8lAe0OMjPAdguHA4s=:cDunE6tX2ATmUb+5WhdIJlr6Jg1Oer/MXq+7YDcb93g=' RESOURCE QUEUE pg_default RESOURCE GROUP admin_group; CREATE DATABASE testdb TEMPLATE template0; ALTER DATABASE testdb OWNER TO gpadmin; COMMENT ON SCHEMA public IS 'standard public schema'; ALTER SCHEMA public OWNER TO pg_database_owner; REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM pg_database_owner; GRANT ALL ON SCHEMA public TO PUBLIC; GRANT ALL ON SCHEMA public TO pg_database_owner; CREATE SCHEMA schema2; ALTER SCHEMA schema2 OWNER TO gpadmin; CREATE SCHEMA IF NOT EXISTS gp_toolkit; SET search_path=gp_toolkit,pg_catalog; CREATE EXTENSION IF NOT EXISTS gp_toolkit WITH SCHEMA gp_toolkit; SET search_path=pg_catalog; COMMENT ON EXTENSION gp_toolkit IS 'various GPDB administrative views/functions'; CREATE SEQUENCE public.myseq1 START WITH 100 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 20; SELECT pg_catalog.setval('public.myseq1', 100, false); ALTER SEQUENCE public.myseq1 OWNER TO gpadmin; CREATE SEQUENCE public.myseq2 START WITH 100 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 20; SELECT pg_catalog.setval('public.myseq2', 100, false); ALTER SEQUENCE public.myseq2 OWNER TO gpadmin; CREATE TABLE public.foo ( i integer DEFAULT (nextval('public.myseq1'::regclass)) NOT NULL ) DISTRIBUTED BY (i); ALTER TABLE public.foo OWNER TO gpadmin; CREATE TABLE public.holds ( i integer ) DISTRIBUTED BY (i); ALTER TABLE public.holds OWNER TO gpadmin; CREATE TABLE public.sales ( id integer, date date, amt numeric(10,2) ) PARTITION BY RANGE (date) DISTRIBUTED BY (id); ALTER TABLE public.sales OWNER TO gpadmin; CREATE TABLE schema2.foo2 ( i integer ) DISTRIBUTED BY (i); ALTER TABLE schema2.foo2 OWNER TO gpadmin; CREATE TABLE schema2.foo3 ( i integer ) DISTRIBUTED BY (i); ALTER TABLE schema2.foo3 OWNER TO gpadmin; CREATE TABLE schema2.returns ( id integer, date date, amt numeric(10,2) ) PARTITION BY RANGE (date) DISTRIBUTED BY (id); ALTER TABLE schema2.returns OWNER TO gpadmin; CREATE TABLE schema2.ao1 ( i integer ) USING ao_row DISTRIBUTED BY (i); ALTER TABLE schema2.ao1 OWNER TO gpadmin; CREATE TABLE schema2.ao2 ( i integer ENCODING (compresstype=none,compresslevel=0,blocksize=32768) ) USING ao_column DISTRIBUTED BY (i); ALTER TABLE schema2.ao2 OWNER TO gpadmin; CREATE TABLE public."FOObar" ( i integer ) DISTRIBUTED BY (i); ALTER TABLE public."FOObar" OWNER TO gpadmin; CREATE TABLE public.view_base_table ( key integer NOT NULL, data character varying(20) ) DISTRIBUTED BY (key); ALTER TABLE public.view_base_table OWNER TO gpadmin; CREATE VIEW public.myview2 AS SELECT '1'::text AS "?column?"; ALTER VIEW public.myview2 OWNER TO gpadmin; CREATE VIEW public.myview1 AS SELECT i FROM public.foo; ALTER VIEW public.myview1 OWNER TO gpadmin; CREATE TABLE public.sales_1_prt_jan17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_jan17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_jan17 FOR VALUES FROM ('2017-01-01') TO ('2017-02-01'); CREATE TABLE public.sales_1_prt_feb17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_feb17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_feb17 FOR VALUES FROM ('2017-02-01') TO ('2017-03-01'); CREATE TABLE public.sales_1_prt_mar17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_mar17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_mar17 FOR VALUES FROM ('2017-03-01') TO ('2017-04-01'); CREATE TABLE public.sales_1_prt_apr17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_apr17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_apr17 FOR VALUES FROM ('2017-04-01') TO ('2017-05-01'); CREATE TABLE public.sales_1_prt_may17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_may17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_may17 FOR VALUES FROM ('2017-05-01') TO ('2017-06-01'); CREATE TABLE public.sales_1_prt_jun17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_jun17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_jun17 FOR VALUES FROM ('2017-06-01') TO ('2017-07-01'); CREATE TABLE public.sales_1_prt_jul17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_jul17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_jul17 FOR VALUES FROM ('2017-07-01') TO ('2017-08-01'); CREATE TABLE public.sales_1_prt_aug17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_aug17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_aug17 FOR VALUES FROM ('2017-08-01') TO ('2017-09-01'); CREATE TABLE public.sales_1_prt_sep17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_sep17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_sep17 FOR VALUES FROM ('2017-09-01') TO ('2017-10-01'); CREATE TABLE public.sales_1_prt_oct17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_oct17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_oct17 FOR VALUES FROM ('2017-10-01') TO ('2017-11-01'); CREATE TABLE public.sales_1_prt_nov17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_nov17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_nov17 FOR VALUES FROM ('2017-11-01') TO ('2017-12-01'); CREATE TABLE public.sales_1_prt_dec17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE public.sales_1_prt_dec17 OWNER TO gpadmin; ALTER TABLE ONLY public.sales ATTACH PARTITION public.sales_1_prt_dec17 FOR VALUES FROM ('2017-12-01') TO ('2018-01-01'); CREATE TABLE schema2.returns_1_prt_jan17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_jan17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_jan17 FOR VALUES FROM ('2017-01-01') TO ('2017-02-01'); CREATE TABLE schema2.returns_1_prt_feb17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_feb17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_feb17 FOR VALUES FROM ('2017-02-01') TO ('2017-03-01'); CREATE TABLE schema2.returns_1_prt_mar17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_mar17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_mar17 FOR VALUES FROM ('2017-03-01') TO ('2017-04-01'); CREATE TABLE schema2.returns_1_prt_apr17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_apr17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_apr17 FOR VALUES FROM ('2017-04-01') TO ('2017-05-01'); CREATE TABLE schema2.returns_1_prt_may17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_may17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_may17 FOR VALUES FROM ('2017-05-01') TO ('2017-06-01'); CREATE TABLE schema2.returns_1_prt_jun17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_jun17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_jun17 FOR VALUES FROM ('2017-06-01') TO ('2017-07-01'); CREATE TABLE schema2.returns_1_prt_jul17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_jul17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_jul17 FOR VALUES FROM ('2017-07-01') TO ('2017-08-01'); CREATE TABLE schema2.returns_1_prt_aug17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_aug17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_aug17 FOR VALUES FROM ('2017-08-01') TO ('2017-09-01'); CREATE TABLE schema2.returns_1_prt_sep17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_sep17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_sep17 FOR VALUES FROM ('2017-09-01') TO ('2017-10-01'); CREATE TABLE schema2.returns_1_prt_oct17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_oct17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_oct17 FOR VALUES FROM ('2017-10-01') TO ('2017-11-01'); CREATE TABLE schema2.returns_1_prt_nov17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_nov17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_nov17 FOR VALUES FROM ('2017-11-01') TO ('2017-12-01'); CREATE TABLE schema2.returns_1_prt_dec17 ( id integer, date date, amt numeric(10,2) ) DISTRIBUTED BY (id); ALTER TABLE schema2.returns_1_prt_dec17 OWNER TO gpadmin; ALTER TABLE ONLY schema2.returns ATTACH PARTITION schema2.returns_1_prt_dec17 FOR VALUES FROM ('2017-12-01') TO ('2018-01-01'); CREATE VIEW public.key_dependent_view AS SELECT NULL::integer AS key, NULL::character varying(20) COLLATE pg_catalog."C" AS data; ALTER VIEW public.key_dependent_view OWNER TO gpadmin; CREATE VIEW public.key_dependent_view_no_cols AS SELECT; ALTER VIEW public.key_dependent_view_no_cols OWNER TO gpadmin; ALTER TABLE ONLY public.view_base_table ADD CONSTRAINT view_base_table_pkey PRIMARY KEY (key); CREATE OR REPLACE VIEW public.key_dependent_view AS SELECT key, (data COLLATE "C") AS data FROM public.view_base_table GROUP BY key; CREATE OR REPLACE VIEW public.key_dependent_view_no_cols AS SELECT FROM public.view_base_table GROUP BY key HAVING (length((data)::text) > 0); to contain substring <string>: CREATE OR REPLACE VIEW public.key_dependent_view AS SELECT view_base_table.key, (view_base_table.data COLLATE "C") AS data FROM public.view_base_table GROUP BY view_base_table.key; In [It] at: /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/end_to_end/end_to_end_suite_test.go:2053 @ 06/11/26 00:46:13.27 ------------------------------ •••••••••••••••••••••••••••S•••••••S••••••••••••••••••••S••••••••••••••••••••••••••••••••S•••••••••••••••••••••••••••S••••••••••••••••••••S•••S•••••S•••••••••••••••••••••S••••••••••S Summarizing 1 Failure: [FAIL] backup and restore end to end tests Flag combinations Edge case tests [It] Restores views that depend on a constraint by printing a dummy view /__w/cloudberry-backup/cloudberry-backup/cloudberry-backup/end_to_end/end_to_end_suite_test.go:2053 Ran 209 of 222 Specs in 1234.258 seconds FAIL! -- 208 Passed | 1 Failed | 0 Pending | 13 Skipped --- FAIL: TestEndToEnd (1234.26s) FAIL Ginkgo ran 1 suite in 20m41.565070149s Test Suite Failed make: *** [Makefile:87: end_to_end] Error 1 ``` -- 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]
