Fix a problem that could cause a crash when a shared-cache schema contains column default values. (CVS 6353)
FossilOrigin-Name: afadddc34eee3d6a39102b790ce1a869b33d4286
diff --git a/test/shared2.test b/test/shared2.test
index 5f18f8b..3f14180 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 @@
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
+