Annotation of embedaddon/sqlite3/test/filefmt.test, revision 1.1.1.1
1.1 misho 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: forcedelete 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: forcedelete 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: forcedelete 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: forcedelete 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: forcedelete 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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to filefmt.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test