Changeset: 4ac1568587b0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4ac1568587b0
Modified Files:
sql/test/analytics/Tests/analytics09.sql
sql/test/analytics/Tests/analytics09.stable.err
Branch: default
Log Message:
Added another failing query.
diffs (52 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
@@ -51,12 +51,15 @@ select cast(sum(aa) * count(aa) over ()
select cast(sum(sum(aa)) over () as bigint),
cast(sum(aa) * count(count(aa)) over () as bigint) from analytics group
by aa;
+select count(aa) over (),
+ avg(aa) over () * count(aa) from analytics group by aa; --TODO
+
select cast(sum(aa) over () as bigint),
cast(sum(aa) over () as bigint),
cast(sum(aa) * count(aa) over () as bigint) from analytics group by aa;
--TODO
-select avg(sum(aa)) over (),
- avg(sum(aa)) over (),
+select 21 - avg(sum(aa)) over (),
+ avg(45 * count(aa) + sum(aa)) over (),
cast(sum(aa) * count(aa) over () as bigint) from analytics group by aa;
--TODO
select avg(sum(aa)) over (partition by bb) from analytics group by bb;
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
@@ -35,17 +35,22 @@ QUERY = select avg(sum(aa)) over (),
avg(sum(aa)) over (range unbounded preceding) from analytics
group by aa; --TODO support multiple aggregations within the same projection
ERROR = !Cannot use non GROUP BY column 'L3' in query results without an
aggregate function
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-19274/.s.monetdb.39185
+MAPI = (monetdb) /var/tmp/mtest-2883/.s.monetdb.36767
+QUERY = select count(aa) over (),
+ avg(aa) over () * count(aa) from analytics group by aa; --TODO
+ERROR = !Cannot use non GROUP BY column 'L2' in query results without an
aggregate function
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-2883/.s.monetdb.36767
QUERY = select cast(sum(aa) over () as bigint),
cast(sum(aa) over () as bigint),
cast(sum(aa) * count(aa) over () as bigint) from analytics
group by aa; --TODO
ERROR = !Cannot use non GROUP BY column in query results without an aggregate
function
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-4999/.s.monetdb.31453
-QUERY = select avg(sum(aa)) over (),
- avg(sum(aa)) over (),
+MAPI = (monetdb) /var/tmp/mtest-2883/.s.monetdb.36767
+QUERY = select 21 - avg(sum(aa)) over (),
+ avg(45 * count(aa) + sum(aa)) over (),
cast(sum(aa) * count(aa) over () as bigint) from analytics
group by aa; --TODO
-ERROR = !Cannot use non GROUP BY column 'L3' in query results without an
aggregate function
+ERROR = !Cannot use non GROUP BY column in query results without an aggregate
function
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-4999/.s.monetdb.31453
QUERY = select cast(sum(aa) * 100 / sum(sum(aa)) over (partition by bb) as
bigint) from analytics; --error, nesting aggregation functions
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
