[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: Apr2019 - Approved output
From:       Pedro Ferreira <commits+pedro.ferreira=monetdbsolutions.com () monetdb ! org>
Date:       2019-09-30 14:28:51
Message-ID: hg.140fe2c70c2a.1569853731.6315528441665844383 () monetdb-vm0 ! spin-off ! cwi ! nl
[Download RAW message or body]

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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
[prev in list] [next in list] [prev in thread] [next in thread]