Import SQLite 3.7.6.3.

third_party/sqlite/src/test/tkt3201.test

 # 2008 July 4
 #
 # 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 54 matching lines @@
   }
   execsql { SELECT a, b, c, d FROM t1, t3 }
 } {1 one 2 two}
 
 do_test tkt3201-7 {
   execsql { SELECT a, b, c, d FROM t1, t3 WHERE a < c }
 } {1 one 2 two}
 
 # Ticket [efc02f977919]
 #
-do_test tkt3201-4.0 {
-  db eval {
-   CREATE TABLE t4(x);
-   CREATE TABLE t4_log(x);
-   CREATE TRIGGER r4_1 AFTER INSERT ON t4 WHEN new.x=1 BEGIN
-     INSERT INTO t4_log(x) VALUES(new.x);
-   END;
-   CREATE TRIGGER r4_2 AFTER INSERT ON t4 WHEN new.x=2 BEGIN
-     INSERT INTO t4_log(x) VALUES(new.x);
-   END;
-   CREATE TRIGGER r4_3 AFTER INSERT ON t4 WHEN new.x=3 BEGIN
-     INSERT INTO t4_log(x) VALUES(new.x);
-   END;
-   CREATE TRIGGER r4_4 AFTER INSERT ON t4 WHEN new.x=4 BEGIN
-     INSERT INTO t4_log(x) VALUES(new.x);
-   END;
-   INSERT INTO t4 VALUES(1);
-   INSERT INTO t4 VALUES(2);
-   INSERT INTO t4 VALUES(3);
-   INSERT INTO t4 VALUES(4);
-   SELECT * FROM t4_log;
-  }
-} {1 2 3 4}
+ifcapable trigger {
+  do_test tkt3201-4.0 {
+    db eval {
+     CREATE TABLE t4(x);
+     CREATE TABLE t4_log(x);
+     CREATE TRIGGER r4_1 AFTER INSERT ON t4 WHEN new.x=1 BEGIN
+       INSERT INTO t4_log(x) VALUES(new.x);
+     END;
+     CREATE TRIGGER r4_2 AFTER INSERT ON t4 WHEN new.x=2 BEGIN
+       INSERT INTO t4_log(x) VALUES(new.x);
+     END;
+     CREATE TRIGGER r4_3 AFTER INSERT ON t4 WHEN new.x=3 BEGIN
+       INSERT INTO t4_log(x) VALUES(new.x);
+     END;
+     CREATE TRIGGER r4_4 AFTER INSERT ON t4 WHEN new.x=4 BEGIN
+       INSERT INTO t4_log(x) VALUES(new.x);
+     END;
+     INSERT INTO t4 VALUES(1);
+     INSERT INTO t4 VALUES(2);
+     INSERT INTO t4 VALUES(3);
+     INSERT INTO t4 VALUES(4);
+     SELECT * FROM t4_log;
+    }
+  } {1 2 3 4}
+}
 
 
 
 
 
 finish_test