Import SQLite 3.8.7.4.

third_party/sqlite/src/test/insert5.test

 # 2007 November 23
 #
 # 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 16 matching lines @@
 # statement includes such an opcode if a temp-table is used
 # to store intermediate results.
 # 
 proc uses_temp_table {sql} {
   return [expr {[lsearch [execsql "EXPLAIN $sql"] OpenEphemeral]>=0}]
 }
 
 # Construct the sample database.
 #
 do_test insert5-1.0 {
-  file delete -force test2.db test2.db-journal
+  forcedelete test2.db test2.db-journal
   execsql {
     CREATE TABLE MAIN(Id INTEGER, Id1 INTEGER); 
     CREATE TABLE B(Id INTEGER, Id1 INTEGER); 
     CREATE VIEW v1 AS SELECT * FROM B;
     CREATE VIEW v2 AS SELECT * FROM MAIN;
     INSERT INTO MAIN(Id,Id1) VALUES(2,3); 
     INSERT INTO B(Id,Id1) VALUES(2,3); 
   }
 } {}
 
@@ skipping 60 matching lines @@
 # } {}
 do_test insert5-2.9 {
   catchsql { 
     INSERT INTO b 
     SELECT * FROM main 
     WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
   }
 } {1 {no such column: main.id}}
 
 finish_test