1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
|
# 2008 May 6
#
# 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.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# This file implements tests to make sure SQLite does not crash or
# segfault if it sees a corrupt database file. It specifically focuses
# on corrupt SerialTypeLen values.
#
# $Id: corrupt6.test,v 1.2 2008/05/19 15:37:10 shane Exp $
set testdir [file dirname $argv0]
source $testdir/tester.tcl
# This module uses hard-coded offsets which do not work if the reserved_bytes
# value is nonzero.
if {[nonzero_reserved_bytes]} {finish_test; return;}
# These tests deal with corrupt database files
#
database_may_be_corrupt
# We must have the page_size pragma for these tests to work.
#
ifcapable !pager_pragmas {
finish_test
return
}
# Create a simple, small database.
#
do_test corrupt6-1.1 {
execsql {
PRAGMA auto_vacuum=OFF;
PRAGMA page_size=1024;
CREATE TABLE t1(x);
INSERT INTO t1(x) VALUES('varint32-01234567890123456789012345678901234567890123456789');
INSERT INTO t1(x) VALUES('varint32-01234567890123456789012345678901234567890123456789');
}
file size test.db
} [expr {1024*2}]
# Verify that the file format is as we expect. The page size
# should be 1024 bytes.
#
do_test corrupt6-1.2 {
hexio_get_int [hexio_read test.db 16 2]
} 1024 ;# The page size is 1024
do_test corrupt6-1.3 {
hexio_get_int [hexio_read test.db 20 1]
} 0 ;# Unused bytes per page is 0
integrity_check corrupt6-1.4
# Verify SerialTypeLen for first field of two records as we expect.
# SerialTypeLen = (len*2+12) = 60*2+12 = 132
do_test corrupt6-1.5.1 {
hexio_read test.db 1923 2
} 8103 ;# First text field size is 81 03 == 131
do_test corrupt6-1.5.2 {
hexio_read test.db 1987 2
} 8103 ;# Second text field size is 81 03 == 131
# Verify simple query results as expected.
do_test corrupt6-1.6 {
db close
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 0 {varint32 varint32} ]
integrity_check corrupt6-1.7
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Increase SerialTypeLen by 2.
do_test corrupt6-1.8.1 {
db close
hexio_write test.db 1923 8105
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Decrease SerialTypeLen by 2.
do_test corrupt6-1.8.2 {
db close
hexio_write test.db 1923 8101
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Put value of record 1 / field 1 SerialTypeLen back.
do_test corrupt6-1.8.3 {
db close
hexio_write test.db 1923 8103
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 0 {varint32 varint32} ]
integrity_check corrupt6-1.8.4
# Adjust value of record 2 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Increase SerialTypeLen by 2.
do_test corrupt6-1.9.1 {
db close
hexio_write test.db 1987 8105
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 2 / field 2 SerialTypeLen and see if the
# corruption is detected.
# Decrease SerialTypeLen by 2.
do_test corrupt6-1.9.2 {
db close
hexio_write test.db 1987 8101
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Put value of record 1 / field 2 SerialTypeLen back.
do_test corrupt6-1.9.3 {
db close
hexio_write test.db 1987 8103
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 0 {varint32 varint32} ]
integrity_check corrupt6-1.9.4
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF 7F (2 bytes)
do_test corrupt6-1.10.1 {
db close
hexio_write test.db 1923 FF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF 7F (3 bytes)
do_test corrupt6-1.10.2 {
db close
hexio_write test.db 1923 FFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF FF 7F (4 bytes)
do_test corrupt6-1.10.3 {
db close
hexio_write test.db 1923 FFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF FF FF 7F (5 bytes)
do_test corrupt6-1.10.4 {
db close
hexio_write test.db 1923 FFFFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF FF FF FF 7F (6 bytes, and overflows).
do_test corrupt6-1.10.5 {
db close
hexio_write test.db 1923 FFFFFFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF FF FF FF FF 7F (7 bytes, and overflows).
do_test corrupt6-1.10.6 {
db close
hexio_write test.db 1923 FFFFFFFFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF FF FF FF FF FF 7F (8 bytes, and overflows).
do_test corrupt6-1.10.7 {
db close
hexio_write test.db 1923 FFFFFFFFFFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FF FF FF FF FF FF FF FF 7F (9 bytes, and overflows).
do_test corrupt6-1.10.8 {
db close
hexio_write test.db 1923 FFFFFFFFFFFFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
# Adjust value of record 1 / field 1 SerialTypeLen and see if the
# corruption is detected.
# Set SerialTypeLen to FFFF FF FF FF FF FF FF FF 7F (10 bytes, and overflows).
do_test corrupt6-1.10.9 {
db close
hexio_write test.db 1923 FFFFFFFFFFFFFFFFFF7F
sqlite3 db test.db
catchsql {
SELECT substr(x,1,8) FROM t1
}
} [list 1 {database disk image is malformed}]
finish_test
|
