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 0732ccbf0f [fix](regression) rowsDisjointWindows output is not ordered
#13333
0732ccbf0f is described below
commit 0732ccbf0feaa5995a5a826a0171dcd2f3e4f82e
Author: minghong <minghong.z...@163.com>
AuthorDate: Thu Oct 13 09:05:07 2022 +0800
[fix](regression) rowsDisjointWindows output is not ordered #13333
---
.../window_functions/sql/rowsDisjointWindows.out | 34 +++++++++++-----------
.../window_functions/sql/rowsDisjointWindows.sql | 1 +
2 files changed, 18 insertions(+), 17 deletions(-)
diff --git
a/regression-test/data/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.out
b/regression-test/data/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.out
index 72fe94253f..0cf8018a74 100644
---
a/regression-test/data/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.out
+++
b/regression-test/data/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.out
@@ -1,35 +1,35 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !rowsDisjointWindows --
1509 27 14.0 \N 16411.78 70336.2 0.04 0.05
+1985 54 33.0 \N 38684.91 96126.14 0.1 0.04167
+8673 54 49.0 33.0 57441.23 91437.06 0.02 0.044
+10727 73 17.0 \N 19928.59 62130.31 0.02 0.07
12901 27 46.0 14.0 53924.42 92609.33 0.04 0.04714
14918 27 33.0 60.0 38684.91 66819.39 0.04 0.04
+17092 54 29.0 82.0 33995.83 69163.93 0.02 0.0425
+20135 100 24.0 \N 28134.48 66819.39 0.0 0.048
+21056 100 33.0 24.0 38684.91 97298.41 0.02 0.055
21314 27 24.0 93.0 28134.48 32823.56 0.07 0.044
21346 27 4.0 117.0 4689.08 15239.51 0.09 0.0475
-27014 27 9.0 121.0 10550.43 33995.83 0.02 0.05667
-44387 27 20.0 130.0 23445.4 45718.53 0.03 0.075
-48032 27 19.0 150.0 22273.13 46890.8 0.02 0.07
-49095 27 21.0 169.0 24617.67 39857.18 0.02 \N
-52736 27 13.0 190.0 15239.51 56268.96 0.08 \N
-56898 27 35.0 203.0 41029.45 41029.45 0.07 \N
-1985 54 33.0 \N 38684.91 96126.14 0.1 0.04167
-8673 54 49.0 33.0 57441.23 91437.06 0.02 0.044
-17092 54 29.0 82.0 33995.83 69163.93 0.02 0.0425
24643 54 30.0 111.0 35168.1 57441.23 0.03 0.03333
+27014 27 9.0 121.0 10550.43 33995.83 0.02 0.05667
27394 54 19.0 141.0 22273.13 28134.48 0.05 0.05
-37186 54 5.0 160.0 5861.35 50407.61 0.07 0.03
-52067 54 38.0 165.0 44546.26 64474.85 0.0 \N
-52258 54 17.0 203.0 19928.59 33995.83 0.07 \N
-58279 54 12.0 220.0 14067.24 14067.24 0.03 \N
-10727 73 17.0 \N 19928.59 62130.31 0.02 0.07
28326 73 36.0 17.0 42201.72 87920.25 0.09 \N
30406 73 39.0 53.0 45718.53 87920.25 0.04 \N
-37185 73 36.0 92.0 42201.72 42201.72 0.07 \N
-20135 100 24.0 \N 28134.48 66819.39 0.0 0.048
-21056 100 33.0 24.0 38684.91 97298.41 0.02 0.055
30822 100 50.0 57.0 58613.5 62130.31 0.07 0.05667
31911 100 3.0 107.0 3516.81 41029.45 0.02 0.055
33600 100 32.0 110.0 37512.64 51579.88 0.05 0.07
37063 100 12.0 142.0 14067.24 16411.78 0.06 \N
+37185 73 36.0 92.0 42201.72 42201.72 0.07 \N
+37186 54 5.0 160.0 5861.35 50407.61 0.07 0.03
+44387 27 20.0 130.0 23445.4 45718.53 0.03 0.075
47365 100 2.0 154.0 2344.54 58613.5 0.04 \N
+48032 27 19.0 150.0 22273.13 46890.8 0.02 0.07
+49095 27 21.0 169.0 24617.67 39857.18 0.02 \N
50304 100 48.0 156.0 56268.96 56268.96 0.07 \N
+52067 54 38.0 165.0 44546.26 64474.85 0.0 \N
+52258 54 17.0 203.0 19928.59 33995.83 0.07 \N
+52736 27 13.0 190.0 15239.51 56268.96 0.08 \N
+56898 27 35.0 203.0 41029.45 41029.45 0.07 \N
+58279 54 12.0 220.0 14067.24 14067.24 0.03 \N
diff --git
a/regression-test/suites/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.sql
b/regression-test/suites/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.sql
index 2a629f1559..465a31ae2e 100644
---
a/regression-test/suites/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.sql
+++
b/regression-test/suites/query_p0/sql_functions/window_functions/sql/rowsDisjointWindows.sql
@@ -7,3 +7,4 @@ total_extendedprice,
discount,
round(avg(discount) over (partition by suppkey order by orderkey rows between
3 following and unbounded following), 5) avg_discount
from tpch_tiny_lineitem where partkey = 272
+order by orderkey, suppkey
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
