This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new f7b6ed772be [Fix-2.1](testcase) Fix some testcases unstable results
due to lack of orderby (#39892)
f7b6ed772be is described below
commit f7b6ed772bebb131dff3b29f2fa40a520f8754d5
Author: zclllhhjj <zhaochan...@selectdb.com>
AuthorDate: Sun Aug 25 08:45:36 2024 +0800
[Fix-2.1](testcase) Fix some testcases unstable results due to lack of
orderby (#39892)
## Proposed changes
Issue Number: close #xxx
some sql's order-by column has same value, add more order-by column to
fix it.
---
.../datetime_functions/test_date_function.out | 22 +++++++++++-----------
.../datetime_functions/test_date_function.groovy | 6 +++---
2 files changed, 14 insertions(+), 14 deletions(-)
diff --git
a/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
b/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
index 33f2148950e..6fba462aff3 100644
---
a/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
+++
b/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
@@ -700,34 +700,34 @@ true
-- !sql_varchar1 --
0000-00-00 %Y-%m-%d \N
-9999-12-31 23:59:59.999999 %Y-%m-%d %H:%i:%s.%f 0.000000
-9999-12-31 23:59:59.9999999 %Y-%m-%d %H:%i:%s.%f 0.000000
0000-01-01 %Y-%m-%d 0.000000
9999-12-31 23:59:59 %Y-%m-%d %H:%i:%s 0.000000
+9999-12-31 23:59:59.999999 %Y-%m-%d %H:%i:%s.%f 0.000000
+9999-12-31 23:59:59.9999999 %Y-%m-%d %H:%i:%s.%f 0.000000
1999-12-31 23:59:59.9999999 %Y-%m-%d %H:%i:%s.%f 946655999.999999
20201111 %Y%m%d 1605024000.000000
2020-12-12 %Y-%m-%d 1607702400.000000
202012-13 %Y%m-%d 1607788800.000000
--- !sql_varchar1 --
-20201111 \N
+-- !sql_varchar2 --
0000-00-00 \N
+20201111 \N
202012-13 \N
0000-01-01 0.000000
-9999-12-31 23:59:59.9999999 0.000000
-9999-12-31 23:59:59.999999 0.000000
9999-12-31 23:59:59 0.000000
+9999-12-31 23:59:59.999999 0.000000
+9999-12-31 23:59:59.9999999 0.000000
1999-12-31 23:59:59.9999999 946569600.000000
2020-12-12 1607702400.000000
--- !sql_varchar1 --
-%Y%m-%d \N
+-- !sql_varchar3 --
%Y%m%d \N
+%Y%m-%d \N
%Y-%m-%d 660931200.000000
-%Y-%m-%d %H:%i:%s.%f 660931200.000000
-%Y-%m-%d %H:%i:%s.%f 660931200.000000
%Y-%m-%d 660931200.000000
%Y-%m-%d 660931200.000000
-%Y-%m-%d %H:%i:%s.%f 660931200.000000
%Y-%m-%d %H:%i:%s 660931200.000000
+%Y-%m-%d %H:%i:%s.%f 660931200.000000
+%Y-%m-%d %H:%i:%s.%f 660931200.000000
+%Y-%m-%d %H:%i:%s.%f 660931200.000000
diff --git
a/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
b/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
index b189bec5a66..b7504611bdb 100644
---
a/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
+++
b/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
@@ -815,7 +815,7 @@ suite("test_date_function") {
("0000-00-00", "%Y-%m-%d"),("0000-01-01", "%Y-%m-%d"),("9999-12-31
23:59:59", "%Y-%m-%d %H:%i:%s"),
("9999-12-31 23:59:59.999999", "%Y-%m-%d %H:%i:%s.%f"), ("9999-12-31
23:59:59.9999999", "%Y-%m-%d %H:%i:%s.%f"),
("1999-12-31 23:59:59.9999999", "%Y-%m-%d %H:%i:%s.%f"); """
- qt_sql_varchar1 """ select dt, fmt, unix_timestamp(dt, fmt) as k1 from
date_varchar order by k1; """
- qt_sql_varchar1 """ select dt, unix_timestamp(dt, "%Y-%m-%d") as k1 from
date_varchar order by k1; """
- qt_sql_varchar1 """ select fmt, unix_timestamp("1990-12-12", fmt) as k1
from date_varchar order by k1; """
+ qt_sql_varchar1 """ select dt, fmt, unix_timestamp(dt, fmt) as k1 from
date_varchar order by k1, dt, fmt; """
+ qt_sql_varchar2 """ select dt, unix_timestamp(dt, "%Y-%m-%d") as k1 from
date_varchar order by k1, dt; """
+ qt_sql_varchar3 """ select fmt, unix_timestamp("1990-12-12", fmt) as k1
from date_varchar order by k1, fmt; """
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
