diff options
| author | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
|---|---|---|
| committer | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
| commit | b2057f506a09e2adef81fc77efd697d16ae14bec (patch) | |
| tree | 3affefabfe376a0ec1b3ac4a5eef957c1dd58dc8 /components/external/SQLite-3.8.1/test/savepoint7.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/savepoint7.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/savepoint7.test | 96 |
1 files changed, 0 insertions, 96 deletions
diff --git a/components/external/SQLite-3.8.1/test/savepoint7.test b/components/external/SQLite-3.8.1/test/savepoint7.test deleted file mode 100644 index bc99187d27..0000000000 --- a/components/external/SQLite-3.8.1/test/savepoint7.test +++ /dev/null @@ -1,96 +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; - 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;} - 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 {callback requested query abort} {}} - -do_test savepoint7-2.2 { - db eval {DELETE FROM t2;} - set rc [catch { - db eval {SELECT * FROM t1} { - db eval { - SAVEPOINT x2; - INSERT INTO t2 VALUES($a,$b,$c); - ROLLBACK TO x2; - } - } - } msg] - list $rc $msg [db eval {SELECT * FROM t2}] -} {1 {callback requested query abort} {}} - -finish_test |
