| Index: third_party/sqlite/src/test/shared4.test
|
| diff --git a/third_party/sqlite/src/test/shared4.test b/third_party/sqlite/src/test/shared4.test
|
| new file mode 100644
|
| index 0000000000000000000000000000000000000000..f9f01738271dc5555e1086345f4e6578a20bf10a
|
| --- /dev/null
|
| +++ b/third_party/sqlite/src/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 {
|
| + file delete -force test1.db test1.db-journal
|
| + file delete -force test2.db test2.db-journal
|
| + file delete -force test3.db test3.db-journal
|
| + file delete -force 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
|
|
|