1# 2007 April 30 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# This file contains additional out-of-memory checks (see malloc.tcl). 12# 13# $Id: mallocA.test,v 1.8 2008/02/18 22:24:58 drh Exp $ 14 15set testdir [file dirname $argv0] 16source $testdir/tester.tcl 17source $testdir/malloc_common.tcl 18 19# Only run these tests if memory debugging is turned on. 20# 21if {!$MEMDEBUG} { 22 puts "Skipping mallocA tests: not compiled with -DSQLITE_MEMDEBUG..." 23 finish_test 24 return 25} 26 27 28# Construct a test database 29# 30file delete -force test.db.bu 31db eval { 32 CREATE TABLE t1(a COLLATE NOCASE,b,c); 33 INSERT INTO t1 VALUES(1,2,3); 34 INSERT INTO t1 VALUES(1,2,4); 35 INSERT INTO t1 VALUES(2,3,4); 36 CREATE INDEX t1i1 ON t1(a); 37 CREATE INDEX t1i2 ON t1(b,c); 38 CREATE TABLE t2(x,y,z); 39} 40db close 41file copy test.db test.db.bu 42 43 44do_malloc_test mallocA-1 -testdb test.db.bu -sqlbody { 45 ANALYZE 46} 47do_malloc_test mallocA-1.1 -testdb test.db.bu -sqlbody { 48 ANALYZE t1 49} 50do_malloc_test mallocA-1.2 -testdb test.db.bu -sqlbody { 51 ANALYZE main 52} 53do_malloc_test mallocA-1.3 -testdb test.db.bu -sqlbody { 54 ANALYZE main.t1 55} 56ifcapable reindex { 57 do_malloc_test mallocA-2 -testdb test.db.bu -sqlbody { 58 REINDEX; 59 } 60 do_malloc_test mallocA-3 -testdb test.db.bu -sqlbody { 61 REINDEX t1; 62 } 63 do_malloc_test mallocA-4 -testdb test.db.bu -sqlbody { 64 REINDEX main.t1; 65 } 66 do_malloc_test mallocA-5 -testdb test.db.bu -sqlbody { 67 REINDEX nocase; 68 } 69} 70 71# Ensure that no file descriptors were leaked. 72do_test malloc-99.X { 73 catch {db close} 74 set sqlite_open_file_count 75} {0} 76 77file delete -force test.db.bu 78finish_test 79