Index: third_party/sqlite/sqlite-src-3080704/test/shared2.test |
diff --git a/third_party/sqlite/sqlite-src-3080704/test/shared2.test b/third_party/sqlite/sqlite-src-3080704/test/shared2.test |
deleted file mode 100644 |
index 5bde8cfad84371b5a1c6346e93844b1ddce55650..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3080704/test/shared2.test |
+++ /dev/null |
@@ -1,139 +0,0 @@ |
-# 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: shared2.test,v 1.8 2009/06/05 17:09:12 drh Exp $ |
- |
-set testdir [file dirname $argv0] |
-source $testdir/tester.tcl |
-source $testdir/lock_common.tcl |
-source $testdir/malloc_common.tcl |
-db close |
- |
-ifcapable !shared_cache { |
- finish_test |
- return |
-} |
-set ::enable_shared_cache [sqlite3_enable_shared_cache 1] |
- |
-# Test that if we delete all rows from a table any read-uncommitted |
-# cursors are correctly invalidated. Test on both table and index btrees. |
-do_test shared2-1.1 { |
- sqlite3 db1 test.db |
- sqlite3 db2 test.db |
- |
- # Set up some data. Table "numbers" has 64 rows after this block |
- # is executed. |
- execsql { |
- BEGIN; |
- CREATE TABLE numbers(a PRIMARY KEY, b); |
- INSERT INTO numbers(oid) VALUES(NULL); |
- INSERT INTO numbers(oid) SELECT NULL FROM numbers; |
- INSERT INTO numbers(oid) SELECT NULL FROM numbers; |
- INSERT INTO numbers(oid) SELECT NULL FROM numbers; |
- INSERT INTO numbers(oid) SELECT NULL FROM numbers; |
- INSERT INTO numbers(oid) SELECT NULL FROM numbers; |
- INSERT INTO numbers(oid) SELECT NULL FROM numbers; |
- UPDATE numbers set a = oid, b = 'abcdefghijklmnopqrstuvwxyz0123456789'; |
- COMMIT; |
- } db1 |
-} {} |
-do_test shared2-1.2 { |
- # Put connection 2 in read-uncommitted mode and start a SELECT on table |
- # 'numbers'. Half way through the SELECT, use connection 1 to delete the |
- # contents of this table. |
- execsql { |
- pragma read_uncommitted = 1; |
- } db2 |
- set count [execsql {SELECT count(*) FROM numbers} db2] |
- db2 eval {SELECT a FROM numbers ORDER BY oid} { |
- if {$a==32} { |
- execsql { |
- BEGIN; |
- DELETE FROM numbers; |
- } db1 |
- } |
- } |
- list $a $count |
-} {32 64} |
-do_test shared2-1.3 { |
- # Same test as 1.2, except scan using the index this time. |
- execsql { |
- ROLLBACK; |
- } db1 |
- set count [execsql {SELECT count(*) FROM numbers} db2] |
- db2 eval {SELECT a, b FROM numbers ORDER BY a} { |
- if {$a==32} { |
- execsql { |
- DELETE FROM numbers; |
- } db1 |
- } |
- } |
- list $a $count |
-} {32 64} |
- |
- |
-db1 close |
-db2 close |
- |
-do_test shared2-3.2 { |
- sqlite3_enable_shared_cache 1 |
-} {1} |
- |
-forcedelete test.db |
- |
-sqlite3 db test.db |
-do_test shared2-4.1 { |
- execsql { |
- CREATE TABLE t0(a, b); |
- CREATE TABLE t1(a, b DEFAULT 'hello world'); |
- } |
-} {} |
-db close |
- |
-sqlite3 db test.db |
-sqlite3 db2 test.db |
- |
-do_test shared2-4.2 { |
- execsql { SELECT a, b FROM t0 } db |
- execsql { INSERT INTO t1(a) VALUES(1) } db2 |
-} {} |
- |
-do_test shared2-4.3 { |
- db2 close |
- db close |
-} {} |
- |
-# At one point, this was causing a crash. |
-# |
-do_test shared2-5.1 { |
- sqlite3 db test.db |
- sqlite3 db2 test.db |
- execsql { CREATE TABLE t2(a, b, c) } |
- |
- # The following statement would crash when attempting to sqlite3_free() |
- # a pointer allocated from a lookaside buffer. |
- execsql { CREATE INDEX i1 ON t2(a) } db2 |
-} {} |
- |
-db close |
-db2 close |
- |
-# The following test verifies that shared-cache mode does not automatically |
-# turn on exclusive-locking mode for some reason. |
-do_multiclient_test {tn} { |
- sql1 { CREATE TABLE t1(a, b) } |
- sql2 { CREATE TABLE t2(a, b) } |
- do_test shared2-6.$tn.1 { sql1 { SELECT * FROM t2 } } {} |
- do_test shared2-6.$tn.2 { sql2 { SELECT * FROM t1 } } {} |
-} |
- |
-sqlite3_enable_shared_cache $::enable_shared_cache |
-finish_test |