Import SQLite 3.8.7.4.

third_party/sqlite/src/test/temptable.test

 # 2001 October 7
 #
 # 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 132 matching lines @@
   execsql {
     CREATE INDEX i2 ON t2(x);
     DROP TABLE t2;
   }
   catchsql {DROP INDEX i2}
 } {1 {no such index: i2}}
 
 # Check for correct name collision processing. A name collision can
 # occur when process A creates a temporary table T then process B
 # creates a permanent table also named T.  The temp table in process A
-# hides the existance of the permanent table.
+# hides the existence of the permanent table.
 #
 do_test temptable-4.1 {
   execsql {
     CREATE TEMP TABLE t2(x,y);
     INSERT INTO t2 VALUES(10,20);
     SELECT * FROM t2;
   } db2
 } {10 20}
 do_test temptable-4.2 {
   execsql {
@@ skipping 121 matching lines @@
 
 # Now create a temporary table in db2 and a permanent index in db.  The
 # temporary table in db2 should mask the name of the permanent index,
 # but the permanent index should still be accessible and should still
 # be updated when its corresponding table changes.
 #
 do_test temptable-5.1 {
   execsql {
     CREATE TEMP TABLE mask(a,b,c)
   } db2
+  if {[permutation]=="prepare"} { db2 cache flush }
   execsql {
     CREATE INDEX mask ON t2(x);
     SELECT * FROM t2;
   }
 } {3 4}
 #do_test temptable-5.2 {
 #  catchsql {
 #    SELECT * FROM t2;
 #  } db2
 #} {1 {database schema has changed}}
@@ skipping 91 matching lines @@
   }
 } {0 {xyzzy 1 2}}
 do_test temptable-6.8 {
   db close
   sqlite3 db test.db
   catchsql {
     SELECT * FROM t8,t9;
   }
 } {1 {no such table: t9}}
 
-file delete -force test2.db test2.db-journal
+forcedelete test2.db test2.db-journal
 ifcapable attach {
   do_test temptable-7.1 {
     catchsql {
       ATTACH 'test2.db' AS two;
       CREATE TEMP TABLE two.abc(x,y);
     }
   } {1 {temporary table name must be unqualified}}
 }
 
 # Need to do the following for tcl 8.5 on mac. On that configuration, the
-# -readonly flag is taken so seriously that a subsequent [file delete -force]
+# -readonly flag is taken so seriously that a subsequent [forcedelete]
 # (required before the next test file can be executed) will fail.
 #
 catch {file attributes test.db -readonly 0}
 
 do_test temptable-8.0 {
   db close
-  catch {file delete -force test.db}
+  catch {forcedelete test.db}
   sqlite3 db test.db
 } {}
 do_test temptable-8.1 {
   execsql { CREATE TEMP TABLE tbl2(a, b); }
   execsql {
     CREATE TABLE tbl(a, b);
     INSERT INTO tbl VALUES(1, 2);
   }
   execsql {SELECT * FROM tbl}
 } {1 2}
 do_test temptable-8.2 {
   execsql { CREATE TEMP TABLE tbl(a, b); }
   execsql {SELECT * FROM tbl}
 } {}
 
 finish_test