diff options
Diffstat (limited to 'test/shared4.test')
| -rw-r--r-- | test/shared4.test | 237 |
1 files changed, 237 insertions, 0 deletions
diff --git a/test/shared4.test b/test/shared4.test new file mode 100644 index 0000000..83925b0 --- /dev/null +++ b/test/shared4.test @@ -0,0 +1,237 @@ +# 2008 July 14 +# +# 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. +# +#*********************************************************************** +# +# Test the btree mutex protocol for shared cache mode. +# +# $Id: shared4.test,v 1.2 2008/08/04 03:51:24 danielk1977 Exp $ + +set testdir [file dirname $argv0] +source $testdir/tester.tcl +db close +puts hello + +# This script is only valid if we are running shared-cache mode in a +# threadsafe-capable database engine. +# +ifcapable !shared_cache||!compound { + finish_test + return +} +set ::enable_shared_cache [sqlite3_enable_shared_cache 1] + +# Prepare multiple databases in shared cache mode. +# +do_test shared4-1.1 { + forcedelete test1.db test1.db-journal + forcedelete test2.db test2.db-journal + forcedelete test3.db test3.db-journal + forcedelete test4.db test4.db-journal + sqlite3 db1 test1.db + sqlite3 db2 test2.db + sqlite3 db3 test3.db + sqlite3 db4 test4.db + db1 eval { + CREATE TABLE t1(a); + INSERT INTO t1 VALUES(111); + } + db2 eval { + CREATE TABLE t2(b); + INSERT INTO t2 VALUES(222); + } + db3 eval { + CREATE TABLE t3(c); + INSERT INTO t3 VALUES(333); + } + db4 eval { + CREATE TABLE t4(d); + INSERT INTO t4 VALUES(444); + } + db1 eval { + ATTACH DATABASE 'test2.db' AS two; + ATTACH DATABASE 'test3.db' AS three; + ATTACH DATABASE 'test4.db' AS four; + } + db2 eval { + ATTACH DATABASE 'test4.db' AS four; + ATTACH DATABASE 'test3.db' AS three; + ATTACH DATABASE 'test1.db' AS one; + } + db3 eval { + ATTACH DATABASE 'test1.db' AS one; + ATTACH DATABASE 'test2.db' AS two; + ATTACH DATABASE 'test4.db' AS four; + } + db4 eval { + ATTACH DATABASE 'test3.db' AS three; + ATTACH DATABASE 'test2.db' AS two; + ATTACH DATABASE 'test1.db' AS one; + } + db1 eval { + SELECT a FROM t1 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT d FROM t4; + } +} {111 222 333 444} +do_test shared4-1.2 { + db2 eval { + SELECT a FROM t1 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT c FROM t3; + } +} {111 222 444 333} +do_test shared4-1.3 { + db3 eval { + SELECT a FROM t1 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT d FROM t4; + } +} {111 333 222 444} +do_test shared4-1.4 { + db4 eval { + SELECT a FROM t1 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT b FROM t2; + } +} {111 333 444 222} +do_test shared4-1.5 { + db3 eval { + SELECT a FROM t1 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT c FROM t3; + } +} {111 444 222 333} +do_test shared4-1.6 { + db4 eval { + SELECT a FROM t1 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT b FROM t2; + } +} {111 444 333 222} +do_test shared4-1.7 { + db1 eval { + SELECT b FROM t2 UNION ALL + SELECT a FROM t1 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT d FROM t4; + } +} {222 111 333 444} +do_test shared4-1.8 { + db2 eval { + SELECT b FROM t2 UNION ALL + SELECT a FROM t1 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT c FROM t3; + } +} {222 111 444 333} +do_test shared4-1.9 { + db3 eval { + SELECT b FROM t2 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT a FROM t1 UNION ALL + SELECT d FROM t4; + } +} {222 333 111 444} +do_test shared4-1.10 { + db4 eval { + SELECT b FROM t2 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT a FROM t1; + } +} {222 333 444 111} +do_test shared4-1.11 { + db1 eval { + SELECT c FROM t3 UNION ALL + SELECT a FROM t1 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT d FROM t4; + } +} {333 111 222 444} +do_test shared4-1.12 { + db2 eval { + SELECT c FROM t3 UNION ALL + SELECT a FROM t1 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT b FROM t2; + } +} {333 111 444 222} + +do_test shared4-2.1 { + db1 eval { + UPDATE t1 SET a=a+1000; + UPDATE t2 SET b=b+2000; + UPDATE t3 SET c=c+3000; + UPDATE t4 SET d=d+4000; + } + db2 eval { + UPDATE t1 SET a=a+10000; + UPDATE t2 SET b=b+20000; + UPDATE t3 SET c=c+30000; + UPDATE t4 SET d=d+40000; + } + db3 eval { + UPDATE t1 SET a=a+100000; + UPDATE t2 SET b=b+200000; + UPDATE t3 SET c=c+300000; + UPDATE t4 SET d=d+400000; + } + db4 eval { + UPDATE t1 SET a=a+1000000; + UPDATE t2 SET b=b+2000000; + UPDATE t3 SET c=c+3000000; + UPDATE t4 SET d=d+4000000; + } + db1 eval { + SELECT a FROM t1 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT d FROM t4; + } +} {1111111 2222222 3333333 4444444} +do_test shared4-2.2 { + db2 eval { + SELECT a FROM t1 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT c FROM t3; + } +} {1111111 2222222 4444444 3333333} +do_test shared4-2.3 { + db3 eval { + SELECT a FROM t1 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT b FROM t2 UNION ALL + SELECT d FROM t4; + } +} {1111111 3333333 2222222 4444444} +do_test shared4-2.4 { + db4 eval { + SELECT a FROM t1 UNION ALL + SELECT c FROM t3 UNION ALL + SELECT d FROM t4 UNION ALL + SELECT b FROM t2; + } +} {1111111 3333333 4444444 2222222} + + +db1 close +db2 close +db3 close +db4 close + +sqlite3_enable_shared_cache $::enable_shared_cache +finish_test |