[sql] Import SQLite 3.17.0.

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

Index: third_party/sqlite/src/ext/fts5/test/fts5al.test
diff --git a/third_party/sqlite/src/ext/fts5/test/fts5al.test b/third_party/sqlite/src/ext/fts5/test/fts5al.test
index b8f8c6ebcd6fc2bcad73edc861a7d2f27080cd4d..c0dd2117dddc75850cce7c24825b1f63277fd045 100644
--- a/third_party/sqlite/src/ext/fts5/test/fts5al.test
+++ b/third_party/sqlite/src/ext/fts5/test/fts5al.test
@@ -23,8 +23,10 @@ ifcapable !fts5 {
   return
 }
 
+foreach_detail_mode $testprefix {
+
 do_execsql_test 1.1 {
-  CREATE VIRTUAL TABLE ft1 USING fts5(x);
+  CREATE VIRTUAL TABLE ft1 USING fts5(x, detail=%DETAIL%);
   SELECT * FROM ft1_config;
 } {version 4}
 
@@ -83,7 +85,7 @@ foreach {tn defn} {
 #
 
 do_execsql_test 3.1 {
-  CREATE VIRTUAL TABLE t1 USING fts5(x);
+  CREATE VIRTUAL TABLE t1 USING fts5(x, detail=%DETAIL%);
   INSERT INTO t1 VALUES('q w e r t y');
   INSERT INTO t1 VALUES('y t r e w q');
 }
@@ -122,11 +124,13 @@ do_execsql_test 3.4.1 {
   {{0 0 5}} 
 }
 
-do_execsql_test 3.4.2 {
-  SELECT insttest(t1) FROM t1 WHERE t1 MATCH 'r+e OR w'
-} {
-  {{1 0 1}}
-  {{0 0 2} {1 0 4}} 
+if {[detail_is_full]} {
+  do_execsql_test 3.4.2 {
+    SELECT insttest(t1) FROM t1 WHERE t1 MATCH 'r+e OR w'
+  } {
+    {{1 0 1}}
+    {{0 0 2} {1 0 4}} 
+  }
 }
 
 proc coltest {cmd} {
@@ -149,7 +153,7 @@ do_execsql_test 3.5.1 {
 #
 
 do_execsql_test 4.0 {
-  CREATE VIRTUAL TABLE t2 USING fts5(a, b);
+  CREATE VIRTUAL TABLE t2 USING fts5(a, b, detail=%DETAIL%);
   INSERT INTO t2 VALUES('a s h g s b j m r h', 's b p a d b b a o e');
   INSERT INTO t2 VALUES('r h n t a g r d d i', 'l d n j r c f t o q');
   INSERT INTO t2 VALUES('q k n i k c a a e m', 'c h n j p g s c i t');
@@ -218,24 +222,26 @@ proc rowidplus {cmd ival} {
 }
 sqlite3_fts5_create_function db rowidplus rowidplus
 
-do_execsql_test 4.2.1 {
-  INSERT INTO t2(t2, rank) VALUES('rank', 'rowidplus(100) ');
-  SELECT rowid, rank FROM t2 WHERE t2 MATCH 'o + q + g'
-} {
-  10 110
-}
-do_execsql_test 4.2.2 {
-  INSERT INTO t2(t2, rank) VALUES('rank', 'rowidplus(111) ');
-  SELECT rowid, rank FROM t2 WHERE t2 MATCH 'o + q + g'
-} {
-  10 121
-}
+if {[detail_is_full]} {
+  do_execsql_test 4.2.1 {
+    INSERT INTO t2(t2, rank) VALUES('rank', 'rowidplus(100) ');
+    SELECT rowid, rank FROM t2 WHERE t2 MATCH 'o + q + g'
+  } {
+    10 110
+  }
+  do_execsql_test 4.2.2 {
+    INSERT INTO t2(t2, rank) VALUES('rank', 'rowidplus(111) ');
+    SELECT rowid, rank FROM t2 WHERE t2 MATCH 'o + q + g'
+  } {
+    10 121
+  }
 
-do_execsql_test 4.2.3 {
-  SELECT rowid, rank FROM t2 
-  WHERE t2 MATCH 'o + q + g' AND rank MATCH 'rowidplus(112)'
-} {
-  10 122
+  do_execsql_test 4.2.3 {
+    SELECT rowid, rank FROM t2 
+      WHERE t2 MATCH 'o + q + g' AND rank MATCH 'rowidplus(112)'
+  } {
+    10 122
+  }
 }
 
 proc rowidmod {cmd imod} { 
@@ -243,7 +249,7 @@ proc rowidmod {cmd imod} {
 }
 sqlite3_fts5_create_function db rowidmod rowidmod
 do_execsql_test 4.3.1 {
-  CREATE VIRTUAL TABLE t3 USING fts5(x);
+  CREATE VIRTUAL TABLE t3 USING fts5(x, detail=%DETAIL%);
   INSERT INTO t3 VALUES('a one');
   INSERT INTO t3 VALUES('a two');
   INSERT INTO t3 VALUES('a three');
@@ -287,6 +293,7 @@ do_catchsql_test 4.4.4 {
   SELECT *, rank FROM t3 WHERE t3 MATCH 'a' AND rank MATCH NULL
 } {1 {parse error in rank function: }}
 
+} ;# foreach_detail_mode
 
 
 finish_test