diff options
Diffstat (limited to 'third_party/sqlite/test/trigger2.test')
-rw-r--r-- | third_party/sqlite/test/trigger2.test | 17 |
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 |