Changeset: 140fe2c70c2a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=140fe2c70c2a
Modified Files:
sql/test/LSST/Tests/dbQuery036.stable.err
sql/test/Tests/marcin3.stable.err
Branch: Apr2019
Log Message:
Approved output
diffs (24 lines):
diff --git a/sql/test/LSST/Tests/dbQuery036.stable.err
b/sql/test/LSST/Tests/dbQuery036.stable.err
--- a/sql/test/LSST/Tests/dbQuery036.stable.err
+++ b/sql/test/LSST/Tests/dbQuery036.stable.err
@@ -85,7 +85,7 @@ QUERY = SELECT ROUND(uMag-gMag,0) AS UG
AND (uMag+gMag+rMag+iMag+zMag+yMag) < 150 -- exclude bogus
magnitudes (== 999)
GROUP BY UG, GR, RI, IZ, ZY
HAVING pop > 500 -- Common bucktes have 500 or more members, so
delete them
-ERROR = !SELECT: cannot use non GROUP BY column 'pop' in query results without
an aggregate function
+ERROR = !SELECT: identifier 'pop' unknown
CODE = 42000
# 05:57:35 >
diff --git a/sql/test/Tests/marcin3.stable.err
b/sql/test/Tests/marcin3.stable.err
--- a/sql/test/Tests/marcin3.stable.err
+++ b/sql/test/Tests/marcin3.stable.err
@@ -21,7 +21,7 @@ ERROR = !SELECT: cannot use non GROUP BY
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-26937/.s.monetdb.35713
QUERY = select id, sum(val) AS valsum from nutki group by id having valsum>3;
-ERROR = !SELECT: cannot use non GROUP BY column 'valsum' in query results
without an aggregate function
+ERROR = !SELECT: identifier 'valsum' unknown
CODE = 42000
# 21:15:41 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
