Changeset: cecf7d6cbcb2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cecf7d6cbcb2 Modified Files: sql/test/analytics/Tests/analytics02.test Branch: Aug2024 Log Message:
order test results order for analytics02 diffs (truncated from 556 to 300 lines): diff --git a/sql/test/analytics/Tests/analytics02.test b/sql/test/analytics/Tests/analytics02.test --- a/sql/test/analytics/Tests/analytics02.test +++ b/sql/test/analytics/Tests/analytics02.test @@ -42,21 +42,21 @@ 32 38 query I nosort -select cast(sum(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) as bigint) from analytics +select cast(sum(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) as bigint) from analytics ---- -3 +2 5 9 NULL 3 11 -15 -20 +5 +11 26 NULL query I nosort -select cast(sum(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) as bigint) from analytics +select cast(sum(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) as bigint) from analytics ---- 9 9 @@ -70,49 +70,49 @@ 26 NULL query I rowsort -select cast(prod(aa) over (rows between 5 preceding and 0 following) as bigint) from analytics +select cast(prod(aa) over (order by aa rows between 5 preceding and 0 following) as bigint) from analytics ---- -1350 -15 -2880 +18 +2 +2160 360 -45 -450 -450 -576 -720 -90 +43200 +6 +72 +8640 +NULL +NULL query I rowsort -select cast(prod(aa) over (rows between 5 preceding and 2 following) as bigint) from analytics +select cast(prod(aa) over (order by aa rows between 5 preceding and 2 following) as bigint) from analytics ---- -1350 +129600 17280 -2880 -32400 -450 -450 -5400 -576 -5760 -90 +18 +2 +2160 +259200 +360 +43200 +6 +72 query I nosort -select cast(prod(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) as bigint) from analytics +select cast(prod(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) as bigint) from analytics ---- -3 +2 6 24 NULL 3 24 -15 -75 +5 +30 450 NULL query I nosort -select cast(prod(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) as bigint) from analytics +select cast(prod(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) as bigint) from analytics ---- 24 24 @@ -154,21 +154,21 @@ 6.250 6.667 query R nosort -select avg(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select avg(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics ---- -3.000 +2.000 2.500 3.000 NULL 3.000 5.500 -15.000 -10.000 +5.000 +5.500 8.667 NULL query R nosort -select avg(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) from analytics +select avg(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) from analytics ---- 3.000 3.000 @@ -210,21 +210,21 @@ 3 3 query I nosort -select min(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select min(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics ---- -3 +2 2 2 NULL 3 3 -15 +5 5 5 NULL query I nosort -select min(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) from analytics +select min(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) from analytics ---- 2 2 @@ -266,16 +266,16 @@ 8 8 query I nosort -select max(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select max(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics ---- -3 +2 3 4 NULL 3 8 -15 -15 +5 +6 15 NULL @@ -322,7 +322,7 @@ 1 1 query I nosort -select min(bb) over (partition by aa order by aa rows between 5 preceding and 0 following) from analytics +select min(bb) over (partition by aa order by aa, bb rows between 5 preceding and 0 following) from analytics ---- 2 2 @@ -336,7 +336,7 @@ 2 3 query I nosort -select min(bb) over (partition by aa order by aa rows between 5 preceding and 2 following) from analytics +select min(bb) over (partition by aa order by aa, bb rows between 5 preceding and 2 following) from analytics ---- 2 2 @@ -378,7 +378,7 @@ 4 4 query I nosort -select max(bb) over (partition by aa order by aa rows between 5 preceding and 0 following) from analytics +select max(bb) over (partition by aa order by aa, bb rows between 5 preceding and 0 following) from analytics ---- 2 4 @@ -392,7 +392,7 @@ 2 3 query I nosort -select max(bb) over (partition by aa order by aa rows between 5 preceding and 2 following) from analytics +select max(bb) over (partition by aa order by aa, bb rows between 5 preceding and 2 following) from analytics ---- 4 4 @@ -490,7 +490,7 @@ 7 7 query I nosort -select count(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select count(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics ---- 1 2 @@ -687,15 +687,15 @@ 2 3 query I nosort -select min(aa) over (partition by bb order by bb rows unbounded preceding) from analytics +select min(aa) over (partition by bb order by bb, aa rows unbounded preceding) from analytics ---- -3 +2 2 2 NULL 3 3 -15 +5 5 5 NULL @@ -715,16 +715,16 @@ 15 15 query I nosort -select max(aa) over (partition by bb order by bb rows unbounded preceding) from analytics +select max(aa) over (partition by bb order by bb, aa rows unbounded preceding) from analytics ---- -3 +2 3 4 NULL 3 8 -15 -15 +5 +6 15 NULL @@ -743,16 +743,16 @@ 46 46 query I nosort -select cast(sum(aa) over (partition by bb order by bb rows unbounded preceding) as bigint) from analytics +select cast(sum(aa) over (partition by bb order by bb, aa rows unbounded preceding) as bigint) from analytics ---- -3 +2 5 9 NULL 3 11 -15 -20 +5 +11 26 NULL @@ -771,16 +771,16 @@ 5400 90 query I nosort -select cast(prod(aa) over (partition by bb order by bb rows unbounded preceding) as bigint) from analytics +select cast(prod(aa) over (partition by bb order by bb, aa rows unbounded preceding) as bigint) from analytics ---- -3 +2 6 24 NULL 3 24 -15 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
