diff options
Diffstat (limited to 'test/softheap1.test')
-rw-r--r-- | test/softheap1.test | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/test/softheap1.test b/test/softheap1.test new file mode 100644 index 0000000..6855553 --- /dev/null +++ b/test/softheap1.test @@ -0,0 +1,49 @@ +# 2007 Aug 10 +# +# 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 test script reproduces the problem reported by ticket #2565, +# A database corruption bug that occurs in auto_vacuum mode when +# the soft_heap_limit is set low enough to be triggered. +# +# $Id: softheap1.test,v 1.5 2008/07/08 17:13:59 danielk1977 Exp $ + + +set testdir [file dirname $argv0] +source $testdir/tester.tcl + +ifcapable !integrityck { + finish_test + return +} + +sqlite3_soft_heap_limit -1 +sqlite3_soft_heap_limit 0 +sqlite3_soft_heap_limit 5000 +do_test softheap1-1.1 { + execsql { + PRAGMA auto_vacuum=1; + CREATE TABLE t1(x); + INSERT INTO t1 VALUES(hex(randomblob(1000))); + BEGIN; + } + execsql { + CREATE TABLE t2 AS SELECT * FROM t1; + } + execsql { + ROLLBACK; + } + execsql { + PRAGMA integrity_check; + } +} {ok} + +sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit) +finish_test |