Changeset: dbe8ead8bac8 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dbe8ead8bac8 Modified Files: sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.out Branch: Jan2014 Log Message:
Approve output. diffs (33 lines): diff --git a/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err b/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err --- a/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err +++ b/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err @@ -28,7 +28,12 @@ stderr of test 'nested_common_table_exp. # 16:59:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-696" "--port=38407" # 16:59:35 > -0D000!CREATE TYPE: unknown external type 'json' +MAPI = (monetdb) /var/tmp/mtest-24212/.s.monetdb.35205 +QUERY = WITH a AS (SELECT a, b FROM wtf WHERE a IN (1, 4)), + b AS (SELECT a, b, count(*) AS d FROM a GROUP BY a, b), + c AS (SELECT a, count(*) AS e FROM b GROUP BY b) + SELECT * FROM c; +ERROR = !SELECT: cannot use non GROUP BY column 'a' in query results without an aggregate function # 16:59:36 > # 16:59:36 > "Done." diff --git a/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.out b/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.out --- a/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.out +++ b/sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.out @@ -48,6 +48,12 @@ Ready. # 16:59:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-696" "--port=38407" # 16:59:35 > +#CREATE TABLE wtf(a int, b int, c int); +#INSERT INTO wtf VALUES(1, 2, 3); +[ 1 ] +#INSERT INTO wtf VALUES(4, 5, 6); +[ 1 ] +#drop table wtf; # 16:59:36 > # 16:59:36 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
