diff options
Diffstat (limited to 'test/shared2.test')
| -rw-r--r-- | test/shared2.test | 27 |
1 files changed, 26 insertions, 1 deletions
diff --git a/test/shared2.test b/test/shared2.test index 5f18f8b72..3f1418087 100644 --- a/test/shared2.test +++ b/test/shared2.test @@ -9,7 +9,7 @@ # #*********************************************************************** # -# $Id: shared2.test,v 1.5 2007/08/23 02:47:54 drh Exp $ +# $Id: shared2.test,v 1.6 2009/03/17 17:49:00 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -127,5 +127,30 @@ do_test shared2-3.2 { sqlite3_enable_shared_cache 1 } {1} +file delete -force test.db + +sqlite3 db test.db +do_test shared2-4.1 { + execsql { + CREATE TABLE t0(a, b); + CREATE TABLE t1(a, b DEFAULT 'hello world'); + } +} {} +db close + +sqlite3 db test.db +sqlite3 db2 test.db + +do_test shared2-4.2 { + execsql { SELECT a, b FROM t0 } db + execsql { INSERT INTO t1(a) VALUES(1) } db2 +} {} + +do_test shared2-4.3 { + db2 close + db close +} {} + sqlite3_enable_shared_cache $::enable_shared_cache finish_test + |