You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by av...@apache.org on 2024/12/30 08:26:11 UTC
(cloudberry) 08/10: Disable flaky qp_union_intersect test
This is an automated email from the ASF dual-hosted git repository.
avamingli pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit c53d3db6dcf615bc069cb3e31cc2b6ebdcfb6118
Author: David Kimura <dk...@vmware.com>
AuthorDate: Mon Oct 3 16:37:23 2022 +0000
Disable flaky qp_union_intersect test
This commit amends commit d63731d. Fallback needs to happen inside the
rollback'd transaction as that is where the stale cache entry is not
cleaned up properly.
---
src/test/regress/expected/qp_union_intersect.out | 6 +++---
src/test/regress/expected/qp_union_intersect_optimizer.out | 6 +++---
src/test/regress/sql/qp_union_intersect.sql | 6 +++---
3 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/src/test/regress/expected/qp_union_intersect.out b/src/test/regress/expected/qp_union_intersect.out
index 6df9198e22..ccc10eeca0 100644
--- a/src/test/regress/expected/qp_union_intersect.out
+++ b/src/test/regress/expected/qp_union_intersect.out
@@ -1687,6 +1687,8 @@ rollback;
-- @description union_update_test28: Negative Tests Update the partition key to an out of dml_union_range value with no default partition
begin;
DROP TABLE dml_union_s_1_prt_def;
+-- GPDB_12_MERGE_FIXME: This test case is flaky, ERROR: expected partdefid 134733, but got 0 (partdesc.c:194)
+set optimizer=off;
SELECT COUNT(DISTINCT(d)) FROM dml_union_s;
count
-------
@@ -1699,9 +1701,8 @@ DETAIL: Partition key of the failing row contains (d) = (null).
--SELECT DISTINCT(d) FROM dml_union_s;
--SELECT COUNT(DISTINCT(d)) FROM dml_union_s;
rollback;
+reset optimizer;
-- @description union_update_test29: Negative Tests UPDATE violates the CHECK constraint on the column
--- GPDB_12_MERGE_FIXME: This test case is flaky, ERROR: expected partdefid 134733, but got 0 (partdesc.c:194)
-set optimizer=off;
SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
count
-------
@@ -1711,7 +1712,6 @@ SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
UPDATE dml_union_s SET b = (SELECT NULL UNION SELECT NULL)::numeric;
ERROR: null value in column "b" of relation "dml_union_s_1_prt_2" violates not-null constraint (seg0 127.0.1.1:7002 pid=773223)
DETAIL: Failing row contains (5, null, s, 5).
-reset optimizer;
--SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
--SELECT DISTINCT(b) FROM dml_union_s;
-- @description union_update_test30: Negative Tests more than one row returned by a sub-query used as an expression
diff --git a/src/test/regress/expected/qp_union_intersect_optimizer.out b/src/test/regress/expected/qp_union_intersect_optimizer.out
index 5546ac45f2..ed630f2680 100644
--- a/src/test/regress/expected/qp_union_intersect_optimizer.out
+++ b/src/test/regress/expected/qp_union_intersect_optimizer.out
@@ -1688,6 +1688,8 @@ rollback;
-- @description union_update_test28: Negative Tests Update the partition key to an out of dml_union_range value with no default partition
begin;
DROP TABLE dml_union_s_1_prt_def;
+-- GPDB_12_MERGE_FIXME: This test case is flaky, ERROR: expected partdefid 134733, but got 0 (partdesc.c:194)
+set optimizer=off;
SELECT COUNT(DISTINCT(d)) FROM dml_union_s;
count
-------
@@ -1700,9 +1702,8 @@ DETAIL: Partition key of the failing row contains (d) = (null).
--SELECT DISTINCT(d) FROM dml_union_s;
--SELECT COUNT(DISTINCT(d)) FROM dml_union_s;
rollback;
+reset optimizer;
-- @description union_update_test29: Negative Tests UPDATE violates the CHECK constraint on the column
--- GPDB_12_MERGE_FIXME: This test case is flaky, ERROR: expected partdefid 134733, but got 0 (partdesc.c:194)
-set optimizer=off;
SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
count
-------
@@ -1712,7 +1713,6 @@ SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
UPDATE dml_union_s SET b = (SELECT NULL UNION SELECT NULL)::numeric;
ERROR: null value in column "b" violates not-null constraint (seg0 127.0.0.1:7002 pid=31287)
DETAIL: Failing row contains (1, null, s, 1).
-reset optimizer;
--SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
--SELECT DISTINCT(b) FROM dml_union_s;
-- @description union_update_test30: Negative Tests more than one row returned by a sub-query used as an expression
diff --git a/src/test/regress/sql/qp_union_intersect.sql b/src/test/regress/sql/qp_union_intersect.sql
index f05ec6b705..a51759d1ba 100644
--- a/src/test/regress/sql/qp_union_intersect.sql
+++ b/src/test/regress/sql/qp_union_intersect.sql
@@ -619,18 +619,18 @@ rollback;
-- @description union_update_test28: Negative Tests Update the partition key to an out of dml_union_range value with no default partition
begin;
DROP TABLE dml_union_s_1_prt_def;
+-- GPDB_12_MERGE_FIXME: This test case is flaky, ERROR: expected partdefid 134733, but got 0 (partdesc.c:194)
+set optimizer=off;
SELECT COUNT(DISTINCT(d)) FROM dml_union_s;
UPDATE dml_union_s SET d = (SELECT NULL EXCEPT SELECT NULL)::numeric;
--SELECT DISTINCT(d) FROM dml_union_s;
--SELECT COUNT(DISTINCT(d)) FROM dml_union_s;
rollback;
+reset optimizer;
-- @description union_update_test29: Negative Tests UPDATE violates the CHECK constraint on the column
--- GPDB_12_MERGE_FIXME: This test case is flaky, ERROR: expected partdefid 134733, but got 0 (partdesc.c:194)
-set optimizer=off;
SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
UPDATE dml_union_s SET b = (SELECT NULL UNION SELECT NULL)::numeric;
-reset optimizer;
--SELECT COUNT(DISTINCT(b)) FROM dml_union_s;
--SELECT DISTINCT(b) FROM dml_union_s;
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org