Index: third_party/sqlite/sqlite-src-3080704/test/savepoint7.test |
diff --git a/third_party/sqlite/sqlite-src-3080704/test/savepoint7.test b/third_party/sqlite/sqlite-src-3080704/test/savepoint7.test |
deleted file mode 100644 |
index d8a02f1f801c0159b83cad75309835723ab4fbef..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3080704/test/savepoint7.test |
+++ /dev/null |
@@ -1,98 +0,0 @@ |
-# 2012 March 31 |
-# |
-# 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. |
-# |
-#*********************************************************************** |
-# |
-# Focus on the interaction between RELEASE and ROLLBACK TO with |
-# pending query aborts. See ticket [27ca74af3c083f787a1c44b11fbb7c53bdbbcf1e]. |
-# |
- |
-set testdir [file dirname $argv0] |
-source $testdir/tester.tcl |
- |
-# The RELEASE of an inner savepoint should not effect pending queries. |
-# |
-do_test savepoint7-1.1 { |
- db eval { |
- CREATE TABLE t1(a,b,c); |
- CREATE TABLE t2(x,y,z); |
- INSERT INTO t1 VALUES(1,2,3); |
- INSERT INTO t1 VALUES(4,5,6); |
- INSERT INTO t1 VALUES(7,8,9); |
- SAVEPOINT x1; |
- } |
- db eval {SELECT * FROM t1} { |
- db eval { |
- SAVEPOINT x2; |
- CREATE TABLE IF NOT EXISTS t3(xyz); |
- INSERT INTO t2 VALUES($a,$b,$c); |
- RELEASE x2; |
- } |
- } |
- db eval {SELECT * FROM t2; RELEASE x1} |
-} {1 2 3 4 5 6 7 8 9} |
- |
-do_test savepoint7-1.2 { |
- db eval {DELETE FROM t2;} |
- db eval {SELECT * FROM t1} { |
- db eval { |
- SAVEPOINT x2; |
- INSERT INTO t2 VALUES($a,$b,$c); |
- RELEASE x2; |
- } |
- } |
- db eval {SELECT * FROM t2;} |
-} {1 2 3 4 5 6 7 8 9} |
- |
-do_test savepoint7-1.3 { |
- db eval {DELETE FROM t2; BEGIN;} |
- db eval {SELECT * FROM t1} { |
- db eval { |
- SAVEPOINT x2; |
- INSERT INTO t2 VALUES($a,$b,$c); |
- RELEASE x2; |
- } |
- } |
- db eval {SELECT * FROM t2; ROLLBACK;} |
-} {1 2 3 4 5 6 7 8 9} |
- |
-# However, a ROLLBACK of an inner savepoint will abort all queries, including |
-# queries in outer contexts. |
-# |
-do_test savepoint7-2.1 { |
- db eval {DELETE FROM t2; SAVEPOINT x1; CREATE TABLE t4(abc);} |
- set rc [catch { |
- db eval {SELECT * FROM t1} { |
- db eval { |
- SAVEPOINT x2; |
- INSERT INTO t2 VALUES($a,$b,$c); |
- ROLLBACK TO x2; |
- } |
- } |
- } msg] |
- db eval {RELEASE x1} |
- list $rc $msg [db eval {SELECT * FROM t2}] |
-} {1 {abort due to ROLLBACK} {}} |
- |
-do_test savepoint7-2.2 { |
- db eval {DELETE FROM t2;} |
- set rc [catch { |
- db eval {SELECT * FROM t1} { |
- db eval { |
- SAVEPOINT x2; |
- CREATE TABLE t5(pqr); |
- INSERT INTO t2 VALUES($a,$b,$c); |
- ROLLBACK TO x2; |
- } |
- } |
- } msg] |
- list $rc $msg [db eval {SELECT * FROM t2}] |
-} {1 {abort due to ROLLBACK} {}} |
- |
-finish_test |