Changeset: 687976daefc6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=687976daefc6 Modified Files: sql/test/analytics/Tests/analytics09.sql sql/test/analytics/Tests/analytics09.stable.err sql/test/analytics/Tests/analytics09.stable.out Branch: default Log Message:
Approved test output. diffs (106 lines): diff --git a/sql/test/analytics/Tests/analytics09.sql b/sql/test/analytics/Tests/analytics09.sql --- a/sql/test/analytics/Tests/analytics09.sql +++ b/sql/test/analytics/Tests/analytics09.sql @@ -57,17 +57,17 @@ select cast(prod(sum(aa)) * count(1 + aa select rank() over (partition by case when aa > 5 then aa else aa + 5 end) from analytics; -select rank() over (partition by sum(aa)) from analytics; --TODO we don't support expressions in partition by as well group by +select rank() over (partition by sum(aa)) from analytics; -select rank() over (partition by 12*sum(aa)) from analytics; --TODO +select rank() over (partition by 12*sum(aa)) from analytics; select rank() over (partition by sum(aa)) from analytics group by aa; select rank() over (partition by sum(aa)) from analytics group by bb; -select rank() over (partition by sum(aa)*sum(bb)) from analytics; --TODO +select rank() over (partition by sum(aa)*sum(bb)) from analytics; -select rank() over (partition by sum(aa), sum(bb)) from analytics; --TODO +select rank() over (partition by sum(aa), sum(bb)) from analytics; select rank() over (partition by sum(aa), sum(bb)) from analytics group by aa; diff --git a/sql/test/analytics/Tests/analytics09.stable.err b/sql/test/analytics/Tests/analytics09.stable.err --- a/sql/test/analytics/Tests/analytics09.stable.err +++ b/sql/test/analytics/Tests/analytics09.stable.err @@ -43,33 +43,17 @@ MAPI = (monetdb) /var/tmp/mtest-1389/.s QUERY = select cast(prod(sum(aa)) * count(1 + aa) / avg(null) over () as bigint) from analytics; --error, nesting aggregation functions ERROR = !SELECT: subquery result missing CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-11873/.s.monetdb.31832 -QUERY = select rank() over (partition by sum(aa)) from analytics; --TODO we don't support expressions in partition by as well group by -ERROR = !Cannot use non GROUP BY column 'aa' in query results without an aggregate function -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-10156/.s.monetdb.31763 -QUERY = select rank() over (partition by 12*sum(aa)) from analytics; --TODO -ERROR = !Cannot use non GROUP BY column 'aa' in query results without an aggregate function -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-10156/.s.monetdb.31763 -QUERY = select rank() over (partition by sum(aa)*sum(bb)) from analytics; --TODO -ERROR = !Cannot use non GROUP BY column 'aa' in query results without an aggregate function -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-10156/.s.monetdb.31763 -QUERY = select rank() over (partition by sum(aa), sum(bb)) from analytics; --TODO -ERROR = !Cannot use non GROUP BY column 'aa' in query results without an aggregate function -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-10156/.s.monetdb.31763 +MAPI = (monetdb) /var/tmp/mtest-17541/.s.monetdb.31437 QUERY = select rank() over (partition by sum(aa), bb) from analytics group by aa; --error ERROR = !SELECT: cannot use non GROUP BY column 'bb' in query results without an aggregate function CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-10156/.s.monetdb.31763 QUERY = select min(aa) over (partition by sum(bb)) from analytics; --error -ERROR = !Cannot use non GROUP BY column 'aa' in query results without an aggregate function +ERROR = !SELECT: cannot use non GROUP BY column 'aa' in query results without an aggregate function CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9405/.s.monetdb.32071 QUERY = select min(aa) over (partition by sum(aa)) from analytics; ---error -ERROR = !Cannot use non GROUP BY column 'aa' in query results without an aggregate function +ERROR = !SELECT: cannot use non GROUP BY column 'aa' in query results without an aggregate function CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-10884/.s.monetdb.34034 QUERY = select rank() over (order by sum(aa)) from analytics; --TODO diff --git a/sql/test/analytics/Tests/analytics09.stable.out b/sql/test/analytics/Tests/analytics09.stable.out --- a/sql/test/analytics/Tests/analytics09.stable.out +++ b/sql/test/analytics/Tests/analytics09.stable.out @@ -218,6 +218,18 @@ Ready. [ 1 ] [ 1 ] [ 1 ] +#select rank() over (partition by sum(aa)) from analytics; +% sys.L5 # table_name +% L5 # name +% int # type +% 1 # length +[ 1 ] +#select rank() over (partition by 12*sum(aa)) from analytics; +% sys.L6 # table_name +% L6 # name +% int # type +% 1 # length +[ 1 ] #select rank() over (partition by sum(aa)) from analytics group by aa; % sys.L4 # table_name % L4 # name @@ -240,6 +252,18 @@ Ready. [ 1 ] [ 1 ] [ 1 ] +#select rank() over (partition by sum(aa)*sum(bb)) from analytics; +% sys.L7 # table_name +% L7 # name +% int # type +% 1 # length +[ 1 ] +#select rank() over (partition by sum(aa), sum(bb)) from analytics; +% sys.L6 # table_name +% L6 # name +% int # type +% 1 # length +[ 1 ] #select rank() over (partition by sum(aa), sum(bb)) from analytics group by aa; % sys.L5 # table_name % L5 # name _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
