diff options
Diffstat (limited to 'test/filefmt.test')
| -rw-r--r-- | test/filefmt.test | 254 |
1 files changed, 254 insertions, 0 deletions
diff --git a/test/filefmt.test b/test/filefmt.test new file mode 100644 index 0000000..b44ef8e --- /dev/null +++ b/test/filefmt.test @@ -0,0 +1,254 @@ +# 2007 April 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 verify database file format. +# +# $Id: filefmt.test,v 1.3 2009/06/18 11:34:43 drh Exp $ + +set testdir [file dirname $argv0] +source $testdir/tester.tcl + +# Do not use a codec for tests in this file, as the database file is +# manipulated directly using tcl scripts (using the [hexio_write] command). +# +do_not_use_codec + +db close +forcedelete test.db test.db-journal + +# Database begins with valid 16-byte header string. +# +do_test filefmt-1.1 { + sqlite3 db test.db + db eval {CREATE TABLE t1(x)} + db close + hexio_read test.db 0 16 +} {53514C69746520666F726D6174203300} + +# If the 16-byte header is changed, the file will not open +# +do_test filefmt-1.2 { + hexio_write test.db 0 54 + set x [catch {sqlite3 db test.db} err] + lappend x $err +} {0 {}} +do_test filefmt-1.3 { + catchsql { + SELECT count(*) FROM sqlite_master + } +} {1 {file is not a database}} +do_test filefmt-1.4 { + db close + hexio_write test.db 0 53 + sqlite3 db test.db + catchsql { + SELECT count(*) FROM sqlite_master + } +} {0 1} + +# The page-size is stored at offset 16 +# +ifcapable pager_pragmas { + foreach pagesize {512 1024 2048 4096 8192 16384 32768} { + if {[info exists SQLITE_MAX_PAGE_SIZE] + && $pagesize>$SQLITE_MAX_PAGE_SIZE} continue + do_test filefmt-1.5.$pagesize.1 { + db close + forcedelete test.db + sqlite3 db test.db + db eval "PRAGMA auto_vacuum=OFF" + db eval "PRAGMA page_size=$pagesize" + db eval {CREATE TABLE t1(x)} + file size test.db + } [expr $pagesize*2] + do_test filefmt-1.5.$pagesize.2 { + hexio_get_int [hexio_read test.db 16 2] + } $pagesize + } +} + +# The page-size must be a power of 2 +# +do_test filefmt-1.6 { + db close + hexio_write test.db 16 [hexio_render_int16 1025] + sqlite3 db test.db + catchsql { + SELECT count(*) FROM sqlite_master + } +} {1 {file is not a database}} + + +# The page-size must be at least 512 bytes +# +do_test filefmt-1.7 { + db close + hexio_write test.db 16 [hexio_render_int16 256] + sqlite3 db test.db + catchsql { + SELECT count(*) FROM sqlite_master + } +} {1 {file is not a database}} + +# Usable space per page (page-size minus unused space per page) +# must be at least 480 bytes +# +ifcapable pager_pragmas { + do_test filefmt-1.8 { + db close + forcedelete test.db + sqlite3 db test.db + db eval {PRAGMA page_size=512; CREATE TABLE t1(x)} + db close + hexio_write test.db 20 21 + sqlite3 db test.db + catchsql { + SELECT count(*) FROM sqlite_master + } + } {1 {file is not a database}} +} + +#------------------------------------------------------------------------- +# The following block of tests - filefmt-2.* - test that versions 3.7.0 +# and later can read and write databases that have been modified or created +# by 3.6.23.1 and earlier. The difference difference is that 3.7.0 stores +# the size of the database in the database file header, whereas 3.6.23.1 +# always derives this from the size of the file. +# +db close +forcedelete test.db + +set a_string_counter 1 +proc a_string {n} { + incr ::a_string_counter + string range [string repeat "${::a_string_counter}." $n] 1 $n +} +sqlite3 db test.db +db func a_string a_string + +do_execsql_test filefmt-2.1.1 { + PRAGMA page_size = 1024; + PRAGMA auto_vacuum = 0; + CREATE TABLE t1(a); + CREATE INDEX i1 ON t1(a); + INSERT INTO t1 VALUES(a_string(3000)); + CREATE TABLE t2(a); + INSERT INTO t2 VALUES(1); +} {} +if {![nonzero_reserved_bytes]} { + do_test filefmt-2.1.2 { + hexio_read test.db 28 4 + } {00000009} +} + +do_test filefmt-2.1.3 { + sql36231 { INSERT INTO t1 VALUES(a_string(3000)) } +} {} + +do_execsql_test filefmt-2.1.4 { INSERT INTO t2 VALUES(2) } {} +integrity_check filefmt-2.1.5 +do_test filefmt-2.1.6 { hexio_read test.db 28 4 } {00000010} + +db close +forcedelete test.db +sqlite3 db test.db +db func a_string a_string + +do_execsql_test filefmt-2.2.1 { + PRAGMA page_size = 1024; + PRAGMA auto_vacuum = 0; + CREATE TABLE t1(a); + CREATE INDEX i1 ON t1(a); + INSERT INTO t1 VALUES(a_string(3000)); + CREATE TABLE t2(a); + INSERT INTO t2 VALUES(1); +} {} +if {![nonzero_reserved_bytes]} { + do_test filefmt-2.2.2 { + hexio_read test.db 28 4 + } {00000009} +} + +do_test filefmt-2.2.3 { + sql36231 { INSERT INTO t1 VALUES(a_string(3000)) } +} {} + +do_execsql_test filefmt-2.2.4 { + PRAGMA integrity_check; + BEGIN; + INSERT INTO t2 VALUES(2); + SAVEPOINT a; + INSERT INTO t2 VALUES(3); + ROLLBACK TO a; +} {ok} + +integrity_check filefmt-2.2.5 +do_execsql_test filefmt-2.2.6 { COMMIT } {} +db close +sqlite3 db test.db +integrity_check filefmt-2.2.7 + +#-------------------------------------------------------------------------- +# Check that ticket 89b8c9ac54 is fixed. Before the fix, the SELECT +# statement would return SQLITE_CORRUPT. The database file was not actually +# corrupted, but SQLite was reporting that it was. +# +db close +forcedelete test.db +sqlite3 db test.db +do_execsql_test filefmt-3.1 { + PRAGMA auto_vacuum = 1; + CREATE TABLE t1(a, b); +} {} +do_test filefmt-3.2 { + sql36231 { DROP TABLE t1 } +} {} +do_execsql_test filefmt-3.3 { + SELECT * FROM sqlite_master; + PRAGMA integrity_check; +} {ok} + +reset_db +do_execsql_test filefmt-4.1 { + PRAGMA auto_vacuum = 1; + CREATE TABLE t1(x, y); + CREATE TABLE t2(x, y); + + INSERT INTO t1 VALUES(randomblob(100), randomblob(100)); + INSERT INTO t1 VALUES(randomblob(100), randomblob(100)); + INSERT INTO t1 VALUES(randomblob(100), randomblob(100)); + INSERT INTO t1 VALUES(randomblob(100), randomblob(100)); + INSERT INTO t1 VALUES(randomblob(100), randomblob(100)); + INSERT INTO t1 VALUES(randomblob(100), randomblob(100)); + + INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1; + INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1; + INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1; + INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1; +} + +do_test filefmt-4.2 { + sql36231 { INSERT INTO t2 SELECT * FROM t1 } +} {} + +do_test filefmt-4.3 { + forcedelete bak.db + db backup bak.db +} {} + +do_test filefmt-4.4 { + sqlite3 db2 bak.db + db2 eval { PRAGMA integrity_check } +} {ok} +db2 close + +finish_test |