Changeset: 03065f95e7bd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=03065f95e7bd
Modified Files:
sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.sql
sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.stable.out
Branch: Apr2019
Log Message:
Extending test with DROP TABLE t111 CASCADE; such that created objects (table
and trigger) are properly removed.
diffs (37 lines):
diff --git a/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.sql
b/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.sql
--- a/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.sql
+++ b/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.sql
@@ -3,6 +3,7 @@ CREATE TABLE t111 (id INT, name VARCHAR(
INSERT INTO t111 VALUES(10, 'monetdb');
INSERT INTO t111 VALUES(20, 'monet');
+-- trigger which triggers itself recursively until reaching max nesting depth
or out of stack space
CREATE TRIGGER
test5
BEFORE INSERT ON t111
@@ -11,9 +12,13 @@ FOR EACH ROW
INSERT INTO t111 SELECT * FROM t111;
-SELECT * FROM t111;
+SELECT * FROM t111;
INSERT INTO t111 VALUES(30,'single');
SELECT * FROM t111;
DROP TABLE t111;
+-- fails with: unable to drop table t111 (there are database objects which
depend on it)
+
+-- cleanup table and dependent trigger
+DROP TABLE t111 CASCADE;
diff --git a/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.stable.out
b/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.stable.out
--- a/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.stable.out
+++ b/sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.stable.out
@@ -91,6 +91,7 @@ Ready.
% 2, 7 # length
[ 10, "monetdb" ]
[ 20, "monet" ]
+#DROP TABLE t111 CASCADE;
# 09:09:27 >
# 09:09:27 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
