sl@0: # 2001 September 15
sl@0: #
sl@0: # The author disclaims copyright to this source code.  In place of
sl@0: # a legal notice, here is a blessing:
sl@0: #
sl@0: #    May you do good and not evil.
sl@0: #    May you find forgiveness for yourself and forgive others.
sl@0: #    May you share freely, never taking more than you give.
sl@0: #
sl@0: #***********************************************************************
sl@0: # This file tests that rollback journals for databases that use a 
sl@0: # page-size other than the default page-size can be rolled back Ok.
sl@0: #
sl@0: # $Id: crash6.test,v 1.2 2008/04/14 15:27:19 drh Exp $
sl@0: 
sl@0: set testdir [file dirname $argv0]
sl@0: source $testdir/tester.tcl
sl@0: 
sl@0: ifcapable !crashtest {
sl@0:   finish_test
sl@0:   return
sl@0: }
sl@0: 
sl@0: for {set ii 0} {$ii < 10} {incr ii} {
sl@0:   catch {db close}
sl@0:   file delete -force test.db test.db-journal
sl@0:   crashsql -delay 2 -file test.db {
sl@0:     PRAGMA auto_vacuum=OFF;
sl@0:     PRAGMA page_size=4096;
sl@0:     BEGIN;
sl@0:     CREATE TABLE abc AS SELECT 1 AS a, 2 AS b, 3 AS c;
sl@0:     COMMIT;
sl@0:     BEGIN;
sl@0:     CREATE TABLE def AS SELECT 1 AS d, 2 AS e, 3 AS f;
sl@0:     COMMIT;
sl@0:   }
sl@0:   sqlite3 db test.db
sl@0:   integrity_check crash6-1.$ii
sl@0: }
sl@0: 
sl@0: for {set ii 0} {$ii < 10} {incr ii} {
sl@0:   catch {db close}
sl@0:   file delete -force test.db test.db-journal
sl@0:   sqlite3 db test.db
sl@0:   execsql {
sl@0:     PRAGMA auto_vacuum=OFF;
sl@0:     PRAGMA page_size=2048;
sl@0:     BEGIN;
sl@0:     CREATE TABLE abc AS SELECT 1 AS a, 2 AS b, 3 AS c;
sl@0:     COMMIT;
sl@0:   }
sl@0:   db close
sl@0:   crashsql -delay 1 -file test.db {
sl@0:     INSERT INTO abc VALUES(5, 6, 7);
sl@0:   }
sl@0:   sqlite3 db test.db
sl@0:   integrity_check crash6-2.$ii
sl@0: }
sl@0: 
sl@0: proc signature {} {
sl@0:   return [db eval {SELECT count(*), md5sum(a), md5sum(b), md5sum(c) FROM abc}]
sl@0: }
sl@0: 
sl@0: # Test case for crashing during database sync with page-size values 
sl@0: # from 1024 to 8192.
sl@0: #
sl@0: for {set ii 0} {$ii < 30} {incr ii} {
sl@0:   db close
sl@0:   file delete -force test.db
sl@0:   sqlite3 db test.db
sl@0: 
sl@0:   set pagesize [expr 1024 << ($ii % 4)]
sl@0:   if {$pagesize>$::SQLITE_MAX_PAGE_SIZE} {
sl@0:     set pagesize $::SQLITE_MAX_PAGE_SIZE
sl@0:   }
sl@0:   do_test crash6-3.$ii.0 {
sl@0:     execsql "pragma page_size = $pagesize"
sl@0:     execsql "pragma page_size"
sl@0:   } $pagesize
sl@0: 
sl@0:   do_test crash6-3.$ii.1 {
sl@0:   
sl@0:     execsql BEGIN
sl@0:     execsql {CREATE TABLE abc(a, b, c)}
sl@0:     for {set n 0} {$n < 1000} {incr n} {
sl@0:       execsql "INSERT INTO abc VALUES($n, [expr 2*$n], [expr 3*$n])"
sl@0:     }
sl@0:     execsql {
sl@0:       INSERT INTO abc SELECT * FROM abc;
sl@0:       INSERT INTO abc SELECT * FROM abc;
sl@0:       INSERT INTO abc SELECT * FROM abc;
sl@0:       INSERT INTO abc SELECT * FROM abc;
sl@0:       INSERT INTO abc SELECT * FROM abc;
sl@0:     }
sl@0:     execsql COMMIT
sl@0:     expr ([file size test.db] / 1024) > 450
sl@0:   } {1}
sl@0: 
sl@0:   set sig [signature]
sl@0:   db close
sl@0: 
sl@0:   do_test crash6-3.$ii.2 {
sl@0:      crashsql -file test.db "
sl@0:        BEGIN;
sl@0:        SELECT random() FROM abc LIMIT $ii;
sl@0:        INSERT INTO abc SELECT randstr(10,10), 0, 0 FROM abc WHERE random()%2==0;
sl@0:        DELETE FROM abc WHERE random()%2!=0;
sl@0:        COMMIT;
sl@0:      "
sl@0:   } {1 {child process exited abnormally}}
sl@0: 
sl@0:   do_test crash6-3.$ii.3 {
sl@0:     sqlite3 db test.db
sl@0:     signature
sl@0:   } $sig
sl@0: } 
sl@0: 
sl@0: finish_test