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/savepoint3.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/savepoint3.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/savepoint3.test | 136 |
1 files changed, 0 insertions, 136 deletions
diff --git a/components/external/SQLite-3.8.1/test/savepoint3.test b/components/external/SQLite-3.8.1/test/savepoint3.test deleted file mode 100644 index 0dcb0aceba..0000000000 --- a/components/external/SQLite-3.8.1/test/savepoint3.test +++ /dev/null @@ -1,136 +0,0 @@ -# 2008 December 15 -# -# 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: savepoint3.test,v 1.5 2009/06/05 17:09:12 drh Exp $ - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -source $testdir/malloc_common.tcl - -do_malloc_test savepoint3-1 -sqlprep { - CREATE TABLE t1(a, b, c); - INSERT INTO t1 VALUES(1, 2, 3); -} -sqlbody { - SAVEPOINT one; - INSERT INTO t1 VALUES(4, 5, 6); - SAVEPOINT two; - DELETE FROM t1; - ROLLBACK TO two; - RELEASE one; -} - -do_malloc_test savepoint3-2 -sqlprep { - PRAGMA cache_size = 10; - CREATE TABLE t1(a, b, c); - INSERT INTO t1 VALUES(randstr(400,400), randstr(400,400), randstr(400,400)); - INSERT INTO t1 SELECT - randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; - INSERT INTO t1 - SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1; -} -sqlbody { - PRAGMA cache_size = 10; - SAVEPOINT one; - DELETE FROM t1 WHERE rowid < 5; - SAVEPOINT two; - DELETE FROM t1 WHERE rowid > 10; - ROLLBACK TO two; - ROLLBACK TO one; - RELEASE one; -} - -do_ioerr_test savepoint3.3 -sqlprep { - CREATE TABLE t1(a, b, c); - INSERT INTO t1 VALUES(1, randstr(1000,1000), randstr(1000,1000)); - INSERT INTO t1 VALUES(2, randstr(1000,1000), randstr(1000,1000)); -} -sqlbody { - BEGIN; - UPDATE t1 SET a = 3 WHERE a = 1; - SAVEPOINT one; - UPDATE t1 SET a = 4 WHERE a = 2; - COMMIT; -} -cleanup { - db eval { - SAVEPOINT one; - RELEASE one; - } -} - -# The following test does a really big savepoint rollback. One involving -# more than 4000 pages. The idea is to get a specific sqlite3BitvecSet() -# operation in pagerPlaybackSavepoint() to fail. -#do_malloc_test savepoint3-4 -sqlprep { -# BEGIN; -# CREATE TABLE t1(a, b); -# CREATE INDEX i1 ON t1(a); -# CREATE INDEX i2 ON t1(b); -# INSERT INTO t1 VALUES(randstr(500,500), randstr(500,500)); -- 1 -# INSERT INTO t1 VALUES(randstr(500,500), randstr(500,500)); -- 2 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 4 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 8 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 16 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 32 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 64 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 128 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 256 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 512 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 1024 -# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 2048 -# COMMIT; -# BEGIN; -# SAVEPOINT abc; -# UPDATE t1 SET a = randstr(500,500); -#} -sqlbody { -# ROLLBACK TO abc; -#} - - -# Cause a specific malloc in savepoint rollback code to fail. -# -do_malloc_test savepoint3-4 -start 7 -sqlprep { - PRAGMA auto_vacuum = incremental; - PRAGMA cache_size = 1000; - - CREATE TABLE t1(a, b); - CREATE TABLE t2(a, b); - CREATE TABLE t3(a, b); - INSERT INTO t1 VALUES(1, randstr(500,500)); - INSERT INTO t1 VALUES(2, randstr(500,500)); - INSERT INTO t1 VALUES(3, randstr(500,500)); - DELETE FROM t1; - - BEGIN; - INSERT INTO t1 VALUES(1, randstr(500,500)); - INSERT INTO t1 VALUES(2, randstr(500,500)); - INSERT INTO t1 VALUES(3, randstr(500,500)); - DROP TABLE t3; -- Page 5 of the database file is now free. - DROP TABLE t2; -- Page 4 of the database file is now free. - - SAVEPOINT abc; - PRAGMA incremental_vacuum; -} -sqlbody { - ROLLBACK TO abc; -} - - -finish_test |
