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/tempdb.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/tempdb.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/tempdb.test | 93 |
1 files changed, 0 insertions, 93 deletions
diff --git a/components/external/SQLite-3.8.1/test/tempdb.test b/components/external/SQLite-3.8.1/test/tempdb.test deleted file mode 100644 index ecd23d4e32..0000000000 --- a/components/external/SQLite-3.8.1/test/tempdb.test +++ /dev/null @@ -1,93 +0,0 @@ -# 2008 April 14 -# -# 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. -# -#*********************************************************************** -# This file implements regression tests for SQLite library. -# The focus of this file is in making sure that rolling back -# a statement journal works correctly. -# -# $Id: tempdb.test,v 1.4 2009/06/05 17:09:12 drh Exp $ - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -# Use a temporary database. -# -db close -sqlite3 db {} - -# Force a statement journal rollback on a database file that -# has never been opened. -# -do_test tempdb-1.1 { - execsql { - BEGIN; - CREATE TABLE t1(x UNIQUE); - CREATE TABLE t2(y); - INSERT INTO t2 VALUES('hello'); - INSERT INTO t2 VALUES(NULL); - } - # Because of the transaction, the temporary database file - # has not even been opened yet. The following statement - # will cause a statement journal rollback on this non-existant - # file. - catchsql { - INSERT INTO t1 - SELECT CASE WHEN y IS NULL THEN test_error('oops', 11) ELSE y END - FROM t2; - } -} {1 oops} - -# Verify that no writes occurred in t1. -# -do_test tempdb-1.2 { - execsql { - SELECT * FROM t1 - } -} {} - -do_test tempdb-2.1 { - # Set $::jrnl_in_memory if the journal file is expected to be in-memory. - # Similarly, set $::subj_in_memory if the sub-journal file is expected - # to be in memory. These variables are used to calculate the expected - # number of open files in the test cases below. - # - set jrnl_in_memory [expr {[permutation] eq "inmemory_journal"}] - set subj_in_memory [expr {$jrnl_in_memory || $TEMP_STORE>=2}] - - db close - sqlite3 db test.db -} {} -do_test tempdb-2.2 { - execsql { - CREATE TABLE t1 (a PRIMARY KEY, b, c); - CREATE TABLE t2 (a, b, c); - BEGIN; - INSERT INTO t1 VALUES(1, 2, 3); - INSERT INTO t1 VALUES(4, 5, 6); - INSERT INTO t2 VALUES(7, 8, 9); - INSERT INTO t2 SELECT * FROM t1; - } - catchsql { INSERT INTO t1 SELECT * FROM t2 } - set sqlite_open_file_count -} [expr 1 + (0==$jrnl_in_memory) + (0==$subj_in_memory)] -do_test tempdb-2.3 { - execsql { - PRAGMA temp_store = 'memory'; - ROLLBACK; - BEGIN; - INSERT INTO t1 VALUES(1, 2, 3); - INSERT INTO t1 VALUES(4, 5, 6); - INSERT INTO t2 SELECT * FROM t1; - } - catchsql { INSERT INTO t1 SELECT * FROM t2 } - set sqlite_open_file_count -} [expr 1 + (0==$jrnl_in_memory)] - -finish_test |
