summaryrefslogtreecommitdiff
path: root/test/trigger1.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/trigger1.test')
-rw-r--r--test/trigger1.test16
1 files changed, 14 insertions, 2 deletions
diff --git a/test/trigger1.test b/test/trigger1.test
index dc344d4..9d917bd 100644
--- a/test/trigger1.test
+++ b/test/trigger1.test
@@ -29,7 +29,7 @@
set testdir [file dirname $argv0]
source $testdir/tester.tcl
-ifcapable {!trigger} {
+ifcapable !trigger||!compound {
finish_test
return
}
@@ -290,10 +290,22 @@ ifcapable tempdb {
SELECT * FROM t2;
}
} {1 {no such table: main.t2}}
- do_test trigger-3.6 {
+ do_test trigger-3.6.1 {
catchsql {
DROP TRIGGER r1;
CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
+ INSERT INTO t2 VALUES(NEW.a,NEW.b), (NEW.b*100, NEW.a*100);
+ END;
+ INSERT INTO t1 VALUES(1,2);
+ SELECT * FROM t2;
+ }
+ } {0 {1 2 200 100}}
+ do_test trigger-3.6.2 {
+ catchsql {
+ DROP TRIGGER r1;
+ DELETE FROM t1;
+ DELETE FROM t2;
+ CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
INSERT INTO t2 VALUES(NEW.a,NEW.b);
END;
INSERT INTO t1 VALUES(1,2);