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/schema5.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/schema5.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/schema5.test | 69 |
1 files changed, 0 insertions, 69 deletions
diff --git a/components/external/SQLite-3.8.1/test/schema5.test b/components/external/SQLite-3.8.1/test/schema5.test deleted file mode 100644 index 6dea5e8f5f..0000000000 --- a/components/external/SQLite-3.8.1/test/schema5.test +++ /dev/null @@ -1,69 +0,0 @@ -# 2010 September 28 -# -# 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 checks corner cases in the CREATE TABLE syntax to make -# sure that legacy syntax (syntax that is disallowed according to the -# syntax diagrams) is still accepted, so that older databases that use -# that syntax can still be read. -# - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -# Table constraints should be separated by commas, but they do not have -# to be. -# -do_test schema5-1.1 { - db eval { - CREATE TABLE t1(a,b,c, PRIMARY KEY(a) UNIQUE (a) CONSTRAINT one); - INSERT INTO t1 VALUES(1,2,3); - SELECT * FROM t1; - } -} {1 2 3} -do_test schema5-1.2 { - catchsql {INSERT INTO t1 VALUES(1,3,4);} -} {1 {column a is not unique}} -do_test schema5-1.3 { - db eval { - DROP TABLE t1; - CREATE TABLE t1(a,b,c, - CONSTRAINT one PRIMARY KEY(a) CONSTRAINT two CHECK(b<10) UNIQUE(b) - CONSTRAINT three - ); - INSERT INTO t1 VALUES(1,2,3); - SELECT * FROM t1; - } -} {1 2 3} -do_test schema5-1.4 { - catchsql {INSERT INTO t1 VALUES(10,11,12);} -} {1 {constraint two failed}} -do_test schema5-1.5 { - db eval { - DROP TABLE t1; - CREATE TABLE t1(a,b,c, - UNIQUE(a) CONSTRAINT one, - PRIMARY KEY(b,c) CONSTRAINT two - ); - INSERT INTO t1 VALUES(1,2,3); - } -} {} -do_test schema5-1.6 { - catchsql {INSERT INTO t1 VALUES(1,3,4)} -} {1 {column a is not unique}} -do_test schema5-1.7 { - catchsql {INSERT INTO t1 VALUES(10,2,3)} -} {1 {columns b, c are not unique}} - - - - - -finish_test |
