[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/walcrash.test

 # 2010 February 8
 #
 # 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 219 matching lines @@
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 16 */
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 20 */
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 24 */
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 28 */
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 32 */
 
       PRAGMA wal_checkpoint;
       INSERT INTO t1 VALUES(randomblob(9000));
       INSERT INTO t1 VALUES(randomblob(9000));
       INSERT INTO t1 VALUES(randomblob(9000));
+      INSERT INTO t1 VALUES(randomblob(9000));
     }
   } {1 {child process exited abnormally}}
 
   do_test walcrash-6.$i.2 {
     sqlite3 db test.db
-    execsql { SELECT count(*)==34 OR count(*)==35 FROM t1 WHERE x != 1 }
+    execsql { SELECT count(*) BETWEEN 34 AND 36 FROM t1 WHERE x != 1 }
   } {1}
   do_test walcrash-6.$i.3 { execsql { PRAGMA main.integrity_check } } {ok}
   do_test walcrash-6.$i.4 { execsql { PRAGMA main.journal_mode } } {wal}
 
   db close
 }
 
 #-------------------------------------------------------------------------
 # This test case simulates a crash while checkpointing the database. Page
 # 1 is one of the pages overwritten by the checkpoint. This is a special
@@ skipping 30 matching lines @@
     sqlite3 db test.db
     execsql { SELECT b FROM t1 WHERE a = 1 }
   } {2}
   do_test walcrash-7.$i.3 { execsql { PRAGMA main.integrity_check } } {ok}
   do_test walcrash-7.$i.4 { execsql { PRAGMA main.journal_mode } } {wal}
 
   db close
 }
 
 finish_test