wasCSharpSQLite – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 office 1 # 2001 September 15
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 # This file tests that rollback journals for databases that use a
12 # page-size other than the default page-size can be rolled back Ok.
13 #
14 # $Id: crash6.test,v 1.2 2008/04/14 15:27:19 drh Exp $
15  
16 set testdir [file dirname $argv0]
17 source $testdir/tester.tcl
18  
19 ifcapable !crashtest {
20 finish_test
21 return
22 }
23  
24 for {set ii 0} {$ii < 10} {incr ii} {
25 catch {db close}
26 file delete -force test.db test.db-journal
27 crashsql -delay 2 -file test.db {
28 PRAGMA auto_vacuum=OFF;
29 PRAGMA page_size=4096;
30 BEGIN;
31 CREATE TABLE abc AS SELECT 1 AS a, 2 AS b, 3 AS c;
32 COMMIT;
33 BEGIN;
34 CREATE TABLE def AS SELECT 1 AS d, 2 AS e, 3 AS f;
35 COMMIT;
36 }
37 sqlite3 db test.db
38 integrity_check crash6-1.$ii
39 }
40  
41 for {set ii 0} {$ii < 10} {incr ii} {
42 catch {db close}
43 file delete -force test.db test.db-journal
44 sqlite3 db test.db
45 execsql {
46 PRAGMA auto_vacuum=OFF;
47 PRAGMA page_size=2048;
48 BEGIN;
49 CREATE TABLE abc AS SELECT 1 AS a, 2 AS b, 3 AS c;
50 COMMIT;
51 }
52 db close
53 crashsql -delay 1 -file test.db {
54 INSERT INTO abc VALUES(5, 6, 7);
55 }
56 sqlite3 db test.db
57 integrity_check crash6-2.$ii
58 }
59  
60 proc signature {} {
61 return [db eval {SELECT count(*), md5sum(a), md5sum(b), md5sum(c) FROM abc}]
62 }
63  
64 # Test case for crashing during database sync with page-size values
65 # from 1024 to 8192.
66 #
67 for {set ii 0} {$ii < 30} {incr ii} {
68 db close
69 file delete -force test.db
70 sqlite3 db test.db
71  
72 set pagesize [expr 1024 << ($ii % 4)]
73 if {$pagesize>$::SQLITE_MAX_PAGE_SIZE} {
74 set pagesize $::SQLITE_MAX_PAGE_SIZE
75 }
76 do_test crash6-3.$ii.0 {
77 execsql "pragma page_size = $pagesize"
78 execsql "pragma page_size"
79 } $pagesize
80  
81 do_test crash6-3.$ii.1 {
82  
83 execsql BEGIN
84 execsql {CREATE TABLE abc(a, b, c)}
85 for {set n 0} {$n < 1000} {incr n} {
86 execsql "INSERT INTO abc VALUES($n, [expr 2*$n], [expr 3*$n])"
87 }
88 execsql {
89 INSERT INTO abc SELECT * FROM abc;
90 INSERT INTO abc SELECT * FROM abc;
91 INSERT INTO abc SELECT * FROM abc;
92 INSERT INTO abc SELECT * FROM abc;
93 INSERT INTO abc SELECT * FROM abc;
94 }
95 execsql COMMIT
96 expr ([file size test.db] / 1024) > 450
97 } {1}
98  
99 set sig [signature]
100 db close
101  
102 do_test crash6-3.$ii.2 {
103 crashsql -file test.db "
104 BEGIN;
105 SELECT random() FROM abc LIMIT $ii;
106 INSERT INTO abc SELECT randstr(10,10), 0, 0 FROM abc WHERE random()%2==0;
107 DELETE FROM abc WHERE random()%2!=0;
108 COMMIT;
109 "
110 } {1 {child process exited abnormally}}
111  
112 do_test crash6-3.$ii.3 {
113 sqlite3 db test.db
114 signature
115 } $sig
116 }
117  
118 finish_test