Changeset: fa366cd68200 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fa366cd68200 Modified Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err Branch: Aug2018 Log Message:
We will approve bug 6608 error messages (same issue as in bug 3340). diffs (48 lines): diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err b/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err @@ -30,7 +30,7 @@ stderr of test 'sqlitelogictest-groupby- MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT DISTINCT - COALESCE ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0; -ERROR = !SELECT: cannot use non GROUP BY column 'cor0.col1' in query results without an aggregate function +ERROR = !SELECT: no such aggregate 'sql_neg' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT COALESCE ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0; @@ -38,7 +38,7 @@ ERROR = !SELECT: cannot use non GROUP BY CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT ALL + 33 * - COALESCE ( - 86, tab1.col2 ) + + col1 FROM tab1 GROUP BY tab1.col1; -ERROR = !SELECT: cannot use non GROUP BY column 'tab1.col2' in query results without an aggregate function +ERROR = !SELECT: no such aggregate 'sql_add' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT COALESCE ( - 86, tab1.col2 ) FROM tab1 GROUP BY tab1.col1; @@ -46,7 +46,7 @@ ERROR = !SELECT: cannot use non GROUP BY CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT ALL + COALESCE ( - cor0.col1, cor0.col1, 63, - cor0.col2 ) * - cor0.col1 AS col1 FROM tab0 cor0 GROUP BY cor0.col0, col1; -ERROR = !SELECT: cannot use non GROUP BY column 'cor0.col2' in query results without an aggregate function +ERROR = !SELECT: no such aggregate 'sql_mul' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT ALL + COALESCE ( - cor0.col1, cor0.col1, 63, cor0.col2 ) AS col1 FROM tab0 cor0 GROUP BY cor0.col0, col1; @@ -54,7 +54,7 @@ ERROR = !SELECT: cannot use non GROUP BY CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT - 38 + - tab1.col1 - tab1.col1 / COALESCE ( + 20, - tab1.col0 ) FROM tab1 GROUP BY tab1.col1; -ERROR = !SELECT: cannot use non GROUP BY column 'tab1.col0' in query results without an aggregate function +ERROR = !SELECT: no such aggregate 'sql_sub' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT COALESCE ( + 20, tab1.col0 ) FROM tab1 GROUP BY tab1.col1; @@ -62,7 +62,7 @@ ERROR = !SELECT: cannot use non GROUP BY CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT DISTINCT COALESCE ( - 82, - cor0.col0, - CAST ( NULL AS INTEGER ) ) / - 70 FROM tab0 AS cor0 GROUP BY cor0.col2; -ERROR = !SELECT: cannot use non GROUP BY column 'cor0.col0' in query results without an aggregate function +ERROR = !SELECT: no such aggregate 'sql_div' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 QUERY = SELECT DISTINCT COALESCE ( - 82, cor0.col0, - CAST ( NULL AS INTEGER ) ) FROM tab0 AS cor0 GROUP BY cor0.col2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
