Import SQLite 3.8.7.4.

third_party/sqlite/src/test/attach2.test

 # 2003 July 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 15 matching lines @@
 # Ticket #354
 #
 # Databases test.db and test2.db contain identical schemas.  Make
 # sure we can attach test2.db from test.db.
 #
 do_test attach2-1.1 {
   db eval {
     CREATE TABLE t1(a,b);
     CREATE INDEX x1 ON t1(a);
   }
-  file delete -force test2.db
-  file delete -force test2.db-journal
+  forcedelete test2.db
+  forcedelete test2.db-journal
   sqlite3 db2 test2.db
   db2 eval {
     CREATE TABLE t1(a,b);
     CREATE INDEX x1 ON t1(a);
   }
   catchsql {
     ATTACH 'test2.db' AS t2;
   }
 } {0 {}}
 
@@ skipping 272 matching lines @@
 } {1 2}
 do_test attach2-4.14 {
   execsql {INSERT INTO t1 VALUES(1, 2)}
 } {}
 do_test attach2-4.15 {
   execsql {SELECT * FROM t1} db2
 } {1 2 1 2}
 
 db close
 db2 close
-file delete -force test2.db
+forcedelete test2.db
 sqlite3_soft_heap_limit $soft_limit
 
 # These tests - attach2-5.* - check that the master journal file is deleted
 # correctly when a multi-file transaction is committed or rolled back.
 #
 # Update: It's not actually created if a rollback occurs, so that test
 # doesn't really prove too much.
-foreach f [glob test.db*] {file delete -force $f}
+foreach f [glob test.db*] {forcedelete $f}
 do_test attach2-5.1 {
   sqlite3 db test.db
   execsql {
     ATTACH 'test.db2' AS aux;
   }
 } {}
 do_test attach2-5.2 {
   execsql {
     BEGIN;
     CREATE TABLE tbl(a, b, c);
@@ skipping 21 matching lines @@
   execsql {
     BEGIN;
   }
 } {}
 do_test attach2-6.2 {
   catchsql {
     ATTACH 'test3.db' as aux2;
   }
 } {1 {cannot ATTACH database within transaction}}
 
+# EVIDENCE-OF: R-59740-55581 This statement will fail if SQLite is in
+# the middle of a transaction.
+#
 do_test attach2-6.3 {
   catchsql {
     DETACH aux;
   }
 } {1 {cannot DETACH database within transaction}}
 do_test attach2-6.4 {
   execsql {
     COMMIT;
     DETACH aux;
   }
 } {}
 
 db close
 
 finish_test