[sql] Import SQLite 3.17.0.

third_party/sqlite/src/ext/fts5/test/fts5ad.test

 # 2014 June 17
 #
 # 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 FTS5 module.
 #
+# More specifically, the focus is on testing prefix queries, both with and
+# without prefix indexes.
 #
 
 source [file join [file dirname [info script]] fts5_common.tcl]
 set testprefix fts5ad
 
 # If SQLITE_ENABLE_FTS5 is defined, omit this file.
 ifcapable !fts5 {
   finish_test
   return
 }
 
+foreach_detail_mode $testprefix {
+
 do_execsql_test 1.0 {
-  CREATE VIRTUAL TABLE yy USING fts5(x, y);
+  CREATE VIRTUAL TABLE yy USING fts5(x, y, detail=%DETAIL%);
   INSERT INTO yy VALUES('Changes the result to be', 'the list of all matching');
   INSERT INTO yy VALUES('indices (or all  matching', 'values if -inline is');
   INSERT INTO yy VALUES('specified as  well.) If', 'indices are returned, the');
 } {}
 
 foreach {tn match res} {
   1 {c*} {1}
   2 {i*} {3 2}
   3 {t*} {3 1}
   4 {r*} {3 1}
 } {
   do_execsql_test 1.$tn {
     SELECT rowid FROM yy WHERE yy MATCH $match ORDER BY rowid DESC
   } $res
 }
 
 foreach {tn match res} {
   5 {c*} {1}
   6 {i*} {2 3}
   7 {t*} {1 3}
   8 {r*} {1 3}
 } {
   do_execsql_test 1.$tn {
     SELECT rowid FROM yy WHERE yy MATCH $match
   } $res
 }
 
 foreach {T create} {
   2 {
-    CREATE VIRTUAL TABLE t1 USING fts5(a, b);
+    CREATE VIRTUAL TABLE t1 USING fts5(a, b, detail=%DETAIL%);
     INSERT INTO t1(t1, rank) VALUES('pgsz', 32);
   }
   
   3 {
-    CREATE VIRTUAL TABLE t1 USING fts5(a, b, prefix=1,2,3,4,5);
+    CREATE VIRTUAL TABLE t1 USING fts5(a, b, prefix="1,2,3,4", detail=%DETAIL%);
     INSERT INTO t1(t1, rank) VALUES('pgsz', 32);
   }
 
   4 {
-    CREATE VIRTUAL TABLE t1 USING fts5(a, b);
+    CREATE VIRTUAL TABLE t1 USING fts5(a, b, detail=%DETAIL%);
     INSERT INTO t1(t1, rank) VALUES('pgsz', 32);
     BEGIN;
   }
   
   5 {
-    CREATE VIRTUAL TABLE t1 USING fts5(a, b, prefix=1,2,3,4,5);
+    CREATE VIRTUAL TABLE t1 USING fts5(a, b, prefix="1,2,3,4", detail=%DETAIL%);
     INSERT INTO t1(t1, rank) VALUES('pgsz', 32);
     BEGIN;
   }
 
 } {
 
   do_test $T.1 { 
     execsql { DROP TABLE IF EXISTS t1 }
     execsql $create
   } {}
@@ skipping 145 matching lines @@
       }
       set n [llength $res]
       if {$T==5} breakpoint 
       do_execsql_test $T.$bAsc.$tn.$n $sql $res
     }
   }
 
   catchsql COMMIT
 }
 
+}
+
 finish_test