Cloudberry PG16: Integration and end_to_end test failed

[tuhaihe]

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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99
  [FAIL] backup integration tests GetRoleMembers [It] returns a role WITH ADMIN OPTION
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:108
  [FAIL] backup integration tests GetRoleMembers [It] handles dropped granter
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:108
  [FAIL] backup integration tests GetRoleMembers [It] returns a role without ADMIN OPTION
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/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

[woblerr]

It is necessary to think over the process of developing cloudberry backup on different versions of cloudberry.

We are pinning a version of brunch in #104. But in the future, we need to have ci on all supported branches: current stable, current development, etc.

Otherwise, how is cloudberry backup supposed to be tested at the cloudberry main brunch?
If we switch only to cloudberry main (16 pg), how will we test on chdb v2?

Or switch to development in branches linked to chdb versions.

[tuhaihe]

It is necessary to think over the process of developing cloudberry backup on different versions of cloudberry.

We are pinning a version of brunch in #104. But in the future, we need to have ci on all supported branches: current stable, current development, etc.

Good point. We can create a test matrix to support tests running in different Cloudberry branches.