sl@0: # 2008 July 14 sl@0: # sl@0: # The author disclaims copyright to this source code. In place of sl@0: # a legal notice, here is a blessing: sl@0: # sl@0: # May you do good and not evil. sl@0: # May you find forgiveness for yourself and forgive others. sl@0: # May you share freely, never taking more than you give. sl@0: # sl@0: #*********************************************************************** sl@0: # sl@0: # Test the btree mutex protocol for shared cache mode. sl@0: # sl@0: # $Id: shared4.test,v 1.2 2008/08/04 03:51:24 danielk1977 Exp $ sl@0: sl@0: set testdir [file dirname $argv0] sl@0: source $testdir/tester.tcl sl@0: db close sl@0: puts hello sl@0: sl@0: # This script is only valid if we are running shared-cache mode in a sl@0: # threadsafe-capable database engine. sl@0: # sl@0: ifcapable !shared_cache||!compound { sl@0: finish_test sl@0: return sl@0: } sl@0: set ::enable_shared_cache [sqlite3_enable_shared_cache 1] sl@0: sl@0: # Prepare multiple databases in shared cache mode. sl@0: # sl@0: do_test shared4-1.1 { sl@0: file delete -force test1.db test1.db-journal sl@0: file delete -force test2.db test2.db-journal sl@0: file delete -force test3.db test3.db-journal sl@0: file delete -force test4.db test4.db-journal sl@0: sqlite3 db1 test1.db sl@0: sqlite3 db2 test2.db sl@0: sqlite3 db3 test3.db sl@0: sqlite3 db4 test4.db sl@0: db1 eval { sl@0: CREATE TABLE t1(a); sl@0: INSERT INTO t1 VALUES(111); sl@0: } sl@0: db2 eval { sl@0: CREATE TABLE t2(b); sl@0: INSERT INTO t2 VALUES(222); sl@0: } sl@0: db3 eval { sl@0: CREATE TABLE t3(c); sl@0: INSERT INTO t3 VALUES(333); sl@0: } sl@0: db4 eval { sl@0: CREATE TABLE t4(d); sl@0: INSERT INTO t4 VALUES(444); sl@0: } sl@0: db1 eval { sl@0: ATTACH DATABASE 'test2.db' AS two; sl@0: ATTACH DATABASE 'test3.db' AS three; sl@0: ATTACH DATABASE 'test4.db' AS four; sl@0: } sl@0: db2 eval { sl@0: ATTACH DATABASE 'test4.db' AS four; sl@0: ATTACH DATABASE 'test3.db' AS three; sl@0: ATTACH DATABASE 'test1.db' AS one; sl@0: } sl@0: db3 eval { sl@0: ATTACH DATABASE 'test1.db' AS one; sl@0: ATTACH DATABASE 'test2.db' AS two; sl@0: ATTACH DATABASE 'test4.db' AS four; sl@0: } sl@0: db4 eval { sl@0: ATTACH DATABASE 'test3.db' AS three; sl@0: ATTACH DATABASE 'test2.db' AS two; sl@0: ATTACH DATABASE 'test1.db' AS one; sl@0: } sl@0: db1 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {111 222 333 444} sl@0: do_test shared4-1.2 { sl@0: db2 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT c FROM t3; sl@0: } sl@0: } {111 222 444 333} sl@0: do_test shared4-1.3 { sl@0: db3 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {111 333 222 444} sl@0: do_test shared4-1.4 { sl@0: db4 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT b FROM t2; sl@0: } sl@0: } {111 333 444 222} sl@0: do_test shared4-1.5 { sl@0: db3 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT c FROM t3; sl@0: } sl@0: } {111 444 222 333} sl@0: do_test shared4-1.6 { sl@0: db4 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT b FROM t2; sl@0: } sl@0: } {111 444 333 222} sl@0: do_test shared4-1.7 { sl@0: db1 eval { sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {222 111 333 444} sl@0: do_test shared4-1.8 { sl@0: db2 eval { sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT c FROM t3; sl@0: } sl@0: } {222 111 444 333} sl@0: do_test shared4-1.9 { sl@0: db3 eval { sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {222 333 111 444} sl@0: do_test shared4-1.10 { sl@0: db4 eval { sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT a FROM t1; sl@0: } sl@0: } {222 333 444 111} sl@0: do_test shared4-1.11 { sl@0: db1 eval { sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {333 111 222 444} sl@0: do_test shared4-1.12 { sl@0: db2 eval { sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT b FROM t2; sl@0: } sl@0: } {333 111 444 222} sl@0: sl@0: do_test shared4-2.1 { sl@0: db1 eval { sl@0: UPDATE t1 SET a=a+1000; sl@0: UPDATE t2 SET b=b+2000; sl@0: UPDATE t3 SET c=c+3000; sl@0: UPDATE t4 SET d=d+4000; sl@0: } sl@0: db2 eval { sl@0: UPDATE t1 SET a=a+10000; sl@0: UPDATE t2 SET b=b+20000; sl@0: UPDATE t3 SET c=c+30000; sl@0: UPDATE t4 SET d=d+40000; sl@0: } sl@0: db3 eval { sl@0: UPDATE t1 SET a=a+100000; sl@0: UPDATE t2 SET b=b+200000; sl@0: UPDATE t3 SET c=c+300000; sl@0: UPDATE t4 SET d=d+400000; sl@0: } sl@0: db4 eval { sl@0: UPDATE t1 SET a=a+1000000; sl@0: UPDATE t2 SET b=b+2000000; sl@0: UPDATE t3 SET c=c+3000000; sl@0: UPDATE t4 SET d=d+4000000; sl@0: } sl@0: db1 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {1111111 2222222 3333333 4444444} sl@0: do_test shared4-2.2 { sl@0: db2 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT c FROM t3; sl@0: } sl@0: } {1111111 2222222 4444444 3333333} sl@0: do_test shared4-2.3 { sl@0: db3 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT b FROM t2 UNION ALL sl@0: SELECT d FROM t4; sl@0: } sl@0: } {1111111 3333333 2222222 4444444} sl@0: do_test shared4-2.4 { sl@0: db4 eval { sl@0: SELECT a FROM t1 UNION ALL sl@0: SELECT c FROM t3 UNION ALL sl@0: SELECT d FROM t4 UNION ALL sl@0: SELECT b FROM t2; sl@0: } sl@0: } {1111111 3333333 4444444 2222222} sl@0: sl@0: sl@0: db1 close sl@0: db2 close sl@0: db3 close sl@0: db4 close sl@0: sl@0: sqlite3_enable_shared_cache $::enable_shared_cache sl@0: finish_test