Changeset: 09b3022c50be for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=09b3022c50be Added Files: sql/test/BugTracker-2013/Tests/nestedcalls.sql Branch: Feb2013 Log Message:
added test nestedcalls from default branch (I am aware of creating merging conflicts and will solved them as soon as I do the merge) diffs (47 lines): diff --git a/sql/test/BugTracker-2013/Tests/nestedcalls.sql b/sql/test/BugTracker-2013/Tests/nestedcalls.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2013/Tests/nestedcalls.sql @@ -0,0 +1,42 @@ +CREATE FUNCTION bottom() +RETURNS TABLE (name string) +BEGIN + RETURN select name from tables; +END; + +CREATE FUNCTION leaf1() +RETURNS TABLE (name string) +BEGIN + RETURN select name from bottom() + UNION select name from bottom() + UNION select name from bottom() + UNION select name from bottom(); +END; + +CREATE FUNCTION leaf2() +RETURNS TABLE (name string) +BEGIN + RETURN select name from leaf1() + UNION select name from leaf1() + UNION select name from leaf1() + UNION select name from leaf1(); +END; + +CREATE FUNCTION leaf3() +RETURNS TABLE (name string) +BEGIN + RETURN select name from leaf2() + UNION select name from leaf2() + UNION select name from leaf2() + UNION select name from leaf2(); +END; + +SELECT count(*) FROM bottom(); +SELECT count(*) FROM leaf1(); +SELECT count(*) FROM leaf2(); +SELECT count(*) FROM leaf3(); + +DROP FUNCTION leaf1; +DROP FUNCTION leaf2; +DROP FUNCTION leaf3; +DROP FUNCTION bottom; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
