Annotation of embedaddon/sqlite3/test/attachmalloc.test, revision 1.1.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>