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 ae56ae677d687751c0d93439ffd65bc309bae42a Author: Chris Hajas <[email protected]> AuthorDate: Fri Sep 30 11:13:58 2022 -0700 Disable flaky qp_union_intersect test This test case has been flaky for a while, and while it's being worked on and discussed, it currently makes developers either ignore red tests or blocks other work from going in. For now, add a FIXME and disable the test case for Orca. Discussion: https://groups.google.com/a/greenplum.org/g/gpdb-dev/c/u3-D7isdvmM --- src/test/regress/expected/qp_union_intersect.out | 3 +++ src/test/regress/expected/qp_union_intersect_optimizer.out | 7 +++++-- src/test/regress/sql/qp_union_intersect.sql | 3 +++ 3 files changed, 11 insertions(+), 2 deletions(-) diff --git a/src/test/regress/expected/qp_union_intersect.out b/src/test/regress/expected/qp_union_intersect.out index 3faf30c562..6df9198e22 100644 --- a/src/test/regress/expected/qp_union_intersect.out +++ b/src/test/regress/expected/qp_union_intersect.out @@ -1700,6 +1700,8 @@ DETAIL: Partition key of the failing row contains (d) = (null). --SELECT COUNT(DISTINCT(d)) FROM dml_union_s; rollback; -- @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 ------- @@ -1709,6 +1711,7 @@ 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 b04334c4fd..5546ac45f2 100644 --- a/src/test/regress/expected/qp_union_intersect_optimizer.out +++ b/src/test/regress/expected/qp_union_intersect_optimizer.out @@ -1701,6 +1701,8 @@ DETAIL: Partition key of the failing row contains (d) = (null). --SELECT COUNT(DISTINCT(d)) FROM dml_union_s; rollback; -- @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 ------- @@ -1708,8 +1710,9 @@ SELECT COUNT(DISTINCT(b)) FROM dml_union_s; (1 row) 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 -DETAIL: Failing row contains (2, null, s, 2). +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 deaae480ea..f05ec6b705 100644 --- a/src/test/regress/sql/qp_union_intersect.sql +++ b/src/test/regress/sql/qp_union_intersect.sql @@ -626,8 +626,11 @@ UPDATE dml_union_s SET d = (SELECT NULL EXCEPT SELECT NULL)::numeric; rollback; -- @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: [email protected] For additional commands, e-mail: [email protected]
