Changeset: 6d5793b2746b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6d5793b2746b Modified Files: sql/test/BugTracker-2017/Tests/nestedoperators.Bug-6292.stable.err Branch: Dec2016 Log Message:
Approve error output diffs (28 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,6 +29,24 @@ 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 > # 15:14:19 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
