| OLD | NEW | 
 | (Empty) | 
|   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 |  | 
| OLD | NEW |