AryaWu/sqlite

1# 2007 Aug 102#3# The author disclaims copyright to this source code.  In place of4# 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 when14# 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 19set testdir [file dirname $argv0]20source $testdir/tester.tcl21 22ifcapable !integrityck {23  finish_test24  return25}26 27# EVIDENCE-OF: R-26343-45930 This pragma invokes the28# sqlite3_soft_heap_limit64() interface with the argument N, if N is29# specified and is a non-negative integer.30#31# EVIDENCE-OF: R-64451-07163 The soft_heap_limit pragma always returns32# the same integer that would be returned by the33# sqlite3_soft_heap_limit64(-1) C-language function.34#35do_test softheap1-1.0 {36  execsql {PRAGMA soft_heap_limit}37} [sqlite3_soft_heap_limit -1]38do_test softheap1-1.1 {39  execsql {PRAGMA soft_heap_limit=123456; PRAGMA soft_heap_limit;}40} {123456 123456}41do_test softheap1-1.2 {42  sqlite3_soft_heap_limit -143} {123456}44do_test softheap1-1.3 {45  execsql {PRAGMA soft_heap_limit(-1); PRAGMA soft_heap_limit;}46} {123456 123456}47do_test softheap1-1.4 {48  execsql {PRAGMA soft_heap_limit(0); PRAGMA soft_heap_limit;}49} {0 0}50 51sqlite3_soft_heap_limit 500052do_test softheap1-2.0 {53  execsql {PRAGMA soft_heap_limit}54} {5000}55do_test softheap1-2.1 {56  execsql {57    PRAGMA auto_vacuum=1;58    CREATE TABLE t1(x);59    INSERT INTO t1 VALUES(hex(randomblob(1000)));60    BEGIN;61  }62  execsql {63    CREATE TABLE t2 AS SELECT * FROM t1;64  }65  execsql {66    ROLLBACK;67  }68  execsql {69    PRAGMA integrity_check;70  }71} {ok}72 73sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit)74finish_test75