Import SQLite 3.8.7.4.

third_party/sqlite/src/test/triggerA.test

 # 2008 February 12
 #
 # 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 174 matching lines @@
 do_test triggerA-2.10 {
   db eval {
      DELETE FROM result4;
      CREATE TRIGGER r5u INSTEAD OF UPDATE ON v5 BEGIN
        INSERT INTO result4(a,b,c,d) VALUES(old.x, old.b, new.x, new.b);
      END;
      UPDATE v5 SET b = b+9900000 WHERE x BETWEEN 3 AND 5;
      SELECT * FROM result4 ORDER BY a;
   }
 } {3 305 3 9900305 4 404 4 9900404 5 504 5 9900504}
+do_test triggerA-2.11 {
+  db eval {
+     DELETE FROM result4;
+     UPDATE v5 SET b = main.v5.b+9900000 WHERE main.v5.x BETWEEN 3 AND 5;
+     SELECT * FROM result4 ORDER BY a;
+  }
+} {3 305 3 9900305 4 404 4 9900404 5 504 5 9900504}
 
 # Only run the reamining tests if memory debugging is turned on.
 #
 ifcapable !memdebug {
    puts "Skipping triggerA malloc tests: not compiled with -DSQLITE_MEMDEBUG..."
    finish_test
    return
 }
 source $testdir/malloc_common.tcl
 
 # Save a copy of the current database configuration.
 #
 db close
-file delete -force test.db-triggerA
-file copy test.db test.db-triggerA
+forcedelete test.db-triggerA
+copy_file test.db test.db-triggerA
 sqlite3 db test.db
 
 # Run malloc tests on the INSTEAD OF trigger firing.
 #
 do_malloc_test triggerA-3 -tclprep {
   db close
-  file delete -force test.db test.db-journal
-  file copy -force test.db-triggerA test.db
+  forcedelete test.db test.db-journal
+  forcecopy test.db-triggerA test.db
   sqlite3 db test.db
   sqlite3_extended_result_codes db 1  
   db eval {SELECT * FROM v5; -- warm up the cache}
 } -sqlbody {
    DELETE FROM v5 WHERE x=5;
    UPDATE v5 SET b=b+9900000 WHERE x BETWEEN 3 AND 5;
 }
 
 # Clean up the saved database copy.
 #
-file delete -force test.db-triggerA
+forcedelete test.db-triggerA
 
 finish_test