wasCSharpSQLite – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 office 1 # 2007 April 6
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 implements regression tests for SQLite library.
12 #
13 # This file implements tests to verify database file format.
14 #
15 # $Id: filefmt.test,v 1.3 2009/06/18 11:34:43 drh Exp $
16  
17 set testdir [file dirname $argv0]
18 source $testdir/tester.tcl
19  
20 # Do not use a codec for tests in this file, as the database file is
21 # manipulated directly using tcl scripts (using the [hexio_write] command).
22 #
23 do_not_use_codec
24  
25 db close
26 file delete -force test.db test.db-journal
27  
28 # Database begins with valid 16-byte header string.
29 #
30 do_test filefmt-1.1 {
31 sqlite3 db test.db
32 db eval {CREATE TABLE t1(x)}
33 db close
34 hexio_read test.db 0 16
35 } {53514C69746520666F726D6174203300}
36  
37 # If the 16-byte header is changed, the file will not open
38 #
39 do_test filefmt-1.2 {
40 hexio_write test.db 0 54
41 set x [catch {sqlite3 db test.db} err]
42 lappend x $err
43 } {0 {}}
44 do_test filefmt-1.3 {
45 catchsql {
46 SELECT count(*) FROM sqlite_master
47 }
48 } {1 {file is encrypted or is not a database}}
49 do_test filefmt-1.4 {
50 db close
51 hexio_write test.db 0 53
52 sqlite3 db test.db
53 catchsql {
54 SELECT count(*) FROM sqlite_master
55 }
56 } {0 1}
57  
58 # The page-size is stored at offset 16
59 #
60 ifcapable pager_pragmas {
61 foreach pagesize {512 1024 2048 4096 8192 16384 32768} {
62 if {[info exists SQLITE_MAX_PAGE_SIZE]
63 && $pagesize>$SQLITE_MAX_PAGE_SIZE} continue
64 do_test filefmt-1.5.$pagesize.1 {
65 db close
66 file delete -force test.db
67 sqlite3 db test.db
68 db eval "PRAGMA auto_vacuum=OFF"
69 db eval "PRAGMA page_size=$pagesize"
70 db eval {CREATE TABLE t1(x)}
71 file size test.db
72 } [expr $pagesize*2]
73 do_test filefmt-1.5.$pagesize.2 {
74 hexio_get_int [hexio_read test.db 16 2]
75 } $pagesize
76 }
77 }
78  
79 # The page-size must be a power of 2
80 #
81 do_test filefmt-1.6 {
82 db close
83 hexio_write test.db 16 [hexio_render_int16 1025]
84 sqlite3 db test.db
85 catchsql {
86 SELECT count(*) FROM sqlite_master
87 }
88 } {1 {file is encrypted or is not a database}}
89  
90  
91 # The page-size must be at least 512 bytes
92 #
93 do_test filefmt-1.7 {
94 db close
95 hexio_write test.db 16 [hexio_render_int16 256]
96 sqlite3 db test.db
97 catchsql {
98 SELECT count(*) FROM sqlite_master
99 }
100 } {1 {file is encrypted or is not a database}}
101  
102 # Usable space per page (page-size minus unused space per page)
103 # must be at least 480 bytes
104 #
105 ifcapable pager_pragmas {
106 do_test filefmt-1.8 {
107 db close
108 file delete -force test.db
109 sqlite3 db test.db
110 db eval {PRAGMA page_size=512; CREATE TABLE t1(x)}
111 db close
112 hexio_write test.db 20 21
113 sqlite3 db test.db
114 catchsql {
115 SELECT count(*) FROM sqlite_master
116 }
117 } {1 {file is encrypted or is not a database}}
118 }
119  
120 #-------------------------------------------------------------------------
121 # The following block of tests - filefmt-2.* - test that versions 3.7.0
122 # and later can read and write databases that have been modified or created
123 # by 3.6.23.1 and earlier. The difference difference is that 3.7.0 stores
124 # the size of the database in the database file header, whereas 3.6.23.1
125 # always derives this from the size of the file.
126 #
127 db close
128 file delete -force test.db
129  
130 set a_string_counter 1
131 proc a_string {n} {
132 incr ::a_string_counter
133 string range [string repeat "${::a_string_counter}." $n] 1 $n
134 }
135 sqlite3 db test.db
136 db func a_string a_string
137  
138 do_execsql_test filefmt-2.1.1 {
139 PRAGMA page_size = 1024;
140 PRAGMA auto_vacuum = 0;
141 CREATE TABLE t1(a);
142 CREATE INDEX i1 ON t1(a);
143 INSERT INTO t1 VALUES(a_string(3000));
144 CREATE TABLE t2(a);
145 INSERT INTO t2 VALUES(1);
146 } {}
147 do_test filefmt-2.1.2 {
148 hexio_read test.db 28 4
149 } {00000009}
150  
151 do_test filefmt-2.1.3 {
152 sql36231 { INSERT INTO t1 VALUES(a_string(3000)) }
153 } {}
154  
155 do_execsql_test filefmt-2.1.4 { INSERT INTO t2 VALUES(2) } {}
156 integrity_check filefmt-2.1.5
157 do_test filefmt-2.1.6 { hexio_read test.db 28 4 } {00000010}
158  
159 db close
160 file delete -force test.db
161 sqlite3 db test.db
162 db func a_string a_string
163  
164 do_execsql_test filefmt-2.2.1 {
165 PRAGMA page_size = 1024;
166 PRAGMA auto_vacuum = 0;
167 CREATE TABLE t1(a);
168 CREATE INDEX i1 ON t1(a);
169 INSERT INTO t1 VALUES(a_string(3000));
170 CREATE TABLE t2(a);
171 INSERT INTO t2 VALUES(1);
172 } {}
173 do_test filefmt-2.2.2 {
174 hexio_read test.db 28 4
175 } {00000009}
176  
177 do_test filefmt-2.2.3 {
178 sql36231 { INSERT INTO t1 VALUES(a_string(3000)) }
179 } {}
180  
181 do_execsql_test filefmt-2.2.4 {
182 PRAGMA integrity_check;
183 BEGIN;
184 INSERT INTO t2 VALUES(2);
185 SAVEPOINT a;
186 INSERT INTO t2 VALUES(3);
187 ROLLBACK TO a;
188 } {ok}
189  
190 integrity_check filefmt-2.2.5
191 do_execsql_test filefmt-2.2.6 { COMMIT } {}
192 db close
193 sqlite3 db test.db
194 integrity_check filefmt-2.2.7
195  
196 #--------------------------------------------------------------------------
197 # Check that ticket 89b8c9ac54 is fixed. Before the fix, the SELECT
198 # statement would return SQLITE_CORRUPT. The database file was not actually
199 # corrupted, but SQLite was reporting that it was.
200 #
201 db close
202 forcedelete test.db
203 sqlite3 db test.db
204 do_execsql_test filefmt-3.1 {
205 PRAGMA auto_vacuum = 1;
206 CREATE TABLE t1(a, b);
207 } {}
208 do_test filefmt-3.2 {
209 sql36231 { DROP TABLE t1 }
210 } {}
211 do_execsql_test filefmt-3.3 {
212 SELECT * FROM sqlite_master;
213 PRAGMA integrity_check;
214 } {ok}
215  
216 finish_test