Changeset: 395d1a4d4ebc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=395d1a4d4ebc Modified Files: sql/test/subquery/Tests/subquery.sql Branch: default Log Message:
Aggregate functions are not allowed in where clause. A better error message should be thrown diffs (12 lines): diff --git a/sql/test/subquery/Tests/subquery.sql b/sql/test/subquery/Tests/subquery.sql --- a/sql/test/subquery/Tests/subquery.sql +++ b/sql/test/subquery/Tests/subquery.sql @@ -75,6 +75,8 @@ SELECT i % 2 AS k, CAST(SUM(i) AS BIGINT SELECT i FROM integers WHERE NOT(i IN (SELECT i FROM integers WHERE i>1)); -- 1 SELECT (SELECT CAST(SUM(i) AS BIGINT) FROM integers), (SELECT 42); +SELECT 1 FROM integers WHERE SUM(i) > 1; --aggregates not allowed in where clause + drop TABLE integers; -- varchar tests _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
