Changeset: 9ba8f9759221 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ba8f9759221 Modified Files: sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.err Branch: Jul2017 Log Message:
Approve output. diffs (27 lines): diff --git a/sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.err b/sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.err --- a/sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.err +++ b/sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.err @@ -29,23 +29,6 @@ stderr of test 'nestedoperators.Bug-6292 # 15:14:18 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-18530" "--port=30197" # 15:14:18 > -#~ MAPI = (monetdb) /var/tmp/mtest-32632/.s.monetdb.36482 -QUERY = CREATE FUNCTION rooms_derivative( stride bigint) - RETURNS TABLE( - time timestamp, - room string, - level integer, - temp double) - BEGIN - RETURN - WITH bounds(first, last, period) - AS (SELECT min(time) AS mintime, max(time) as maxtime, epoch(time)/60 AS period FROM rooms GROUP BY period) - SELECT r2.time, r2.room, r2.level, (r2.temp - r1.temp)/ (epoch(bounds.last) - epoch(bounds.first)) FROM bounds, rooms r1, rooms r2 - WHERE r1.time = bounds.first and r2.time = bounds.last and r1.room = r2.room and r1.level = r2.level; -ERROR = !SELECT: too many nested operators -#~ MAPI = (monetdb) /var/tmp/mtest-32632/.s.monetdb.36482 -QUERY = DROP FUNCTION rooms_derivative; -ERROR = !DROP FUNCTION: no such function 'rooms_derivative' # 15:14:19 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
