Index: third_party/sqlite/src/test/index7.test |
diff --git a/third_party/sqlite/src/test/index7.test b/third_party/sqlite/src/test/index7.test |
index 557fe21324d4a07db427c8b16755dbb010dc6448..0037a8a44d879c3cd46d4dc45a48aea6b0e53b9b 100644 |
--- a/third_party/sqlite/src/test/index7.test |
+++ b/third_party/sqlite/src/test/index7.test |
@@ -99,12 +99,25 @@ do_test index7-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 index7-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 index7-1.7 { |
+ INSERT INTO t1(a,b,c) |
+ VALUES('abcde',1,101),('abdef',2,102),('xyz',3,103),('abcz',4,104); |
+ SELECT c FROM t1 WHERE a NOT LIKE 'abc%' AND a=7 ORDER BY +b; |
+} {7} |
+do_execsql_test index7-1.7eqp { |
+ EXPLAIN QUERY PLAN |
+ SELECT b FROM t1 WHERE a NOT LIKE 'abc%' AND a=7 ORDER BY +b; |
+} {/SEARCH TABLE t1 USING COVERING INDEX bad1 /} |
+do_execsql_test index7-1.8 { |
+ DELETE FROM t1 WHERE c>=101; |
+ DROP INDEX IF EXISTS bad1; |
+} {} |
do_test index7-1.10 { |
execsql { |