This is an automated email from the ASF dual-hosted git repository.
gfphoenix78 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/main by this push:
new 82a35a03f5 Cleanup: remove old brand name in files (#1030)
82a35a03f5 is described below
commit 82a35a03f5f485d1c15f712b77823c6505608e49
Author: Dianjin Wang <[email protected]>
AuthorDate: Wed Apr 9 18:01:15 2025 +0800
Cleanup: remove old brand name in files (#1030)
In this PR, delete these lines with old brand `Cloudberry Database` in
some files. This PR is used for cleaning up for better compliance with
ASF rules.
---
src/test/regress/expected/aqumv.out | 16 ----------------
src/test/regress/expected/gp_runtime_filter.out | 6 ------
src/test/regress/expected/gpctas_optimizer.out | 18 ------------------
src/test/regress/expected/select_into.out | 4 ----
4 files changed, 44 deletions(-)
diff --git a/src/test/regress/expected/aqumv.out
b/src/test/regress/expected/aqumv.out
index 83b18147a6..a0977a6535 100644
--- a/src/test/regress/expected/aqumv.out
+++ b/src/test/regress/expected/aqumv.out
@@ -3173,32 +3173,16 @@ abort;
create table par(a int, b int, c int) partition by range(b)
subpartition by range(c) subpartition template (start (1) end (3) every
(1))
(start(1) end(3) every(1));
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
create materialized view mv_par as select count(*) from par;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create materialized view mv_par1 as select count(*) from par_1_prt_1;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create materialized view mv_par1_1 as select count(*) from par_1_prt_1_2_prt_1;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create materialized view mv_par1_2 as select count(*) from par_1_prt_1_2_prt_2;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create materialized view mv_par2 as select count(*) from par_1_prt_2;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create materialized view mv_par2_2 as select count(*) from par_1_prt_2_2_prt_1;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create materialized view mv_par_prune as select count(*) from par where b = 1;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'count' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
set enable_answer_query_using_materialized_views = on;
explain(costs off, verbose)
select count(*) from par;
diff --git a/src/test/regress/expected/gp_runtime_filter.out
b/src/test/regress/expected/gp_runtime_filter.out
index 243476fa98..cc1531a707 100644
--- a/src/test/regress/expected/gp_runtime_filter.out
+++ b/src/test/regress/expected/gp_runtime_filter.out
@@ -391,11 +391,7 @@ NOTICE: table "t1" does not exist, skipping
DROP TABLE IF EXISTS t2;
NOTICE: table "t2" does not exist, skipping
CREATE TABLE t1(c1 int, c2 int);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE t2(c1 int, c2 int);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
INSERT INTO t1 SELECT GENERATE_SERIES(1, 1000), GENERATE_SERIES(1, 1000);
INSERT INTO t2 SELECT * FROM t1;
SET gp_enable_runtime_filter_pushdown TO on;
@@ -426,8 +422,6 @@ DROP TABLE IF EXISTS t2;
NOTICE: table "t2" does not exist, skipping
CREATE TABLE t1(c1 int, c2 int, c3 char(50), c4 char(50), c5 char(50))
DISTRIBUTED REPLICATED;
CREATE TABLE t2(c1 int, c2 int, c3 char(50), c4 char(50), c5 char(50));
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
INSERT INTO t1 VALUES (5,5,5,5,5), (3,3,3,3,3), (4,4,4,4,4);
INSERT INTO t2 VALUES (1,1,1,1,1), (2,2,2,2,2), (3,3,3,3,3), (4,4,4,4,4);
INSERT INTO t1 SELECT * FROM t1;
diff --git a/src/test/regress/expected/gpctas_optimizer.out
b/src/test/regress/expected/gpctas_optimizer.out
index bd62c706aa..b6bb557bfe 100644
--- a/src/test/regress/expected/gpctas_optimizer.out
+++ b/src/test/regress/expected/gpctas_optimizer.out
@@ -256,8 +256,6 @@ select action::text, b from ctas_baz order by 1,2 limit 5;
-- Once upon a time, we had a bug in dispatching the table's OID in this
-- scenario.
create table ctas_input(x int);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'x'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
insert into ctas_input select * from generate_series(1, 10);
CREATE FUNCTION ctas_inputArray() RETURNS INT[] AS $$
DECLARE theArray INT[];
@@ -270,8 +268,6 @@ $$ LANGUAGE plpgsql;
create table ctas_output as select ctas_inputArray()::int[] as x;
INFO: GPORCA failed to produce a plan, falling back to Postgres-based planner
DETAIL: Falling back to Postgres-based planner because GPORCA does not
support the following feature: SIRV functions
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'x' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
INFO: GPORCA failed to produce a plan, falling back to Postgres-based planner
DETAIL: Falling back to Postgres-based planner because GPORCA does not
support the following feature: Non-Scalar Subquery
-- Test CTAS with VALUES.
@@ -331,8 +327,6 @@ $BODY$ LANGUAGE SQL IMMUTABLE
DROP TABLE IF EXISTS unnest_2d_tbl01;
NOTICE: table "unnest_2d_tbl01" does not exist, skipping
CREATE TABLE unnest_2d_tbl01 (id INT, val DOUBLE PRECISION[][]);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'id'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
INSERT INTO unnest_2d_tbl01 VALUES
(1, ARRAY[[1::float8,2],[3::float8,4],[5::float8,6],[7::float8,8]]),
(2, ARRAY[[101::float8,202],[303::float8,404],[505::float8,606]])
@@ -342,13 +336,9 @@ NOTICE: table "unnest_2d_tbl01_out" does not exist,
skipping
-- The following CTAS fails previously, see Github Issue 9365
CREATE TABLE unnest_2d_tbl01_out AS
SELECT id, (array_unnest_2d_to_1d(val)).* FROM unnest_2d_tbl01;
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'id' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
-- Github issue 9790.
-- Previously, CTAS with no data won't handle the 'WITH' clause
CREATE TABLE ctas_base(a int, b int);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a'
as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE ctas_aocs WITH (appendonly=true, orientation=column) AS SELECT *
FROM ctas_base WITH NO DATA;
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy
entry.
SELECT * FROM ctas_aocs;
@@ -406,13 +396,9 @@ create or replace function mv_action_select_issue_11999()
returns bool language
create materialized view sro_mv_issue_11999 as select
mv_action_select_issue_11999() with no data;
INFO: GPORCA failed to produce a plan, falling back to Postgres-based planner
DETAIL: Falling back to Postgres-based planner because GPORCA does not
support the following feature: SIRV functions
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'mv_action_select_issue_11999' as the Cloudberry Database data distribution key
for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
create table t_sro_mv_issue_11999 as select mv_action_select_issue_11999()
with no data;
INFO: GPORCA failed to produce a plan, falling back to Postgres-based planner
DETAIL: Falling back to Postgres-based planner because GPORCA does not
support the following feature: SIRV functions
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'mv_action_select_issue_11999' as the Cloudberry Database data distribution key
for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
select count(*)
from
(
@@ -467,8 +453,6 @@ AS $function$declare cname refcursor = 'result'; begin open
cname for select 1;
SELECT exception_func() INTO TEMPORARY test_tmp1;
INFO: GPORCA failed to produce a plan, falling back to Postgres-based planner
DETAIL: Falling back to Postgres-based planner because GPORCA does not
support the following feature: SIRV functions
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
SELECT * FROM test_tmp1;
exception_func
----------------
@@ -478,8 +462,6 @@ SELECT * FROM test_tmp1;
CREATE TEMPORARY TABLE test_tmp2 AS SELECT exception_func();
INFO: GPORCA failed to produce a plan, falling back to Postgres-based planner
DETAIL: Falling back to Postgres-based planner because GPORCA does not
support the following feature: SIRV functions
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
SELECT * FROM test_tmp2;
exception_func
----------------
diff --git a/src/test/regress/expected/select_into.out
b/src/test/regress/expected/select_into.out
index 03dcf62f7f..ac783d4a3f 100644
--- a/src/test/regress/expected/select_into.out
+++ b/src/test/regress/expected/select_into.out
@@ -214,8 +214,6 @@ LINE 1: INSERT INTO b SELECT 1 INTO f;
-- Empty target list
--
explain (costs off) select into empty_tl from generate_series(0, 10);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
QUERY PLAN
------------------------------------------------
Redistribute Motion 1:3 (slice1; segments: 1)
@@ -224,8 +222,6 @@ HINT: The 'DISTRIBUTED BY' clause determines the
distribution of data. Make sur
(3 rows)
select into empty_tl from generate_series(0, 10);
-NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named
'' as the Cloudberry Database data distribution key for this table.
-HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
select * from empty_tl;
--
(11 rows)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
