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/createtab.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/createtab.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/createtab.test | 146 |
1 files changed, 0 insertions, 146 deletions
diff --git a/components/external/SQLite-3.8.1/test/createtab.test b/components/external/SQLite-3.8.1/test/createtab.test deleted file mode 100644 index 01e0b6122e..0000000000 --- a/components/external/SQLite-3.8.1/test/createtab.test +++ /dev/null @@ -1,146 +0,0 @@ -# 2007 May 02 -# -# 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 testing that it is OK to create new tables -# and indices while creating existing tables and indices. -# -# $Id: createtab.test,v 1.3 2007/09/12 17:01:45 danielk1977 Exp $ - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -ifcapable autovacuum { - set upperBound 2 -} else { - set upperBound 0 -} - -# Run these tests for all possible values of autovacuum. -# -for {set av 0} {$av<=$upperBound} {incr av} { - db close - forcedelete test.db test.db-journal - sqlite3 db test.db - - # Create a table that spans multiple pages. It is important - # that part of the database be in pages beyond the root page. - # - do_test createtab-$av.1 { - execsql "PRAGMA auto_vacuum=$av" - execsql { - PRAGMA page_size=1024; - CREATE TABLE t1(x INTEGER PRIMARY KEY, y); - INSERT INTO t1 VALUES(1, hex(randomblob(200))); - INSERT INTO t1 VALUES(2, hex(randomblob(200))); - INSERT INTO t1 VALUES(3, hex(randomblob(200))); - INSERT INTO t1 VALUES(4, hex(randomblob(200))); - SELECT count(*) FROM t1; - } - } {4} - - set isUtf16 0 - ifcapable utf16 { - set isUtf16 [expr {[execsql {PRAGMA encoding}] != "UTF-8"}] - } - - do_test createtab-$av.2 { - file size test.db - } [expr {1024*(4+($av!=0)+(${isUtf16}*2))}] - - # Start reading the table - # - do_test createtab-$av.3 { - set STMT [sqlite3_prepare db {SELECT x FROM t1} -1 TAIL] - sqlite3_step $STMT - } {SQLITE_ROW} - do_test createtab-$av.4 { - sqlite3_column_int $STMT 0 - } {1} - - # While still reading the table, create a new table. - # - do_test createtab-$av.5 { - execsql { - CREATE TABLE t2(a,b); - INSERT INTO t2 VALUES(1,2); - SELECT * FROM t2; - } - } {1 2} - - # Continue reading the original table. - # - do_test createtab-$av.6 { - sqlite3_column_int $STMT 0 - } {1} - do_test createtab-$av.7 { - sqlite3_step $STMT - } {SQLITE_ROW} - do_test createtab-$av.8 { - sqlite3_column_int $STMT 0 - } {2} - - # Do another cycle of creating a new database table while contining - # to read the original table. - # - do_test createtab-$av.11 { - execsql { - CREATE TABLE t3(a,b); - INSERT INTO t3 VALUES(4,5); - SELECT * FROM t3; - } - } {4 5} - do_test createtab-$av.12 { - sqlite3_column_int $STMT 0 - } {2} - do_test createtab-$av.13 { - sqlite3_step $STMT - } {SQLITE_ROW} - do_test createtab-$av.14 { - sqlite3_column_int $STMT 0 - } {3} - - # One more cycle. - # - do_test createtab-$av.21 { - execsql { - CREATE TABLE t4(a,b); - INSERT INTO t4 VALUES('abc','xyz'); - SELECT * FROM t4; - } - } {abc xyz} - do_test createtab-$av.22 { - sqlite3_column_int $STMT 0 - } {3} - do_test createtab-$av.23 { - sqlite3_step $STMT - } {SQLITE_ROW} - do_test createtab-$av.24 { - sqlite3_column_int $STMT 0 - } {4} - - # Finish reading. Do an integrity check on the database. - # - do_test createtab-$av.30 { - sqlite3_step $STMT - } {SQLITE_DONE} - do_test createtab-$av.31 { - sqlite3_finalize $STMT - } {SQLITE_OK} - do_test createtab-$av.32 { - execsql { - SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1 - } - } {t1 t2 t3 t4} - integrity_check createtab-$av.40 - -} - -finish_test |
