Import SQLite 3.8.7.4.

third_party/sqlite/src/test/fts2o.test

 # 2007 June 20
 #
 # 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 91 matching lines @@
 } {{one three four} {one two three}}
 do_test fts2o-2.12 {
   execsql { SELECT a, b, c FROM fts_t1 WHERE c MATCH 'four'; }
 } {{one three four} {one four} {one four two}}
 
 #-------------------------------------------------------------------
 # Close, delete and reopen the database. The following test should 
 # be run on an initially empty db.
 #
 db close
-file delete -force test.db test.db-journal
+forcedelete test.db test.db-journal
 sqlite3 db test.db
 
 do_test fts2o-3.1 {
   execsql {
     CREATE VIRTUAL TABLE t1 USING fts2(a, b, c);
     INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one two');
     SELECT a, b, c FROM t1 WHERE c MATCH 'two';
   }
 } {{one three four} {one four} {one two}}
 
 # This test was crashing at one point.
 #
 do_test fts2o-3.2 {
   execsql {
     SELECT a, b, c FROM t1 WHERE c MATCH 'two';
     CREATE TABLE t3(a, b, c);
     SELECT a, b, c FROM t1 WHERE  c  MATCH 'two';
   }
 } {{one three four} {one four} {one two} {one three four} {one four} {one two}}
 
 #---------------------------------------------------------------------
 # Test that it is possible to rename an fts2 table in an attached 
 # database.
 #
-file delete -force test2.db test2.db-journal
+forcedelete test2.db test2.db-journal
 
 do_test fts2o-3.1 {
   execsql {
     ATTACH 'test2.db' AS aux;
     CREATE VIRTUAL TABLE aux.t1 USING fts2(a, b, c);
     INSERT INTO aux.t1(a, b, c) VALUES(
       'neung song sahm', 'neung see', 'neung see song'
     );
   }
 } {}
@@ skipping 12 matching lines @@
 
 do_test fts2o-3.2 {
   execsql { SELECT a, b, c FROM t2 WHERE a MATCH 'song'; }
 } {{neung song sahm} {neung see} {neung see song}}
 
 do_test fts2o-3.3 {
   execsql { SELECT a, b, c FROM t1 WHERE c MATCH 'two'; }
 } {{one three four} {one four} {one two}}
 
 finish_test