Import SQLite 3.8.7.4.

third_party/sqlite/src/test/shared2.test

 # 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.
 #
 #***********************************************************************
@@ skipping 61 matching lines @@
   db2 eval {SELECT a, b FROM numbers ORDER BY a} {
     if {$a==32} {
       execsql {
         DELETE FROM numbers;
       } db1
     }
   }
   list $a $count
 } {32 64}
 
-#---------------------------------------------------------------------------
-# These tests, shared2.2.*, test the outcome when data is added to or 
-# removed from a table due to a rollback while a read-uncommitted 
-# cursor is scanning it.
-#
-do_test shared2-2.1 {
-  execsql {
-    INSERT INTO numbers VALUES(1, 'Medium length text field');
-    INSERT INTO numbers VALUES(2, 'Medium length text field');
-    INSERT INTO numbers VALUES(3, 'Medium length text field');
-    INSERT INTO numbers VALUES(4, 'Medium length text field');
-    BEGIN;
-    DELETE FROM numbers WHERE (a%2)=0;
-  } db1
-  set res [list]
-  db2 eval {
-    SELECT a FROM numbers ORDER BY a;
-  } {
-    lappend res $a
-    if {$a==3} {
-      execsql {ROLLBACK} db1
-    }
-  }
-  set res
-} {1 3 4}
-do_test shared2-2.2 {
-  execsql {
-    BEGIN;
-    INSERT INTO numbers VALUES(5, 'Medium length text field');
-    INSERT INTO numbers VALUES(6, 'Medium length text field');
-  } db1
-  set res [list]
-  db2 eval {
-    SELECT a FROM numbers ORDER BY a;
-  } {
-    lappend res $a
-    if {$a==5} {
-      execsql {ROLLBACK} db1
-    }
-  }
-  set res
-} {1 2 3 4 5}
 
 db1 close
 db2 close
 
 do_test shared2-3.2 {
   sqlite3_enable_shared_cache 1
 } {1}
 
-file delete -force test.db
+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
 
@@ skipping 29 matching lines @@
 # 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