[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/index6.test

 # 2013-07-31
 #
 # 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 47 matching lines @@
 } {1 {subqueries prohibited in partial index WHERE clauses}}
 do_test index6-1.4 {
   catchsql {
     CREATE INDEX bad1 ON t1(a,b) WHERE a!=?1;
   }
 } {1 {parameters prohibited in partial index WHERE clauses}}
 do_test index6-1.5 {
   catchsql {
     CREATE INDEX bad1 ON t1(a,b) WHERE a!=random();
   }
-} {1 {functions prohibited in partial index WHERE clauses}}
+} {1 {non-deterministic functions prohibited in partial index WHERE clauses}}
 do_test index6-1.6 {
   catchsql {
     CREATE INDEX bad1 ON t1(a,b) WHERE a NOT LIKE 'abc%';
   }
-} {1 {functions prohibited in partial index WHERE clauses}}
+} {0 {}}
+do_execsql_test index6-1.7 {
+  DROP INDEX IF EXISTS bad1;
+}
 
 do_test index6-1.10 {
   execsql {
     ANALYZE;
     SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
     PRAGMA integrity_check;
   }
 } {{} 20 t1a {14 1} t1b {10 1} ok}
 
 # STAT1 shows the partial indices have a reduced number of
@@ skipping 285 matching lines @@
   SELECT e FROM t10 WHERE c=3 AND 2=b AND a=1 ORDER BY d DESC;
 } {/USING INDEX t10x/}
 do_execsql_test index6-10.3 {
   SELECT e FROM t10 WHERE a=1 AND b=2 ORDER BY d DESC;
 } {9 5}
 do_execsql_test index6-10.3eqp {
   EXPLAIN QUERY PLAN
   SELECT e FROM t10 WHERE a=1 AND b=2 ORDER BY d DESC;
 } {~/USING INDEX t10x/}
 
+# A partial index will be used for a full table scan, where possible
+do_execsql_test index6-11.1 {
+  CREATE TABLE t11(a,b,c);
+  CREATE INDEX t11x ON t11(a) WHERE b<>99;
+  EXPLAIN QUERY PLAN SELECT a FROM t11 WHERE b<>99;
+} {/USING INDEX t11x/}
+do_execsql_test index6-11.2 {
+  EXPLAIN QUERY PLAN SELECT a FROM t11 WHERE b<>99 AND c<>98;
+} {/USING INDEX t11x/}
+  
+
 finish_test