Import SQLite 3.8.7.4.

third_party/sqlite/src/test/fts3ao.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 93 matching lines @@
 } {{one three four} {one two three}}
 do_test fts3ao-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 fts3ao-3.1 {
   execsql {
     CREATE VIRTUAL TABLE t1 USING fts3(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 fts3ao-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 fts3 table in an attached 
 # database.
 #
-file delete -force test2.db test2.db-journal
+forcedelete test2.db test2.db-journal
 
 do_test fts3ao-3.1 {
   execsql {
     ATTACH 'test2.db' AS aux;
     CREATE VIRTUAL TABLE aux.t1 USING fts3(a, b, c);
     INSERT INTO aux.t1(a, b, c) VALUES(
       'neung song sahm', 'neung see', 'neung see song'
     );
   }
 } {}
@@ skipping 43 matching lines @@
 do_test fts3ao-4.7 {
   execsql {
     BEGIN;
       INSERT INTO t5 VALUES('Down came a jumbuck to drink at that billabong');
       ALTER TABLE t5 RENAME TO t6;
       INSERT INTO t6 VALUES('Down came the troopers, one, two, three');
     ROLLBACK;
     SELECT * FROM t5;
   }
 } {{the quick brown fox} {jumped over the} {lazy dog}}
+do_execsql_test fts3ao-4.8 {
+  SELECT snippet(t5, '[', ']') FROM t5 WHERE t5 MATCH 'the'
+} {{[the] quick brown fox} {jumped over [the]}}
 
 # Test that it is possible to rename an FTS4 table. Renaming an FTS4 table
 # involves renaming the extra %_docsize and %_stat tables.
 #
 do_execsql_test 5.1 {
   CREATE VIRTUAL TABLE t7 USING FTS4;
   INSERT INTO t7 VALUES('coined by a German clinician');
   SELECT count(*) FROM sqlite_master WHERE name LIKE 't7%';
   SELECT count(*) FROM sqlite_master WHERE name LIKE 't8%';
 } {6 0}
 do_execsql_test 5.2 {
   ALTER TABLE t7 RENAME TO t8;
   SELECT count(*) FROM sqlite_master WHERE name LIKE 't7%';
   SELECT count(*) FROM sqlite_master WHERE name LIKE 't8%';
 } {0 6}
 
+# At one point this was causing a memory leak.
+#
+foreach {tn sql} {
+  1 {}
+  2 { INSERT INTO ft(ft) VALUES('merge=2,2'); }
+} {
+  reset_db
+  do_execsql_test 6.$tn.1 "
+    CREATE TABLE t1(x);
+    CREATE VIRTUAL TABLE ft USING fts3;
+    INSERT INTO ft VALUES('hello world');
+    $sql
+  "
+
+  db close
+  sqlite3 db test.db
+  do_execsql_test 6.$tn.2 { SELECT * FROM t1 } {}
+
+  do_test 6.$tn.3 {
+    sqlite3 db2 test.db
+    db2 eval { DROP TABLE t1 }
+    db2 close
+    set stmt [sqlite3_prepare db { SELECT * FROM ft } -1 dummy]
+    sqlite3_finalize $stmt
+  } {SQLITE_OK}
+  db close
+}
+
 finish_test
-