Annotation of embedaddon/sqlite3/test/attachmalloc.test, revision 1.1
1.1 ! misho 1: # 2005 September 19
! 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 implements regression tests for SQLite library. The
! 12: # focus of this script is testing the ATTACH statement and
! 13: # specifically out-of-memory conditions within that command.
! 14: #
! 15: # $Id: attachmalloc.test,v 1.10 2008/10/22 10:45:38 danielk1977 Exp $
! 16: #
! 17:
! 18: set testdir [file dirname $argv0]
! 19: source $testdir/tester.tcl
! 20:
! 21: ifcapable !memdebug||!attach {
! 22: finish_test
! 23: return
! 24: }
! 25:
! 26: source $testdir/malloc_common.tcl
! 27:
! 28: do_malloc_test attachmalloc-1 -tclprep {
! 29: catch { db close }
! 30: for {set i 2} {$i<=4} {incr i} {
! 31: catch { db$i close }
! 32: forcedelete test$i.db
! 33: forcedelete test$i.db-journal
! 34: }
! 35: } -tclbody {
! 36: if {[catch {sqlite3 db test.db}]} {
! 37: error "out of memory"
! 38: }
! 39: sqlite3_db_config_lookaside db 0 0 0
! 40: sqlite3_extended_result_codes db 1
! 41: } -sqlbody {
! 42: ATTACH 'test2.db' AS two;
! 43: CREATE TABLE two.t1(x);
! 44: ATTACH 'test3.db' AS three;
! 45: CREATE TABLE three.t1(x);
! 46: ATTACH 'test4.db' AS four;
! 47: CREATE TABLE four.t1(x);
! 48: }
! 49:
! 50: do_malloc_test attachmalloc-2 -tclprep {
! 51: forcedelete test2.db
! 52: forcedelete test2.db-journal
! 53: sqlite3 db2 test2.db
! 54: db2 eval {
! 55: CREATE TABLE t1(a, b, c);
! 56: CREATE INDEX i1 ON t1(a, b);
! 57: }
! 58: db2 close
! 59: } -sqlbody {
! 60: CREATE TABLE t1(d, e, f);
! 61: ATTACH 'test2.db' AS db1;
! 62: }
! 63:
! 64: set enable_shared_cache [sqlite3_enable_shared_cache 1]
! 65: sqlite3 dbaux test3.db
! 66: dbaux eval {SELECT * FROM sqlite_master}
! 67: do_malloc_test attachmalloc-3 -sqlbody {
! 68: SELECT * FROM sqlite_master;
! 69: ATTACH 'test3.db' AS three;
! 70: } -cleanup {
! 71: db eval { DETACH three }
! 72: }
! 73: dbaux close
! 74: sqlite3_enable_shared_cache $enable_shared_cache
! 75:
! 76:
! 77: finish_test
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>