[sql] Import SQLite 3.17.0.

third_party/sqlite/src/ext/fts5/test/fts5fault4.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.
 #
 #*************************************************************************
@@ skipping 23 matching lines @@
 do_faultsim_test 1 -faults oom-* -prep {
   faultsim_restore_and_reopen
   execsql { SELECT * FROM xx }
 } -body {
   execsql { DROP TABLE xx }
 } -test {
   faultsim_test_result [list 0 {}]
 }
 
 #-------------------------------------------------------------------------
-# An OOM within an "ORDER BY rank" query.
-#
-db func rnddoc fts5_rnddoc 
-do_execsql_test 2.0 {
-  CREATE VIRTUAL TABLE xx USING fts5(x);
-  INSERT INTO xx VALUES ('abc ' || rnddoc(10));
-  INSERT INTO xx VALUES ('abc abc' || rnddoc(9));
-  INSERT INTO xx VALUES ('abc abc abc' || rnddoc(8));
-} {}
-faultsim_save_and_close
-
-do_faultsim_test 2 -faults oom-* -prep {
-  faultsim_restore_and_reopen
-  execsql { SELECT * FROM xx }
-} -body {
-  execsql { SELECT rowid FROM xx WHERE xx MATCH 'abc' ORDER BY rank }
-} -test {
-  faultsim_test_result [list 0 {3 2 1}]
-}
-
-#-------------------------------------------------------------------------
 # An OOM while "reseeking" an FTS cursor.
 #
 do_execsql_test 3.0 {
   CREATE VIRTUAL TABLE jj USING fts5(j);
   INSERT INTO jj(rowid, j) VALUES(101, 'm t w t f s s');
   INSERT INTO jj(rowid, j) VALUES(202, 't w t f s');
   INSERT INTO jj(rowid, j) VALUES(303, 'w t f');
   INSERT INTO jj(rowid, j) VALUES(404, 't');
 }
 faultsim_save_and_close
@@ skipping 25 matching lines @@
 
   WITH ii(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM ii WHERE i<10 )
   INSERT INTO x1 SELECT rnddoc(5) FROM ii;
 }
 
 set ::res [db eval {SELECT rowid, x1 FROM x1 WHERE x1 MATCH '*reads'}]
 
 do_faultsim_test 4 -faults oom-* -body {
   db eval {SELECT rowid, x, x1 FROM x1 WHERE x1 MATCH '*reads'}
 } -test {
-  faultsim_test_result {0 {0 {} 4}}
+  faultsim_test_result {0 {0 {} 3}}
 }
 
 #-------------------------------------------------------------------------
 # An OOM within a query that uses a custom rank function.
 #
 reset_db
 do_execsql_test 5.0 {
   PRAGMA encoding='utf16';
   CREATE VIRTUAL TABLE x2 USING fts5(x);
   INSERT INTO x2(rowid, x) VALUES(10, 'a b c'); -- 3
@@ skipping 289 matching lines @@
   faultsim_restore_and_reopen
   db eval { SELECT * FROM "tbl one" }
 } -body {
   db eval { ALTER TABLE "tbl one" RENAME TO "tbl two" }
 } -test {
   faultsim_test_result {0 {}}
 }
 
 finish_test