Import SQLite 3.8.7.4.

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 19 matching lines @@
 ifcapable !wal {finish_test ; return }
 
 db close
 
 set seed 0
 set REPEATS 100
 
 # walcrash-1.*
 #
 for {set i 1} {$i < $REPEATS} {incr i} {
-  file delete -force test.db test.db-wal
+  forcedelete test.db test.db-wal
   do_test walcrash-1.$i.1 {
     crashsql -delay 4 -file test.db-wal -seed [incr seed] {
       PRAGMA journal_mode = WAL;
       CREATE TABLE t1(a, b);
       INSERT INTO t1 VALUES(1, 1);
       INSERT INTO t1 VALUES(2, 3);
       INSERT INTO t1 VALUES(3, 6);
     }
   } {1 {child process exited abnormally}}
   do_test walcrash-1.$i.2 {
@@ skipping 16 matching lines @@
   integrity_check walcrash-1.$i.6
   do_test walcrash-1.$i.7 {
     execsql { PRAGMA main.journal_mode }
   } {wal}
   db close
 }
 
 # walcrash-2.*
 #
 for {set i 1} {$i < $REPEATS} {incr i} {
-  file delete -force test.db test.db-wal
+  forcedelete test.db test.db-wal
   do_test walcrash-2.$i.1 {
-    crashsql -delay 4 -file test.db-wal -seed [incr seed] {
+    crashsql -delay 5 -file test.db-wal -seed [incr seed] {
       PRAGMA journal_mode = WAL;
       CREATE TABLE t1(a PRIMARY KEY, b);
       INSERT INTO t1 VALUES(1, 2);
       INSERT INTO t1 VALUES(3, 4);
       INSERT INTO t1 VALUES(5, 9);
     }
   } {1 {child process exited abnormally}}
   do_test walcrash-2.$i.2 {
     sqlite3 db test.db
     execsql { SELECT sum(a)==max(b) FROM t1 }
@@ skipping 14 matching lines @@
   integrity_check walcrash-2.$i.6
   do_test walcrash-2.$i.6 {
     execsql { PRAGMA main.journal_mode }
   } {wal}
   db close
 }
 
 # walcrash-3.*
 #
 # for {set i 1} {$i < $REPEATS} {incr i} {
-#   file delete -force test.db test.db-wal
-#   file delete -force test2.db test2.db-wal
+#   forcedelete test.db test.db-wal
+#   forcedelete test2.db test2.db-wal
 # 
 #   do_test walcrash-3.$i.1 {
 #     crashsql -delay 2 -file test2.db-wal -seed [incr seed] {
 #       PRAGMA journal_mode = WAL;
 #       ATTACH 'test2.db' AS aux;
 #       CREATE TABLE t1(a PRIMARY KEY, b);
 #       CREATE TABLE aux.t2(a PRIMARY KEY, b);
 #       BEGIN;
 #         INSERT INTO t1 VALUES(1, 2);
 #         INSERT INTO t2 VALUES(1, 2);
@@ skipping 10 matching lines @@
 #   } {}
 #   do_test walcrash-3.$i.3 { execsql { PRAGMA main.integrity_check } } {ok}
 #   do_test walcrash-3.$i.4 { execsql { PRAGMA aux.integrity_check  } } {ok}
 # 
 #   db close
 # }
 
 # walcrash-4.*
 #
 for {set i 1} {$i < $REPEATS} {incr i} {
-  file delete -force test.db test.db-wal
-  file delete -force test2.db test2.db-wal
+  forcedelete test.db test.db-wal
+  forcedelete test2.db test2.db-wal
 
   do_test walcrash-4.$i.1 {
-    crashsql -delay 3 -file test.db-wal -seed [incr seed] -blocksize 4096 {
+    crashsql -delay 4 -file test.db-wal -seed [incr seed] -blocksize 4096 {
       PRAGMA journal_mode = WAL;
       PRAGMA page_size = 1024;
       CREATE TABLE t1(a PRIMARY KEY, b);
       INSERT INTO t1 VALUES(1, 2);
       INSERT INTO t1 VALUES(3, 4);
     }
   } {1 {child process exited abnormally}}
 
   do_test walcrash-4.$i.2 {
     sqlite3 db test.db
     execsql { 
       SELECT * FROM t1 WHERE a = 1;
     }
   } {1 2}
   do_test walcrash-4.$i.3 { execsql { PRAGMA main.integrity_check } } {ok}
   do_test walcrash-4.$i.4 { execsql { PRAGMA main.journal_mode } } {wal}
 
   db close
 }
 
 # walcrash-5.*
 #
 for {set i 1} {$i < $REPEATS} {incr i} {
-  file delete -force test.db test.db-wal
-  file delete -force test2.db test2.db-wal
+  forcedelete test.db test.db-wal
+  forcedelete test2.db test2.db-wal
 
   do_test walcrash-5.$i.1 {
-    crashsql -delay 11 -file test.db-wal -seed [incr seed] -blocksize 4096 {
+    crashsql -delay 13 -file test.db-wal -seed [incr seed] -blocksize 4096 {
       PRAGMA journal_mode = WAL;
       PRAGMA page_size = 1024;
       BEGIN;
         CREATE TABLE t1(x PRIMARY KEY);
         INSERT INTO t1 VALUES(randomblob(900));
         INSERT INTO t1 VALUES(randomblob(900));
         INSERT INTO t1 SELECT randomblob(900) FROM t1;           /* 4 */
       COMMIT;
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 8 */
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 12 */
@@ skipping 16 matching lines @@
   } {1}
   do_test walcrash-5.$i.3 { execsql { PRAGMA main.integrity_check } } {ok}
   do_test walcrash-5.$i.4 { execsql { PRAGMA main.journal_mode } } {wal}
 
   db close
 }
 
 # walcrash-6.*
 #
 for {set i 1} {$i < $REPEATS} {incr i} {
-  file delete -force test.db test.db-wal
-  file delete -force test2.db test2.db-wal
+  forcedelete test.db test.db-wal
+  forcedelete test2.db test2.db-wal
 
   do_test walcrash-6.$i.1 {
-    crashsql -delay 12 -file test.db-wal -seed [incr seed] -blocksize 512 {
+    crashsql -delay 14 -file test.db-wal -seed [incr seed] -blocksize 512 {
       PRAGMA journal_mode = WAL;
       PRAGMA page_size = 1024;
       BEGIN;
         CREATE TABLE t1(x PRIMARY KEY);
         INSERT INTO t1 VALUES(randomblob(900));
         INSERT INTO t1 VALUES(randomblob(900));
         INSERT INTO t1 SELECT randomblob(900) FROM t1;           /* 4 */
       COMMIT;
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 8 */
       INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 12 */
       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(900));
-      INSERT INTO t1 VALUES(randomblob(900));
-      INSERT INTO t1 VALUES(randomblob(900));
+      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 }
   } {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
 # case because it means the content of page 1 may be damaged. SQLite will
 # have to determine:
 #
 #   (a) that the database is a WAL database, and 
 #   (b) the database page-size
 #
 # based on the log file.
 #
 for {set i 1} {$i < $REPEATS} {incr i} {
-  file delete -force test.db test.db-wal
+  forcedelete test.db test.db-wal
 
   # Select a page-size for this test.
   #
   set pgsz [lindex {512 1024 2048 4096 8192 16384} [expr $i%6]]
 
   do_test walcrash-7.$i.1 {
     crashsql -delay 3 -file test.db -seed [incr seed] -blocksize 512 "
       PRAGMA page_size = $pgsz;
       PRAGMA journal_mode = wal;
       BEGIN;
@@ skipping 10 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
-