aboutsummaryrefslogtreecommitdiff
path: root/test/trigger1.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/trigger1.test')
-rw-r--r--test/trigger1.test43
1 files changed, 42 insertions, 1 deletions
diff --git a/test/trigger1.test b/test/trigger1.test
index bad2f92df..cbcb90c87 100644
--- a/test/trigger1.test
+++ b/test/trigger1.test
@@ -30,13 +30,20 @@
set testdir [file dirname $argv0]
source $testdir/tester.tcl
-do_test trigger1-1.1 {
+do_test trigger1-1.1.2 {
catchsql {
CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
SELECT * from sqlite_master;
END;
}
} {1 {no such table: no_such_table}}
+do_test trigger1-1.1.2 {
+ catchsql {
+ CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
+ SELECT * from sqlite_master;
+ END;
+ }
+} {1 {no such table: no_such_table}}
execsql {
CREATE TABLE t1(a);
@@ -267,4 +274,38 @@ do_test trigger-3.9 {
}
} {1 2 3 4 5 6 3 4}
+do_test trigger-4.1 {
+ execsql {
+ CREATE TEMP TRIGGER r1 BEFORE INSERT ON t1 BEGIN
+ INSERT INTO t2 VALUES(NEW.a,NEW.b);
+ END;
+ INSERT INTO t1 VALUES(7,8);
+ SELECT * FROM t2;
+ }
+} {3 4 7 8}
+do_test trigger-4.2 {
+ sqlite db2 test.db
+ execsql {
+ INSERT INTO t1 VALUES(9,10);
+ } db2;
+ db2 close
+ execsql {
+ SELECT * FROM t2;
+ }
+} {3 4 7 8}
+do_test trigger-4.3 {
+ execsql {
+ DROP TABLE t1;
+ SELECT * FROM t2;
+ };
+} {3 4 7 8}
+do_test trigger-4.4 {
+ db close
+ sqlite db test.db
+ execsql {
+ SELECT * FROM t2;
+ };
+} {3 4 7 8}
+
+
finish_test