Changeset: b3ae7f502c67 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b3ae7f502c67 Modified Files: sql/test/analytics/Tests/analytics02.sql sql/test/analytics/Tests/analytics02.stable.out Branch: analytics Log Message:
Approved tests. diffs (162 lines): diff --git a/sql/test/analytics/Tests/analytics02.sql b/sql/test/analytics/Tests/analytics02.sql --- a/sql/test/analytics/Tests/analytics02.sql +++ b/sql/test/analytics/Tests/analytics02.sql @@ -28,6 +28,13 @@ select count(bb) over (rows between 5 pr select count(bb) over (partition by aa order by aa rows between 5 preceding and 0 following) from analytics; select count(bb) over (partition by aa order by aa rows between 5 preceding and 2 following) from analytics; +select count(*) over (rows between unbounded preceding and unbounded following) from analytics; +select count(*) over (partition by bb order by bb rows between unbounded preceding and unbounded following) from analytics; +select count(aa) over (rows between unbounded preceding and unbounded following) from analytics; +select count(aa) over (partition by bb order by bb rows between unbounded preceding and unbounded following) from analytics; +select count(bb) over (rows between unbounded preceding and unbounded following) from analytics; +select count(bb) over (partition by aa order by aa rows between unbounded preceding and unbounded following) from analytics; + select count(*) over (rows between 5 preceding and 0 following); create table stressme (aa varchar(64), bb int); @@ -38,6 +45,9 @@ select count(aa) over (rows between 5 pr select count(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from stressme; select count(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) from stressme; +select count(aa) over (rows between unbounded preceding and unbounded following) from stressme; +select count(aa) over (partition by bb order by bb rows between unbounded preceding and unbounded following) from stressme; + create table debugme (aa real, bb int); insert into debugme values (15, 3), (3, 1), (2, 1), (5, 3), (NULL, 2), (3, 2), (4, 1), (6, 3), (8, 2), (NULL, 4); diff --git a/sql/test/analytics/Tests/analytics02.stable.out b/sql/test/analytics/Tests/analytics02.stable.out --- a/sql/test/analytics/Tests/analytics02.stable.out +++ b/sql/test/analytics/Tests/analytics02.stable.out @@ -328,6 +328,96 @@ Ready. [ 1 ] [ 1 ] [ 1 ] +#select count(*) over (rows between unbounded preceding and unbounded following) from analytics; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 2 # length +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +#select count(*) over (partition by bb order by bb rows between unbounded preceding and unbounded following) from analytics; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ 3 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 1 ] +#select count(aa) over (rows between unbounded preceding and unbounded following) from analytics; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +[ 8 ] +#select count(aa) over (partition by bb order by bb rows between unbounded preceding and unbounded following) from analytics; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ 3 ] +[ 3 ] +[ 3 ] +[ 2 ] +[ 2 ] +[ 2 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 0 ] +#select count(bb) over (rows between unbounded preceding and unbounded following) from analytics; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 2 # length +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +[ 10 ] +#select count(bb) over (partition by aa order by aa rows between unbounded preceding and unbounded following) from analytics; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ 2 ] +[ 2 ] +[ 1 ] +[ 2 ] +[ 2 ] +[ 1 ] +[ 1 ] +[ 1 ] +[ 1 ] +[ 1 ] #select count(*) over (rows between 5 preceding and 0 following); % .L4 # table_name % L4 # name @@ -393,6 +483,34 @@ Ready. [ 3 ] [ 3 ] [ 0 ] +#select count(aa) over (rows between unbounded preceding and unbounded following) from stressme; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ 7 ] +[ 7 ] +[ 7 ] +[ 7 ] +[ 7 ] +[ 7 ] +[ 7 ] +[ 7 ] +[ 7 ] +#select count(aa) over (partition by bb order by bb rows between unbounded preceding and unbounded following) from stressme; +% sys.L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ 3 ] +[ 3 ] +[ 3 ] +[ 1 ] +[ 1 ] +[ 3 ] +[ 3 ] +[ 3 ] +[ 0 ] #create table debugme (aa real, bb int); #insert into debugme values (15, 3), (3, 1), (2, 1), (5, 3), (NULL, 2), (3, 2), (4, 1), (6, 3), (8, 2), (NULL, 4); [ 10 ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
