# 2005 January 19 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: shared3.test,v 1.1 2006/05/24 12:43:28 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl db close ifcapable !shared_cache { finish_test return } set ::enable_shared_cache [sqlite3_enable_shared_cache 1] # Ticket #1824 # do_test shared3-1.1 { file delete -force test.db test.db-journal sqlite3 db1 test.db db1 eval { PRAGMA encoding=UTF16; CREATE TABLE t1(x,y); INSERT INTO t1 VALUES('abc','This is a test string'); } db1 close sqlite3 db1 test.db db1 eval {SELECT * FROM t1} } {abc {This is a test string}} do_test shared3-1.2 { sqlite3 db2 test.db db2 eval {SELECT y FROM t1 WHERE x='abc'} } {{This is a test string}} db1 close db2 close sqlite3_enable_shared_cache $::enable_shared_cache finish_test