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>