Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(4)

Unified Diff: third_party/sqlite/sqlite-src-3080704/test/shared4.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 3 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: third_party/sqlite/sqlite-src-3080704/test/shared4.test
diff --git a/third_party/sqlite/sqlite-src-3080704/test/shared4.test b/third_party/sqlite/sqlite-src-3080704/test/shared4.test
deleted file mode 100644
index 83925b06e4cbf79a1d5365cb0ddffad7f629c543..0000000000000000000000000000000000000000
--- a/third_party/sqlite/sqlite-src-3080704/test/shared4.test
+++ /dev/null
@@ -1,237 +0,0 @@
-# 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
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/shared3.test ('k') | third_party/sqlite/sqlite-src-3080704/test/shared6.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698