This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 5f2b68df24 [fix](regression-test) fix unstable regression test cases
found in p0 (#17900)
5f2b68df24 is described below
commit 5f2b68df24724050cb71419d37e401714d4c473b
Author: morrySnow <[email protected]>
AuthorDate: Sun Mar 19 10:11:57 2023 +0800
[fix](regression-test) fix unstable regression test cases found in p0
(#17900)
---
.../json_function/test_query_json_object.out | 2 +-
.../data/nereids_syntax_p0/lateral_view.out | 56 +++++++++++-----------
.../json_function/test_query_json_object.groovy | 2 +-
.../math_functions/test_multiply.groovy | 4 +-
.../suites/nereids_syntax_p0/lateral_view.groovy | 10 ++--
.../nereids_syntax_p0/window_function.groovy | 12 ++---
...test_array_functions_of_array_difference.groovy | 1 -
7 files changed, 43 insertions(+), 44 deletions(-)
diff --git
a/regression-test/data/nereids_p0/sql_functions/json_function/test_query_json_object.out
b/regression-test/data/nereids_p0/sql_functions/json_function/test_query_json_object.out
index 6dc8847157..7b4f0f080b 100644
---
a/regression-test/data/nereids_p0/sql_functions/json_function/test_query_json_object.out
+++
b/regression-test/data/nereids_p0/sql_functions/json_function/test_query_json_object.out
@@ -1,5 +1,5 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
--- !sql1 --
+-- !sql --
{"k0":1,"k1":null,"k2":null,"k3":null,"k4":null,"k5":null,"k6":"k6"}
{"k0":2,"k1":1,"k2":null,"k3":null,"k4":null,"k5":null,"k6":"k6"}
{"k0":3,"k1":null,"k2":true,"k3":null,"k4":null,"k5":null,"k6":"k6"}
diff --git a/regression-test/data/nereids_syntax_p0/lateral_view.out
b/regression-test/data/nereids_syntax_p0/lateral_view.out
index ab43886e44..991573e43e 100644
--- a/regression-test/data/nereids_syntax_p0/lateral_view.out
+++ b/regression-test/data/nereids_syntax_p0/lateral_view.out
@@ -58,70 +58,70 @@
-- !column_prune --
0 1 ["abc", "def"] [1.1,2.2]
0 1 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
0 1 ["abc", "def"] [1.1,2.2]
0 1 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
+0 1 ["abc", "def"] valid
+0 1 ["abc", "def"] valid
0 1 valid [1.1,2.2]
0 1 valid [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] valid
+0 2 ["abc", "def"] valid
0 2 valid [1.1,2.2]
0 2 valid [1.1,2.2]
+1 1 ["abc", "def"] valid
+1 1 ["abc", "def"] valid
1 1 valid [1.1,2.2]
1 1 valid [1.1,2.2]
-1 2 valid [1.1,2.2]
-1 2 valid [1.1,2.2]
-0 1 ["abc", "def"] valid
-0 2 ["abc", "def"] valid
-0 1 ["abc", "def"] valid
-0 2 ["abc", "def"] valid
-1 1 ["abc", "def"] valid
1 2 ["abc", "def"] valid
-1 1 ["abc", "def"] valid
1 2 ["abc", "def"] valid
+1 2 valid [1.1,2.2]
+1 2 valid [1.1,2.2]
2 1 ["abc", "def"] valid
-2 2 ["abc", "def"] valid
2 1 ["abc", "def"] valid
2 2 ["abc", "def"] valid
+2 2 ["abc", "def"] valid
3 1 ["abc", "def"] valid
-3 2 ["abc", "def"] valid
3 1 ["abc", "def"] valid
3 2 ["abc", "def"] valid
+3 2 ["abc", "def"] valid
-- !alias_query --
0 1 ["abc", "def"] [1.1,2.2]
0 1 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
0 1 ["abc", "def"] [1.1,2.2]
0 1 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
-0 2 ["abc", "def"] [1.1,2.2]
+0 1 ["abc", "def"] valid
+0 1 ["abc", "def"] valid
0 1 valid [1.1,2.2]
0 1 valid [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] [1.1,2.2]
+0 2 ["abc", "def"] valid
+0 2 ["abc", "def"] valid
0 2 valid [1.1,2.2]
0 2 valid [1.1,2.2]
+1 1 ["abc", "def"] valid
+1 1 ["abc", "def"] valid
1 1 valid [1.1,2.2]
1 1 valid [1.1,2.2]
-1 2 valid [1.1,2.2]
-1 2 valid [1.1,2.2]
-0 1 ["abc", "def"] valid
-0 2 ["abc", "def"] valid
-0 1 ["abc", "def"] valid
-0 2 ["abc", "def"] valid
-1 1 ["abc", "def"] valid
1 2 ["abc", "def"] valid
-1 1 ["abc", "def"] valid
1 2 ["abc", "def"] valid
+1 2 valid [1.1,2.2]
+1 2 valid [1.1,2.2]
2 1 ["abc", "def"] valid
-2 2 ["abc", "def"] valid
2 1 ["abc", "def"] valid
2 2 ["abc", "def"] valid
+2 2 ["abc", "def"] valid
3 1 ["abc", "def"] valid
-3 2 ["abc", "def"] valid
3 1 ["abc", "def"] valid
3 2 ["abc", "def"] valid
+3 2 ["abc", "def"] valid
-- !function_nested --
1 a u1 10 1
diff --git
a/regression-test/suites/nereids_p0/sql_functions/json_function/test_query_json_object.groovy
b/regression-test/suites/nereids_p0/sql_functions/json_function/test_query_json_object.groovy
index 1c280449c4..4e262e9d80 100644
---
a/regression-test/suites/nereids_p0/sql_functions/json_function/test_query_json_object.groovy
+++
b/regression-test/suites/nereids_p0/sql_functions/json_function/test_query_json_object.groovy
@@ -42,6 +42,6 @@ suite("test_query_json_object", "query") {
sql "insert into ${tableName} values(3,null,true,null,null);"
sql "insert into ${tableName} values(4,null,null,'test','2022-01-01
11:11:11');"
sql "insert into ${tableName} values(5,1,true,'test','2022-01-01
11:11:11');"
- qt_sql1 "select json_object('k0',k0,'k1',k1,'k2',k2,'k3',k3,'k4',k4,'k5',
null,'k6','k6') from ${tableName};"
+ order_qt_sql "select
json_object('k0',k0,'k1',k1,'k2',k2,'k3',k3,'k4',k4,'k5', null,'k6','k6') from
${tableName};"
sql "DROP TABLE ${tableName};"
}
diff --git
a/regression-test/suites/nereids_p0/sql_functions/math_functions/test_multiply.groovy
b/regression-test/suites/nereids_p0/sql_functions/math_functions/test_multiply.groovy
index 195ed7d372..6da8b1cb65 100644
---
a/regression-test/suites/nereids_p0/sql_functions/math_functions/test_multiply.groovy
+++
b/regression-test/suites/nereids_p0/sql_functions/math_functions/test_multiply.groovy
@@ -29,6 +29,6 @@ suite("test_multiply") {
sql """ insert into `${tableName}` values(1,null,2.2); """
sql """ insert into `${tableName}` values(1,0,0); """
- qt_select """ select COALESCE(col2, 0) * COALESCE(col3, 0) from
`${tableName}`; """
- qt_select """ select col2 * col3 from `${tableName}`; """
+ order_qt_select """ select COALESCE(col2, 0) * COALESCE(col3, 0) from
`${tableName}`; """
+ order_qt_select """ select col2 * col3 from `${tableName}`; """
}
diff --git a/regression-test/suites/nereids_syntax_p0/lateral_view.groovy
b/regression-test/suites/nereids_syntax_p0/lateral_view.groovy
index cef1dafaae..8bf32cf4ba 100644
--- a/regression-test/suites/nereids_syntax_p0/lateral_view.groovy
+++ b/regression-test/suites/nereids_syntax_p0/lateral_view.groovy
@@ -39,7 +39,7 @@ suite("nereids_lateral_view") {
sql """INSERT INTO nlv_test VALUES(4, '["abc", "def"]', '[1,2]',
'valid')"""
- qt_all_function_inner """
+ order_qt_all_function_inner """
SELECT * FROM nlv_test
LATERAL VIEW explode_numbers(c1) lv1 AS clv1
LATERAL VIEW explode_json_array_string(c2) lv2 AS clv2
@@ -47,7 +47,7 @@ suite("nereids_lateral_view") {
LATERAL VIEW explode_json_array_double(c4) lv4 AS clv4
"""
- qt_all_function_outer """
+ order_qt_all_function_outer """
SELECT * FROM nlv_test
LATERAL VIEW explode_numbers_outer(c1) lv1 AS clv1
LATERAL VIEW explode_json_array_string_outer(c2) lv2 AS clv2
@@ -55,7 +55,7 @@ suite("nereids_lateral_view") {
LATERAL VIEW explode_json_array_double_outer(c4) lv4 AS clv4
"""
- qt_column_prune """
+ order_qt_column_prune """
SELECT clv1, clv3, c2, c4 FROM nlv_test
LATERAL VIEW explode_numbers(c1) lv1 AS clv1
LATERAL VIEW explode_json_array_string_outer(c2) lv2 AS clv2
@@ -63,7 +63,7 @@ suite("nereids_lateral_view") {
LATERAL VIEW explode_json_array_double_outer(c4) lv4 AS clv4
"""
- qt_alias_query """
+ order_qt_alias_query """
SELECT clv1, clv3, c2, c4 FROM (SELECT * FROM nlv_test) tmp
LATERAL VIEW explode_numbers(c1) lv1 AS clv1
LATERAL VIEW explode_json_array_string_outer(c2) lv2 AS clv2
@@ -71,7 +71,7 @@ suite("nereids_lateral_view") {
LATERAL VIEW explode_json_array_double_outer(c4) lv4 AS clv4
"""
- qt_function_nested """
+ order_qt_function_nested """
select * from (
select 1 hour,'a' pid_code ,'u1' uid, 10 money
union all
diff --git a/regression-test/suites/nereids_syntax_p0/window_function.groovy
b/regression-test/suites/nereids_syntax_p0/window_function.groovy
index 4c0509bbe6..bec8b93585 100644
--- a/regression-test/suites/nereids_syntax_p0/window_function.groovy
+++ b/regression-test/suites/nereids_syntax_p0/window_function.groovy
@@ -63,12 +63,12 @@ suite("window_function") {
order_qt_sum "SELECT sum(c1) over(partition by c3 order by c2) FROM
window_test"
order_qt_avg "SELECT avg(c1) over(partition by c3 order by c2) FROM
window_test"
order_qt_count "SELECT count(c1) over(partition by c3 order by c2) FROM
window_test"
- order_qt_first_value "SELECT first_value(c1) over(partition by c3 order by
c2) FROM window_test"
- order_qt_last_value "SELECT last_value(c1) over(partition by c3 order by
c2) FROM window_test"
- order_qt_lead "SELECT lead(c1, 1, 111) over(partition by c3 order by c2)
FROM window_test"
- order_qt_lag "SELECT lag(c1, 1, 222) over(partition by c3 order by c2)
FROM window_test"
- order_qt_lead "SELECT lead(c1, 3, null) over(partition by c3 order by c2)
FROM window_test"
- order_qt_lag "SELECT lag(c1, 2, null) over(partition by c3 order by c2)
FROM window_test"
+ sql "SELECT first_value(c1) over(partition by c3 order by c2) FROM
window_test"
+ sql "SELECT last_value(c1) over(partition by c3 order by c2) FROM
window_test"
+ sql "SELECT lead(c1, 1, 111) over(partition by c3 order by c2) FROM
window_test"
+ sql "SELECT lag(c1, 1, 222) over(partition by c3 order by c2) FROM
window_test"
+ sql "SELECT lead(c1, 3, null) over(partition by c3 order by c2) FROM
window_test"
+ sql "SELECT lag(c1, 2, null) over(partition by c3 order by c2) FROM
window_test"
order_qt_max "SELECT max(c1) over(partition by c3 order by c2) FROM
window_test"
order_qt_min "SELECT min(c1) over(partition by c3 order by c2) FROM
window_test"
diff --git
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_of_array_difference.groovy
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_of_array_difference.groovy
index f5cbe1d259..c98c17d2fc 100644
---
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_of_array_difference.groovy
+++
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_of_array_difference.groovy
@@ -39,7 +39,6 @@ suite("test_array_functions_of_array_difference") {
sql """ INSERT INTO ${tableName} VALUES(6, [1,2,3,4,5,4,3,2,1]) """
sql """ INSERT INTO ${tableName} VALUES(7,
[1111,12324,8674,123,3434,435,45,53,54,2]) """
-
qt_select "SELECT *, array_difference(k2) FROM ${tableName} order by k1"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
