Import SQLite 3.8.7.4.

third_party/sqlite/src/test/alter2.test

 # 2005 February 18
 #
 # 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 119 matching lines @@
   }
 } {1 2 10}
 do_test alter2-1.8 {
   execsql {
     SELECT sum(a), c FROM abc GROUP BY c;
   }
 } {8 {} 1 10}
 do_test alter2-1.9 {
   # ALTER TABLE abc ADD COLUMN d;
   alter_table abc {CREATE TABLE abc(a, b, c, d);}
+  if {[permutation] == "prepare"} { db cache flush }
   execsql { SELECT * FROM abc; }
   execsql {
     UPDATE abc SET d = 11 WHERE c IS NULL AND a<4;
     SELECT * FROM abc;
   }
 } {1 2 10 {} 3 4 {} 11 5 6 {} {}}
 do_test alter2-1.10 {
   execsql {
     SELECT typeof(d) FROM abc;
   }
@@ skipping 157 matching lines @@
 # databases are still created with file-format 1.
 #
 do_test alter2-6.1 {
   db close
   set_file_format 2
   sqlite3 db test.db
   get_file_format
 } {2}
 ifcapable attach {
   do_test alter2-6.2 {
-    file delete -force test2.db-journal
-    file delete -force test2.db
+    forcedelete test2.db-journal
+    forcedelete test2.db
     execsql {
       ATTACH 'test2.db' AS aux;
       CREATE TABLE aux.t1(a, b);
     }
     get_file_format test2.db
   } $default_file_format
 }
 do_test alter2-6.3 {
   execsql {
     CREATE TABLE t1(a, b);
@@ skipping 129 matching lines @@
     }
   } {a b d}
   do_test alter2-10.4 {
     execsql {
       SELECT count(b) FROM t2 WHERE b = X'ABCD';
     }
   } {3}
 }
 
 finish_test