Changeset: e0bfaa5b7a56 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e0bfaa5b7a56 Added Files: sql/test/BugTracker-2013/Tests/pivot.Bug-3339.sql Modified Files: sql/test/BugTracker-2013/Tests/All Branch: default Log Message:
Addition of a test for segvault diffs (32 lines): diff --git a/sql/test/BugTracker-2013/Tests/All b/sql/test/BugTracker-2013/Tests/All --- a/sql/test/BugTracker-2013/Tests/All +++ b/sql/test/BugTracker-2013/Tests/All @@ -34,3 +34,4 @@ update_on_declared_table.Bug-3318 correlated_subselect.Bug-3317 incorrect_subquery_delete.Bug-3315 constraint_checking.Bug_3335 +pivot.Bug-3339 diff --git a/sql/test/BugTracker-2013/Tests/pivot.Bug-3339.sql b/sql/test/BugTracker-2013/Tests/pivot.Bug-3339.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2013/Tests/pivot.Bug-3339.sql @@ -0,0 +1,19 @@ +CREATE FUNCTION groupElements(beg INTEGER) +RETURNS TABLE (x INTEGER) +BEGIN + CREATE TABLE tmp(x INTEGER); + INSERT INTO tmp VALUES(beg), (beg+1), (beg+2); + RETURN tmp; +END; + +SELECT * FROM groupElements(1); + +CREATE TABLE tmp(x INTEGER); +INSERT INTO tmp VALUES (1),(2); +SELECT * FROM (SELECT * FROM tmp) AS A; + +SELECT (SELECT * FROM groupElements(pivot.x)) +FROM (SELECT * FROM tmp) as pivot; + +DROP TABLE tmp; +DROP FUNCTION groupElements; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
