summaryrefslogtreecommitdiffstats
path: root/third_party/sqlite/test/trigger2.test
diff options
context:
space:
mode:
Diffstat (limited to 'third_party/sqlite/test/trigger2.test')
-rw-r--r--third_party/sqlite/test/trigger2.test17
1 files changed, 17 insertions, 0 deletions
diff --git a/third_party/sqlite/test/trigger2.test b/third_party/sqlite/test/trigger2.test
index b150c41..b4b922a 100644
--- a/third_party/sqlite/test/trigger2.test
+++ b/third_party/sqlite/test/trigger2.test
@@ -54,6 +54,11 @@ ifcapable {!trigger} {
return
}
+# The tests in this file were written before SQLite supported recursive
+# trigger invocation, and some tests depend on that to pass. So disable
+# recursive triggers for this file.
+catchsql { pragma recursive_triggers = off }
+
# 1.
ifcapable subquery {
set ii 0
@@ -735,6 +740,18 @@ do_test trigger2-8.6 {
}
} {3 103 5 205 4 304 9 109 11 211 10 310}
+# At one point the following was causing a segfault.
+do_test trigger2-9.1 {
+ execsql {
+ CREATE TABLE t3(a TEXT, b TEXT);
+ CREATE VIEW v3 AS SELECT t3.a FROM t3;
+ CREATE TRIGGER trig1 INSTEAD OF DELETE ON v3 BEGIN
+ SELECT 1;
+ END;
+ DELETE FROM v3 WHERE a = 1;
+ }
+} {}
+
} ;# ifcapable view
integrity_check trigger2-9.9