diff -r 000000000000 -r bde4ae8d615e os/persistentdata/persistentstorage/sqlite3api/TEST/TclScript/softheap1.test --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/os/persistentdata/persistentstorage/sqlite3api/TEST/TclScript/softheap1.test Fri Jun 15 03:10:57 2012 +0200 @@ -0,0 +1,50 @@ +# 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 $soft_limit + +finish_test