Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(171)

Unified Diff: third_party/sqlite/src/test/index7.test

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
« no previous file with comments | « third_party/sqlite/src/test/index6.test ('k') | third_party/sqlite/src/test/index8.test » ('j') | no next file with comments »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
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 {
« no previous file with comments | « third_party/sqlite/src/test/index6.test ('k') | third_party/sqlite/src/test/index8.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698