Import SQLite 3.8.7.4.

third_party/sqlite/src/test/trigger9.test

 # 2008 January 1
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 14 matching lines @@
 #                  in "INSTEAD OF" triggers have NULL values in unused 
 #                  fields.
 #
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 ifcapable {!trigger} {
   finish_test
   return
 }
+set ::testprefix trigger9
 
 proc has_rowdata {sql} {
   expr {[lsearch [execsql "explain $sql"] RowData]>=0}
 }
 
 do_test trigger9-1.1 {
   execsql {
     PRAGMA page_size = 1024;
     CREATE TABLE t1(x, y, z);
     INSERT INTO t1 VALUES('1', randstr(10000,10000), '2');
@@ skipping 168 matching lines @@
         CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
           INSERT INTO t2 VALUES(old.a);
         END;
         UPDATE v1 SET b = 'hello';
         SELECT * FROM t2;
       ROLLBACK;
     }
   } {2}
 }
 
+reset_db
+do_execsql_test 4.1 {
+  CREATE TABLE t1(a, b);
+  CREATE TABLE log(x);
+  INSERT INTO t1 VALUES(1, 2);
+  INSERT INTO t1 VALUES(3, 4);
+  CREATE VIEW v1 AS SELECT a, b FROM t1;
+
+  CREATE TRIGGER tr1 INSTEAD OF DELETE ON v1 BEGIN
+    INSERT INTO log VALUES('delete');
+  END;
+
+  CREATE TRIGGER tr2 INSTEAD OF UPDATE ON v1 BEGIN
+    INSERT INTO log VALUES('update');
+  END;
+
+  CREATE TRIGGER tr3 INSTEAD OF INSERT ON v1 BEGIN
+    INSERT INTO log VALUES('insert');
+  END;
+}
+
+do_execsql_test 4.2 {
+  DELETE FROM v1 WHERE rowid=1;
+} {}
+
+do_execsql_test 4.3 {
+  UPDATE v1 SET a=b WHERE rowid=2;
+} {}
+
+
+
+
 finish_test