Import SQLite 3.10.2.

third_party/sqlite/src/test/fts3aa.test

 # 2006 September 9
 #
 # 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.
 #
 #*************************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this script is testing the FTS3 module.
 #
 # $Id: fts3aa.test,v 1.1 2007/08/20 17:38:42 shess Exp $
 #
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
+set testprefix fts3aa
 
 # If SQLITE_ENABLE_FTS3 is defined, omit this file.
 ifcapable !fts3 {
   finish_test
   return
 }
 
 # Construct a full-text search table containing five keywords:
 # one, two, three, four, and five, in various combinations.  The
 # rowid for each will be a bitmask for the elements it contains.
@@ skipping 185 matching lines @@
 } {1 {unrecognized parameter: xyz = abc}}
 
 do_execsql_test fts3aa-7.4 {
   CREATE VIRTUAL TABLE t3 USING fts3(tokenize=simple, tokenize=simple);
   SELECT tokenize FROM t3;
 } {}
 do_catchsql_test fts3aa-7.5 {
   CREATE VIRTUAL TABLE t4 USING fts4(tokenize=simple, tokenize=simple);
 } {1 {unrecognized parameter: tokenize=simple}}
 
+do_execsql_test 8.0 {
+  CREATE VIRTUAL TABLE t0 USING fts4(order=desc);
+  BEGIN;
+  INSERT INTO t0(rowid, content) VALUES(1, 'abc');
+  UPDATE t0 SET docid=5 WHERE docid=1;
+  INSERT INTO t0(rowid, content) VALUES(6, 'abc');
+}
+do_execsql_test 8.1 {
+  SELECT docid FROM t0 WHERE t0 MATCH 'abc';
+} {6 5}
+do_execsql_test 8.2 {
+  SELECT docid FROM t0 WHERE t0 MATCH '"abc abc"';
+} {}
+do_execsql_test 8.3 { COMMIT }
+do_execsql_test 8.4 {
+  SELECT docid FROM t0 WHERE t0 MATCH 'abc';
+} {6 5}
+do_execsql_test 8.5 {
+  SELECT docid FROM t0 WHERE t0 MATCH '"abc abc"';
+} {}
+
 
 finish_test