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
commit cf700a62b61178a13e81badaf0e0acd787eb0ee3
Author: zhangstar333 <87313068+zhangstar...@users.noreply.github.com>
AuthorDate: Sat Apr 27 11:18:35 2024 +0800
[test](case) fix unstable case without order by distinct row (#34167)
---
regression-test/suites/nereids_p0/aggregate/agg_window_project.groovy | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git
a/regression-test/suites/nereids_p0/aggregate/agg_window_project.groovy
b/regression-test/suites/nereids_p0/aggregate/agg_window_project.groovy
index 7a3cb3042e5..eed0ec3fd24 100644
--- a/regression-test/suites/nereids_p0/aggregate/agg_window_project.groovy
+++ b/regression-test/suites/nereids_p0/aggregate/agg_window_project.groovy
@@ -97,9 +97,9 @@ suite("agg_window_project") {
sql """sync"""
- order_qt_select4 """select a, c, sum(sum(b)) over(partition by c order by
c rows between unbounded preceding and current row) from test_window_table2
group by a, c having a > 1;"""
+ order_qt_select4 """select a, c, sum(sum(b)) over(partition by c order by
a, c rows between unbounded preceding and current row) from test_window_table2
group by a, c having a > 1;"""
- order_qt_select5 """select a, c, sum(sum(b)) over(partition by c order by
c rows between unbounded preceding and current row) dd from test_window_table2
group by a, c having dd < 4;"""
+ order_qt_select5 """select a, c, sum(sum(b)) over(partition by c order by
a, c rows between unbounded preceding and current row) dd from
test_window_table2 group by a, c having dd < 4;"""
explain {
sql("select a, c, sum(sum(b)) over(partition by c order by c rows
between unbounded preceding and current row) from test_window_table2 group by
a, c having a > 1;")
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
