1 # 2007 Aug 10

     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 # 

    12 # This test script reproduces the problem reported by ticket #2565,

    13 # A database corruption bug that occurs in auto_vacuum mode when

    14 # the soft_heap_limit is set low enough to be triggered.

    15 #

    16 # $Id: softheap1.test,v 1.5 2008/07/08 17:13:59 danielk1977 Exp $

    17 

    18 

    19 set testdir [file dirname $argv0]

    20 source $testdir/tester.tcl

    21 

    22 ifcapable !integrityck {

    23   finish_test

    24   return

    25 }

    26 

    27 sqlite3_soft_heap_limit -1

    28 sqlite3_soft_heap_limit 0

    29 sqlite3_soft_heap_limit 5000

    30 do_test softheap1-1.1 {

    31   execsql {

    32     PRAGMA auto_vacuum=1;

    33     CREATE TABLE t1(x);

    34     INSERT INTO t1 VALUES(hex(randomblob(1000)));

    35     BEGIN;

    36   }

    37   execsql {

    38     CREATE TABLE t2 AS SELECT * FROM t1;

    39   }

    40   execsql {

    41     ROLLBACK;

    42   }

    43   execsql {

    44     PRAGMA integrity_check;

    45   }

    46 } {ok}

    47 

    48 sqlite3_soft_heap_limit $soft_limit

    49    

    50 finish_test