Changeset: dc63791e4dc6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dc63791e4dc6 Added Files: sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.sql Branch: default Log Message:
Added bug 6397 diffs (28 lines): diff --git a/sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.sql b/sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.sql @@ -0,0 +1,23 @@ +-- this query gives inconsistent answers when run multiple times. +CREATE FUNCTION my_generate_series(start INT, finish INT) +RETURNS TABLE (value INT) +BEGIN + DECLARE TABLE tmp_generate_series(value INT); + DECLARE i INT; + SET i = start; + WHILE (i <= finish) DO + INSERT INTO tmp_generate_series VALUES(i); + SET i = i + 1; + END WHILE; + RETURN tmp_generate_series; +END; + +explain select count(*) from my_generate_series(1,5) as t1, +my_generate_series(1,100) as t2; + +select count(*) from my_generate_series(1,5) as t1, +my_generate_series(1,100) as t2; +select count(*) from my_generate_series(1,5) as t1, +my_generate_series(1,100) as t2; +select count(*) from my_generate_series(1,5) as t1, +my_generate_series(1,100) as t2; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
