This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 e6080a6e4c [regression](join) add right anti join with other predicate
regression case (#13815)
e6080a6e4c is described below
commit e6080a6e4caf82b9ab569aa540ce97b6ed7ad737
Author: luozenglin <37725793+luozeng...@users.noreply.github.com>
AuthorDate: Wed Nov 2 13:27:58 2022 +0800
[regression](join) add right anti join with other predicate regression case
(#13815)
---
regression-test/data/query/join/test_join.out | 5 +++++
regression-test/suites/query/join/test_join.groovy | 1 +
2 files changed, 6 insertions(+)
diff --git a/regression-test/data/query/join/test_join.out
b/regression-test/data/query/join/test_join.out
index 5be8b7529f..c19bf29042 100644
--- a/regression-test/data/query/join/test_join.out
+++ b/regression-test/data/query/join/test_join.out
@@ -1234,6 +1234,11 @@ false 3 1989 1002 11011905
24453.325 false 2012-03-14 2000-01-01T00:00 yunlj8@nk
14
15
+-- !right_anti_join_with_other_pred --
+1
+2
+3
+
-- !join_without_keyword1 --
1 1 1989 1989 1001 1001
2 2 1986 1986 1001 1001
diff --git a/regression-test/suites/query/join/test_join.groovy
b/regression-test/suites/query/join/test_join.groovy
index 292f4f2de3..c51d65826f 100644
--- a/regression-test/suites/query/join/test_join.groovy
+++ b/regression-test/suites/query/join/test_join.groovy
@@ -1166,6 +1166,7 @@ suite("test_join", "query,p0") {
order by 1, 2, 3, 4, 5 limit 65535"""
}
+ qt_right_anti_join_with_other_pred "select t.k1 from ${tbName2} b right
anti join ${tbName1} t on b.k1 = t.k1 and 1 = 2 order by t.k1"
// join with no join keyword
for (s in selected){
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
