Changeset: b898a1e12b89 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b898a1e12b89 Modified Files: sql/test/analytics/Tests/analytics01.test Branch: Aug2024 Log Message:
stricter test results order in analytics01.test diffs (truncated from 1521 to 300 lines): diff --git a/sql/test/analytics/Tests/analytics01.test b/sql/test/analytics/Tests/analytics01.test --- a/sql/test/analytics/Tests/analytics01.test +++ b/sql/test/analytics/Tests/analytics01.test @@ -568,11 +568,11 @@ NULL NULL query I rowsort -select ntile(aa) over (partition by bb) from analytics +select ntile(aa) over (partition by bb order by aa) from analytics ---- 1 1 -1 +2 2 2 3 @@ -582,10 +582,10 @@ NULL NULL query I nosort -select ntile(aa) over (partition by bb order by bb asc) from analytics +select ntile(aa) over (partition by bb order by bb, aa asc) from analytics ---- 1 -1 +2 3 NULL 2 @@ -596,21 +596,21 @@ 3 NULL query I nosort -select ntile(aa) over (partition by bb order by bb desc) from analytics +select ntile(aa) over (partition by bb order by bb, aa desc) from analytics ---- +1 +2 +2 +1 +2 NULL 1 2 3 NULL -2 -3 -1 -1 -3 query I nosort -select ntile(aa) over (order by bb) from analytics +select ntile(aa) over (order by bb, aa) from analytics ---- 1 1 @@ -618,27 +618,27 @@ 1 NULL 2 4 +4 +4 +9 +NULL + +query I nosort +select ntile(aa) over (order by bb, aa desc) from analytics +---- +1 +1 +1 +2 +2 +NULL 7 4 5 NULL -query I nosort -select ntile(aa) over (order by bb desc) from analytics ----- -NULL -2 -2 -2 -NULL -2 -5 -3 -2 -4 - query I rowsort -select ntile(bb) over (partition by aa) from analytics +select ntile(bb) over (partition by aa order by bb) from analytics ---- 1 1 @@ -652,7 +652,7 @@ 2 2 query I nosort -select ntile(bb) over (partition by aa order by aa asc) from analytics +select ntile(bb) over (partition by aa order by aa, bb asc) from analytics ---- 1 2 @@ -666,18 +666,18 @@ 1 1 query I nosort -select ntile(bb) over (partition by aa order by aa desc) from analytics +select ntile(bb) over (partition by aa order by aa, bb desc) from analytics ---- 1 -1 -1 -1 -1 -1 2 1 1 -2 +1 +1 +1 +1 +1 +1 query I nosort select ntile(bb) over (order by aa) from analytics @@ -694,7 +694,7 @@ 2 3 query I nosort -select ntile(bb) over (order by aa desc) from analytics +select ntile(bb) over (order by aa, bb desc) from analytics ---- 1 1 @@ -703,9 +703,9 @@ 1 1 1 2 -1 +3 2 -4 +3 query I rowsort select ntile(bb) over (partition by bb) from analytics @@ -848,60 +848,60 @@ 15 15 query I rowsort -select first_value(aa) over (partition by bb) from analytics +select first_value(aa) over (partition by bb order by aa) from analytics ---- -15 -15 -15 -3 -3 -3 +2 +2 +2 +5 +5 +5 NULL NULL NULL NULL query I nosort -select first_value(aa) over (partition by bb order by bb asc) from analytics +select first_value(aa) over (partition by bb order by bb, aa asc) from analytics ---- -3 -3 -3 -NULL -NULL -NULL +2 +2 +2 +NULL +NULL +NULL +5 +5 +5 +NULL + +query I nosort +select first_value(aa) over (partition by bb order by bb, aa desc) from analytics +---- +4 +4 +4 +8 +8 +8 15 15 15 NULL query I nosort -select first_value(aa) over (partition by bb order by bb desc) from analytics +select first_value(aa) over (order by bb, aa) from analytics ---- -NULL -15 -15 -15 -NULL -NULL -NULL -3 -3 -3 - -query I nosort -select first_value(aa) over (order by bb) from analytics ----- -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 +2 +2 +2 +2 +2 +2 +2 +2 +2 +2 query I nosort select first_value(aa) over (order by bb desc) from analytics @@ -918,80 +918,81 @@ NULL NULL query I rowsort -select nth_value(aa, 1) over (partition by bb) from analytics +select nth_value(aa, 1) over (partition by bb order by aa) from analytics ---- -15 -15 -15 -3 -3 -3 +2 +2 +2 +5 +5 +5 NULL NULL NULL NULL query I nosort -select nth_value(aa, 1) over (partition by bb order by bb asc) from analytics +select nth_value(aa, 1) over (partition by bb order by bb, aa asc) from analytics ---- -3 -3 -3 -NULL -NULL -NULL +2 +2 +2 +NULL +NULL +NULL +5 +5 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
