This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new a6a378c9ca [fix](regression-test) remove 2 regression cases for
nereids temporarily which blocked the pipeline (#12517)
a6a378c9ca is described below
commit a6a378c9ca5187c85f24b3265274bef7f280afda
Author: Kikyou1997 <[email protected]>
AuthorDate: Fri Sep 9 22:20:35 2022 +0800
[fix](regression-test) remove 2 regression cases for nereids temporarily
which blocked the pipeline (#12517)
removed below cases in regression suite:
nereids_syntax_p0/sub_query_correlated
1. qt_not_exists_unCorrelated
2. qt_not_exist_uncorr
---
.../nereids_syntax_p0/sub_query_correlated.out | 22 ----------------------
.../nereids_syntax_p0/sub_query_correlated.groovy | 8 --------
2 files changed, 30 deletions(-)
diff --git a/regression-test/data/nereids_syntax_p0/sub_query_correlated.out
b/regression-test/data/nereids_syntax_p0/sub_query_correlated.out
index fb748d2daa..a957793a15 100644
--- a/regression-test/data/nereids_syntax_p0/sub_query_correlated.out
+++ b/regression-test/data/nereids_syntax_p0/sub_query_correlated.out
@@ -128,28 +128,6 @@
22 3
24 4
--- !not_exists_unCorrelated --
-1 3
-1 2
-2 5
-2 4
-3 4
-3 3
-20 2
-22 3
-24 4
-
--- !not_exist_uncorr --
-1 3
-1 2
-2 5
-2 4
-3 4
-3 3
-20 2
-22 3
-24 4
-
-- !alias_scalar --
1 3
1 2
diff --git
a/regression-test/suites/nereids_syntax_p0/sub_query_correlated.groovy
b/regression-test/suites/nereids_syntax_p0/sub_query_correlated.groovy
index 5818ffa874..abc28073a2 100644
--- a/regression-test/suites/nereids_syntax_p0/sub_query_correlated.groovy
+++ b/regression-test/suites/nereids_syntax_p0/sub_query_correlated.groovy
@@ -171,14 +171,6 @@ suite ("sub_query_correlated") {
select * from subquery1 where exists (select subquery3.k3 from
subquery3) order by k1
"""
- qt_not_exists_unCorrelated """
- select * from subquery1 where not exists (select subquery3.k3 from
subquery3 where subquery3.v2 = 2) order by k1
- """
-
- qt_not_exist_uncorr """
- select * from subquery1 where not exists (select subquery3.k3 from
subquery3) order by k1
- """
-
//----------with subquery alias----------
qt_alias_scalar """
select * from subquery1
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
