Changeset: fd9ef65b0d80 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd9ef65b0d80
Modified Files:
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.err
Branch: Oct2020
Log Message:
Approved output and query with error message referencing column alias instead
of column
diffs (31 lines):
diff --git a/sql/test/subquery/Tests/subquery6.sql
b/sql/test/subquery/Tests/subquery6.sql
--- a/sql/test/subquery/Tests/subquery6.sql
+++ b/sql/test/subquery/Tests/subquery6.sql
@@ -246,6 +246,9 @@ select (select (i1.i, i2.i) in (select i
select min(i) as myx from integers group by myx;
-- I expect this to throw the error: aggregate functions are not
allowed in GROUP BY
+select ntile(i) over (), count(*) from integers;
+ --error, column "i" must appear in the GROUP BY clause or be used in an
aggregate function
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
DROP TABLE integers;
diff --git a/sql/test/subquery/Tests/subquery6.stable.err
b/sql/test/subquery/Tests/subquery6.stable.err
--- a/sql/test/subquery/Tests/subquery6.stable.err
+++ b/sql/test/subquery/Tests/subquery6.stable.err
@@ -66,6 +66,14 @@ MAPI = (monetdb) /var/tmp/mtest-137383/
QUERY = select 1 in (ColID, (select 1)), max(totalsales) from tbl_ProductSales;
ERROR = !SELECT: cannot use non GROUP BY column in query results without an
aggregate function
CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-214995/.s.monetdb.36797
+QUERY = select (select (i1.i, i2.i) in (select i2.i, i1.i) from integers i2)
from integers i1;
+ERROR = !Tuple matching at projections not implemented in the backend yet
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-214995/.s.monetdb.36797
+QUERY = select min(i) as myx from integers group by myx;
+ERROR = !MIN: aggregate function 'min' not allowed in GROUP BY clause
+CODE = 42000
# 11:45:43 >
# 11:45:43 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
