Import SQLite 3.10.2.

third_party/sqlite/src/test/trigger1.test

 # 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.
 #
 #***********************************************************************
 #
 # This file tests creating and dropping triggers, and interaction thereof
@@ skipping 694 matching lines @@
   }
 } {1 {the NOT INDEXED clause is not allowed on UPDATE or DELETE statements within triggers}}
 do_test trigger1-16.7 {
   catchsql {
     CREATE TRIGGER main.t16err7 AFTER INSERT ON tA BEGIN
       DELETE FROM t16 INDEXED BY t16a WHERE a=123;
     END;
   }
 } {1 {the INDEXED BY clause is not allowed on UPDATE or DELETE statements within triggers}}
 
+#-------------------------------------------------------------------------
+# Test that bug [34cd55d68e0e6e7c] has been fixed.
+#
+do_execsql_test trigger1-17.0 {
+  CREATE TABLE t17a(ii INT);
+  CREATE TABLE t17b(tt TEXT PRIMARY KEY, ss);
+  CREATE TRIGGER t17a_ai AFTER INSERT ON t17a BEGIN
+    INSERT INTO t17b(tt) VALUES(new.ii);
+  END;
+  CREATE TRIGGER t17b_ai AFTER INSERT ON t17b BEGIN
+    UPDATE t17b SET ss = 4;
+  END;
+  INSERT INTO t17a(ii) VALUES('1');
+  PRAGMA integrity_check;
+} {ok}
+
 finish_test