Import SQLite 3.8.7.4.

third_party/sqlite/src/test/e_droptrigger.test

 # 2010 November 29
 #
 # 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 51 matching lines @@
 
     CREATE TABLE aux.t3(a, b);
     INSERT INTO t3 VALUES('a', 'b');
     CREATE TRIGGER aux.tr1 BEFORE $event ON t3 BEGIN SELECT r('aux.tr1') ; END;
     CREATE TRIGGER aux.tr2 AFTER  $event ON t3 BEGIN SELECT r('aux.tr2') ; END;
     CREATE TRIGGER aux.tr3 AFTER  $event ON t3 BEGIN SELECT r('aux.tr3') ; END;
   "
 }
 
 
-# EVIDENCE-OF: R-52650-16855 -- syntax diagram drop-trigger-stmt
+# -- syntax diagram drop-trigger-stmt
 #
 do_droptrigger_tests 1.1 -repair {
   droptrigger_reopen_db
 } -tclquery {
   list_all_triggers 
 } {
   1   "DROP TRIGGER main.tr1"            
       {main.tr2 temp.tr1 aux.tr1 aux.tr2 aux.tr3}
   2   "DROP TRIGGER IF EXISTS main.tr1"  
       {main.tr2 temp.tr1 aux.tr1 aux.tr2 aux.tr3}
@@ skipping 126 matching lines @@
   execsql "DROP TABLE t1"
   list_all_triggers
 } {main.tr1 main.tr2 aux.tr1 aux.tr2 aux.tr3}
 do_test 4.4 {
   droptrigger_reopen_db
   execsql "DROP TABLE t1"
   list_all_triggers
 } {main.tr1 main.tr2 aux.tr1 aux.tr2 aux.tr3}
 
 finish_test