You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ja...@apache.org on 2022/10/30 10:00:14 UTC
[doris] branch master updated: [BugFix](regression-test) add order by in left/right join test case (#13774)
This is an automated email from the ASF dual-hosted git repository.
jakevin 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 98cc32aa0e [BugFix](regression-test) add order by in left/right join test case (#13774)
98cc32aa0e is described below
commit 98cc32aa0e813932638d53750d4e92be13e36086
Author: Tiewei Fang <43...@users.noreply.github.com>
AuthorDate: Sun Oct 30 18:00:08 2022 +0800
[BugFix](regression-test) add order by in left/right join test case (#13774)
The result of right join is unordered, so we need add order by to guarantee results consistent.
---
.../data/correctness_p0/table_valued_function/test_numbers.out | 6 +++---
.../suites/correctness_p0/table_valued_function/test_numbers.groovy | 4 ++--
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/regression-test/data/correctness_p0/table_valued_function/test_numbers.out b/regression-test/data/correctness_p0/table_valued_function/test_numbers.out
index a426fd3f33..9194eba1e6 100644
--- a/regression-test/data/correctness_p0/table_valued_function/test_numbers.out
+++ b/regression-test/data/correctness_p0/table_valued_function/test_numbers.out
@@ -192,11 +192,11 @@
2 2
3 3
4 4
-\N 7
-\N 9
+\N 5
\N 6
+\N 7
\N 8
-\N 5
+\N 9
-- !where_equal --
1
diff --git a/regression-test/suites/correctness_p0/table_valued_function/test_numbers.groovy b/regression-test/suites/correctness_p0/table_valued_function/test_numbers.groovy
index f27da5f7ba..a70e25e6c3 100644
--- a/regression-test/suites/correctness_p0/table_valued_function/test_numbers.groovy
+++ b/regression-test/suites/correctness_p0/table_valued_function/test_numbers.groovy
@@ -49,12 +49,12 @@
qt_left_join """
select a.number as num1, b.number as num2
from numbers("10") a left join numbers("5") b
- on a.number=b.number;
+ on a.number=b.number order by num1;
"""
qt_right_join """
select a.number as num1, b.number as num2
from numbers("5") a right join numbers("10") b
- on a.number=b.number;
+ on a.number=b.number order by num2;
"""
// Test where and GroupBy
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org